mysql服务启动失败 查看日志Can't open the mysql.plugin table异常

Question

/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist

170812 14:33:08 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

170812 14:33:08  InnoDB: Initializing buffer pool, size = 8.0M

170812 14:33:08  InnoDB: Completed initialization of buffer pool

170812 14:33:08  InnoDB: Started; log sequence number 0 44233

170812 14:33:08 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

170812 14:33:08 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

Answer 1

Geely 2017-08-12 19:07:51

hi 同学你好，这个估计是安装mysql的时候权限不对，导致mysql.plugin这个表没有安装上。

建议卸载mysql，重新安装试试看，如果安装正确，这个表是在mysql初始化的时候就会ok的~~

或者还有一个办法，在qq群里找同学要一个安装ok的同学，要这个表过来，然后query中create上这个表即可。当然要用mysql的root权限哟~~

• 提问者 lester丶 #1

  非常感谢！