啟動mysql問題Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

標籤：mysql

啟動mysql出現問題

/etc/init.d/mysqld start

MySQL server PID file could not be found![FAILED]

Starting MySQL......................................The server quit without updating PID file (/data/mysql/mysql_3306/data/mysql.pid).[FAILED]

查看錯誤記錄檔

150619 15:57:19 [Note] Server socket created on IP: ‘0.0.0.0‘.

150619 15:57:19 [ERROR] Fatal error: Can‘t open and lock privilege tables: Table ‘mysql.host‘ doesn‘t exist

原因:

./scripts/mysql_install_db --user=mysql --defaults-file=/etc/my.cnf 

該步驟（初始化資料庫）中my.cnf用的是預設的

而啟動時用的是最新的

解決方案：

用最新的設定檔進行初始化

cd /usr/local/mysql/

./scripts/mysql_install_db --user=mysql --defaults-file=/etc/my.cnf 

啟動沒有問題

本文出自 “dba天空” 部落格，請務必保留此出處http://9425473.blog.51cto.com/9415473/1663591

啟動mysql問題Can't open and lock privilege tables: Table 'mysql.host' doesn't exist