MYSQL服务无法启动:InnoDB: .\ibdata1 can't be opened in read-write mode
来源:互联网 发布:生物本性 知乎 编辑:程序博客网 时间:2024/06/06 03:42
今天在那做实验倒腾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
--------------------------------------
Dylan Presents.
5 2
- MYSQL服务无法启动:InnoDB: .\ibdata1 can't be opened in read-write mode
- MYSQL服务无法启动:InnoDB: .\ibdata1 can't be opened in read-write mode
- MYSQL服务无法启动:InnoDB: .\ibdata1 can't be opened in read-write mode
- Mysql ./ibdata1 can't be opened in read-write mode
- 【问题解决】MYSQL 服务无法启动,错误日志:InnoDB: .\ibdata1 must be writable
- ORA-16433: The database must be opened in read/write mode
- MYSQL启动报1067错误 MySQL服务无法启动 或者Can't create/write to file#sql6e80_1905f7_3.MYI'
- MySQL服务无法启动(2003 - Can't connect to MySQL server on‘localhost' (10061).)
- MySQL服务无法启动(2003 - Can't connect to MySQL server on‘localhost' (10061).) 解决办法
- MySQL服务无法启动(2003 - Can't connect to MySQL server on‘localhost' (10038).)
- MySQL服务无法启动(2003 - Can't connect to MySQL server on‘localhost' (10038).)
- MySQL服务无法启动(2003 - Can't connect to MySQL server on‘localhost' (10061).)
- MySQL服务无法启动(2003 - Can't connect to MySQL server on‘localhost' (10061).)
- MySQL 服务无法启动 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- mysql服务已经启动但是无法进行连接(can't connect to mysql 1055)
- mysql启动报错Can't read from messagefile处理
- SVN无法提交 Can't set file "/db/txn_current" read-write :拒绝访问
- MYSQL:Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'
- 总结iOS 8和Xcode 6的各种坑
- 我的切图方法最佳实践
- 扒光葡萄游戏厅私密数据,看智能电视游戏用户在干啥?
- 技术人攻略访谈三十九-HTML5社区田爱娜:女神哪有天生,坚守就是一切
- Android 自定义漂亮的圆形进度条
- MYSQL服务无法启动:InnoDB: .\ibdata1 can't be opened in read-write mode
- 按需加载的模拟
- Java 线程
- android的content provider之二:添加数据库属性及用ContentObserver实现数据库的监听
- Shell脚本监控Storm集群,邮件报警
- Android 长图自动循环播放
- 改变UITableView的headerView、footerView背景颜色
- CSS3与HTML5收集
- 攻城狮都应当知道的——编译器的工作过程