MYSQL服务无法启动 报1067 看mysql解压地址/data下 .err文件日志：InnoDB: .\ibdata1 can't be opened in read-write mode

mysql 5.6 x64解压版

2015-01-07 17:48:54 9136 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode
2015-01-07 17:48:54 9136 [ERROR] InnoDB: The system tablespace must be writable!
2015-01-07 17:48:54 9136 [ERROR] Plugin 'InnoDB' init function returned error.
2015-01-07 17:48:54 9136 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-01-07 17:48:54 9136 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-01-07 17:48:54 9136 [ERROR] Aborting

 

解决方法：

1、打开任务管理器终止mysqld进程；

2、打开mysql安装目录的data文件夹，删除以下2个文件：

 

ib_logfile0和ib_logfile1

 

3、重新启动mysql

 

转载: https://blog.youkuaiyun.com/caisinan_csdn/article/details/51393204