Mysql报错:[ERROR] InnoDB: Unable to lock ./ibdata1,error: 11,系统日志如下:
2020-05-19 09:28:19 11082 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2020-05-19 09:28:19 11082 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2020-05-19 09:28:20 11082 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2020-05-19 09:28:20 11082 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2020-05-19 09:28:21 11082 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2020-05-19 09:28:21 11082 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
分析:
错误显示无法锁定 ./ibdata1 这个文件,那么他一定是被其他的进程占用了文章来源:https://www.toymoban.com/news/detail-503635.html
解决方法:
我们可以使用 ps -aux |grep mysql*
来查询相关的进行,然后查询到PID之后,用kill命令,将其强制杀死,然后重新启动数据库即可
文章来源地址https://www.toymoban.com/news/detail-503635.html
到了这里,关于Mysql报错:[ERROR] InnoDB: Unable to lock ./ibdata1,error: 11的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!