首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > Mysql >

Can't open the mysql.plugin table. Please run mysql_upgrade to create it

2012-07-23 
Cant open the mysql.plugin table. Please run mysql_upgrade to create it.090517 13:34:15 [ERROR] Ca

Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
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 exist
090517 13:34:15 mysqld_safe mysqld from pid file /usr/local/mysql/var/mail.bmitwap.com.pid ended
090517 13:38:35 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var

解决办法 在运行初始化权限表的时候使用增加参数--datadir ,命令格式为:
shell> ..../mysql_install_db --user=mysql --datadir=/usr/local/mysql/var
这样问题就解决了。

热点排行