[ERROR] InnoDB: /opt/lampp/var/data/ibdata1 can't be opened in read-write mode

莫薇

于 2019-02-25 21:39:09 发布

阅读量979

点赞数

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.csdn.net/jing_flower/article/details/79963757

版权

本文记录了在遇到MySQL InnoDB错误：/opt/lampp/var/data/ibdata1 can't be opened in read-write mode时的解决过程。通过修改文件夹权限，如使用`chown -R mysql.mysql data`，以及重新启动数据库服务，成功解决了问题。

摘要由CSDN通过智能技术生成

恢复后修改文件夹权限：

chown -R mysql.mysql data

备份恢复后启动数据库

/opt/lampp/sbin/mysqld --defaults-file=/opt/lampp/etc/my.cnf --user=root &

2018-04-16 17:32:31 140001994162432 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-04-16 17:32:31 140001994162432 [Note] InnoDB: The InnoDB memory heap is disabled
2018-04-16 17:32:31 140001994162432 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-04-16 17:32:31 140001994162432 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-04-16 17:32:31 140001994162432 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-04-16 17:32:31 140001994162432 [Note] InnoDB: Using SSE crc32 instructions
2018-04-16 17:32:31 140001994162432 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2018-04-16 17:32:31 140001994162432 [Note] InnoDB: Completed initialization of buffer pool
2018-04-16 17:32:31 140001