[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
mysqld_safe mysqld from pid file /usr/local/mysql/var/mail.bmitwap.com.pid ended
mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
解决办法
在运行初始化权限表的时候使用增加参数--datadir这样问题就解决了。
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
mysqld_safe mysqld from pid file /usr/local/mysql/var/mail.bmitwap.com.pid ended
mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
解决办法
在运行初始化权限表的时候使用增加参数--datadir
- ./mysql_install_db --user=mysql --datadir=/usr/local/mysql/var
编辑回复