【轉】安裝mysql 出現：Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

標籤：

來源：http://blog.csdn.net/dapeng0112/article/details/37053407

本來初始化配置是這樣的：

scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql

出現了

[[email protected] mysql-5.6.14]# service mysql restart
 ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/localhost.localdomain.pid).

在日誌中出現了如下錯誤：

Can‘t open and lock privilege tables: Table ‘mysql.user‘ doesn‘t exist

後來採用了下面的語句就可以了：

scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --ldata=/var/lib/mysql

【轉】安裝mysql 出現：Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist