启动mysql报错Can't find file: './mysql/plugin.frm'
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)
解决方法:
重启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 *