MySQL 啟動報錯 Table 'mysql.plugin' doesn't exist
啟動報錯：
點選(此處)摺疊或開啟
-
/opt/szy/bin/mysqld: Table \'mysql.plugin\' doesn\'t exist
-
141211 15:06:12 [ERROR] Can\'t open the mysql.plugin table. Please run mysql_upgrade to create it.
-
141211 15:06:14 [ERROR] Fatal error: Can\'t open and lock privilege tables: Table \'mysql.host\' doesn\'t exist
- 141211 15:06:14 mysqld_safe mysqld from pid file /opt/szy/data/mysqldevdb03.pid ended
問題分析：
百度了下，發現這是執行scripts/mysql_install_db --user=mysql沒有成功的原因，沒有一個初始化資料庫，不能啟動mysql守護程式
解決辦法：
執行如下語句，szy為例項名
./scripts/mysql_install_db --user=szy --basedir=/opt/szy/ --datadir=/opt/szy/data/
重啟啟動，OK！
重啟啟動，OK！
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/14710393/viewspace-2112960/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 'mysql.column_stats' doesn't exist and Table 'mysql.index_stats' doesn't existMySqlIndex
- MySQL 5.5原始碼安裝時啟動資料庫報錯"Table 'mysql.user' doesn't exist??"MySql原始碼資料庫
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- Linux環境下MySQL報Table 'xxx' doesn't exist錯誤解決方法LinuxMySql
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin
- 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
- Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist解決辦法ErrorMySql
- 解決pgpool啟動報錯 ifup[/sbin/ip] doesn't have setuid bitUI
- MySQL 5.7啟動資料庫報錯'does not exist or is not executable'MySql資料庫
- about Res folder doesn't exist in android projectAndroidProject
- lower_case_table_names引數設定解決Error Code: 1146. Table doesn't exist?Error
- doesn't contain a valid partition tableAI
- MySQL 建立外來鍵報錯Can't write; duplicate key in tableMySql
- 帝國CMS重新整理資料表article提示Table ‘empirecms.phome_ecms_’ doesn’t exist的解決
- MYSQL報1022錯誤：Can't write;duplicate key in table '.....'MySql
- MySQL5.6新增root使用者報錯：Field 'ssl_cipher' doesn't have a default valueMySql
- 易優CMS【錯誤程式碼】 SQLSTATE【42S02】：Base table or view not found：1146 Table‘111.ey_admin_theme‘doesn‘t exist-eyoucmsSQLView
- 解決安裝ubuntu系統時出現錯誤：(10, “debian-installer/locale doesn‘t exist“)Ubuntu
- mysql 啟動報錯Can't connect to local MySQL server through socket '/data/mysql/mysql/mysql.sock'(111)MySqlServer
- job呼叫過程報錯 ORA-00942: table or view does not existView
- 資料庫報錯java.sql.SQLException: Field ‘id‘ doesn‘t have a default value資料庫JavaSQLException
- SAP MM 對採購訂單執行收貨，報錯 - Table T169P entry ZNMI does not exist -
- MYSQL ERROR 1146 Table doesnt exist 解析MySqlError
- mysql安裝/啟動報錯彙總MySql
- Android Studio Git No tracked branch configured for branch branch_name or the branch doesn't existAndroidGit
- kettle工具從windows移植到linux上啟動報錯:\karaf/deploy does not existWindowsLinux
- pymysql.err.OperationalError: (1136, “Column count doesn‘t match value count at row 1“)報錯反省。MySqlError
- Table '.\mysql\proc' is marked as crashed and should be repaired 報錯MySqlAI
- MySQL 啟動服務報錯解決方案MySql
- scrollTop doesn't scroll on Chrome 61Chrome
- C++ doesn't name a typeC++
- MySQL 5.6執行DDL報錯ERROR 1050 (42S01): Table 'sms/#sql-ib752' already existMySqlError
- innodb_undo_tablespaces導致Mysql啟動報錯MySql
- SNMP TABLE ERROR : Requested table is empty or does not existError
- mysql 啟動錯誤MySql
- mongodb 啟動報錯MongoDB