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

发表于 | 分类于 | | 阅读次数:
字数统计: 128 | 阅读时长 ≈ 1

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
一个脱离了高级趣味的程序员，关注回复1024有惊喜~
赞赏一杯咖啡
0%