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

来源:互联网 发布:怎么看oracle的端口号 编辑:程序博客网 时间:2024/05/22 00:23
启动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成功。
阅读全文
0 0