今天启动mysql数据库,后来发现服务无法启动,查看日志报错如下:
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.csdn.net/indexman/article/details/42497137