启动mysql报错Can't find file: './mysql/plugin.frm'

本文主要是介绍启动mysql报错Can't find file: './mysql/plugin.frm'，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

启动mysql报错Can't find file: './mysql/plugin.frm'

重启mysql以后突然报错，详情如下：

171122 19:08:18 [ERROR] mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
171122 19:08:18 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
171122 19:08:18 [Note] Server socket created on IP: '0.0.0.0'.
171122 19:08:18 [ERROR] mysqld: Can't find file: './mysql/host.frm' (errno: 13)
171122 19:08:18 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)

解决方法：

进入plugin.frm所在目录，我的是在

/var/lib/mysql/mysql

ls -l

发现所有文件的权限不知何故都变成root了，执行下面命令，修改权限为mysql

chown mysql.mysql *

重启mysql成功。

这篇关于启动mysql报错Can't find file: './mysql/plugin.frm'的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---