MySQL 启动异常:Can't open the mysql.plugin table. Please run mysql_upgrade to create

MySQL 启动报错:

1
090517 13:34:15 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.090517 13:34:15 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist090517 13:34:15 mysqld_safe mysqld from pid file /usr/local/mysql/var/mail.bmitwap.com.pid ended090517 13:38:35 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var

解决方法:

根据 error 中的提示 我们可以使用 mysql_upgrade 来修复问题

运行如下命令

1
mysql_install_db --user=mysql

运行后,出现如下返回:

然后再启动即可

1
service mysql start
hoxis wechat
提供 CSDN 资料免费下载服务,欢迎来撩~
赞赏一杯咖啡
0%