不灭的火

革命尚未成功,同志仍须努力下载JDK17

作者:AlbertWen  添加时间:2014-07-08 14:33:00  修改时间:2025-04-19 08:07:27  分类:MySQL/Redis  编辑

service mysqld start 报错

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/data

解决办法:

在运行初始化权限表的时候使用增加参数--datadir ,命令格式为:

shell> ./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data

这样问题就解决了。