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

清泛原创
启动报错:
/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!

分享到:
  网友评论(0)
 
回到顶部