MySQL 启动报错 Table 'mysql.plugin' doesn't exist

来源:清泛原创     2016-08-04 23:18:49    人气:     我有话说( 0 人参与)

启动报错: opt szy bin mysqld: Table 'mysql.plugin ' doesn 't exist141211 15:06:12 [ERROR] Can 't open t...

启动报错:
/opt/szy/bin/mysqld: Table \'mysql.plugin\' doesn\'t exist
141211 15:06:12 [ERROR] Can\'t open the mysql.plugin table. Please run mysql_upgrade to create it.
141211 15:06:14 [ERROR] Fatal error: Can\'t open and lock privilege tables: Table \'mysql.host\' doesn\'t exist
141211 15:06:14 mysqld_safe mysqld from pid file /opt/szy/data/mysqldevdb03.pid ended
问题分析:

这是执行scripts/mysql_install_db --user=mysql没有成功的原因,没有一个初始化数据库,不能启动mysql守护进程


解决办法:

执行如下语句

./scripts/mysql_install_db --user=mysql

重启启动,OK!

MySQL mysql.plugin

注:本文为本站或本站会员原创优质内容,版权属于原作者及清泛网所有,
欢迎转载,转载时须注明版权并添加来源链接,谢谢合作! (编辑:admin)
分享到: