MySQL 5.5原始碼安裝時啟動資料庫報錯"Table 'mysql.user' doesn't exist??"
MySQL 5.5原始碼安裝時啟動資料庫報錯
錯誤日誌中的內容如下:
2016-05-15 02:41:06 42565 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
報錯原因:
儘管建立了MySQL系統表,但是沒有在配置檔案中指定軟體安裝目錄和資料檔案目錄
解決方法:
在配置檔案中指定軟體安裝目錄和資料檔案目錄
[root@localhost mysql-cluster-gpl-7.4.11]# vim /etc/my.cnf
[client]
socket=/cluster_data/mysql.sock
[mysqld]
ndbcluster # 開啟NDB儲存引擎
basedir = /cluster
datadir = /cluster_data
socket=/cluster_data/mysql.sock
log_error = /cluster_data/err.log
[mysql_cluster]
# MySQL叢集節點選項:
ndb-connectstring=192.168.78.141 # 管理節點的所在主機
錯誤日誌中的內容如下:
2016-05-15 02:41:06 42565 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
報錯原因:
儘管建立了MySQL系統表,但是沒有在配置檔案中指定軟體安裝目錄和資料檔案目錄
解決方法:
在配置檔案中指定軟體安裝目錄和資料檔案目錄
[root@localhost mysql-cluster-gpl-7.4.11]# vim /etc/my.cnf
[client]
socket=/cluster_data/mysql.sock
[mysqld]
ndbcluster # 開啟NDB儲存引擎
basedir = /cluster
datadir = /cluster_data
socket=/cluster_data/mysql.sock
log_error = /cluster_data/err.log
[mysql_cluster]
# MySQL叢集節點選項:
ndb-connectstring=192.168.78.141 # 管理節點的所在主機
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26506993/viewspace-2100335/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL 啟動報錯 Table 'mysql.plugin' doesn't existMySqlPlugin
- 'mysql.column_stats' doesn't exist and Table 'mysql.index_stats' doesn't existMySqlIndex
- Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist解決辦法ErrorMySql
- MySQL 5.5 原始碼安裝報錯"[ERROR] Can't start server"MySql原始碼ErrorServer
- MySQL 5.7啟動資料庫報錯'does not exist or is not executable'MySql資料庫
- Linux環境下MySQL報Table 'xxx' doesn't exist錯誤解決方法LinuxMySql
- mysql5.5資料庫cmake原始碼編譯安裝MySql資料庫原始碼編譯
- MySQL查詢報錯:ERROR 1146 (42S02): Table 'craw.sitePageConfig' doesn't existMySqlError
- [BUG反饋]子查詢報錯,Base table or view not found: 1146 Table 'onethink.(' doesn't existView
- ERROR 1146 (42S02): Table 'mysql.slow_log' doesn't existErrorMySql
- MySQL 5.5 原始碼安裝流程MySql原始碼
- 解決安裝ubuntu系統時出現錯誤:(10, “debian-installer/locale doesn‘t exist“)Ubuntu
- MySQL 5.5 關閉資料庫報錯"Can't connect to local MySQL server through socket"MySql資料庫Server
- mysql5.5的原始碼安裝MySql原始碼
- 資料庫報錯java.sql.SQLException: Field ‘id‘ doesn‘t have a default value資料庫JavaSQLException
- Mysql 5.5 資料庫啟動關閉命令MySql資料庫
- mysql安裝/啟動報錯彙總MySql
- 解決pgpool啟動報錯 ifup[/sbin/ip] doesn't have setuid bitUI
- about Res folder doesn't exist in android projectAndroidProject
- RedHat 6.4原始碼方式安裝mysql5.5Redhat原始碼MySql
- wget下載安裝時出現錯誤doesn‘t match requested host name錯誤wget
- lower_case_table_names引數設定解決Error Code: 1146. Table doesn't exist?Error
- mysql5.0資料庫原始碼編譯安裝MySql資料庫原始碼編譯
- CentOS 6.5 原始碼編譯安裝 MySQL 5.5 5.6CentOS原始碼編譯MySql
- 安裝mysql原始碼出錯MySql原始碼
- doesn't contain a valid partition tableAI
- MySQL入門學習之——原始碼安裝mysql5.5MySql原始碼
- Mysql 5.5 原始碼安裝後建立使用者報錯"ERROR 1045 (28000): Access denied for user"MySql原始碼Error
- Linux 安裝 mysql 5.5.8(cmake原始碼安裝mysql5.5以上版本)[轉]LinuxMySql原始碼
- MySQL資料庫叢集自動安裝指令碼!MySql資料庫指令碼
- mysql 的原始碼安裝方法及自動啟動方法MySql原始碼
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- Linux下原始碼編譯方式安裝MySQL5.5Linux原始碼編譯MySql
- 惡意程式造成資料庫啟動報錯資料庫
- 安裝mysql遇到ERROR: 1136 Column count doesn't match value count at row 1MySqlError
- 啟動MySql資料庫MySql資料庫
- MySQL 建立外來鍵報錯Can't write; duplicate key in tableMySql
- mysql5.5安裝MySql