Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist解決辦法
問題
用安裝版的Mysql確實沒有二進位制版的簡單，自己配置，隨心所欲。今天在安裝二進位制版的Mysql 5.7的時候出現瞭如下錯誤。
看了一下配置檔案，配置的沒有問題。然後再啟動的時候確實出現了沒建立mysql庫的情況。我也不知道為啥，上網查吧……網上也沒告訴我為啥。只是告訴我解決辦法，根據解決辦法可以很明顯的看出是初始化出了問題，但是原理是什麼我也不清楚……
解決辦法
1、先將my.default.ini改名為my.ini放到bin目錄
2、命令列執行： mysqld --initalize --user=mysql --console 先執行這個命令生成庫
3、然後會返回一個臨時密碼給我們，記下來。
4、然後啟動服務，然後執行 mysql -u root -p 輸入密碼
5、輸入set password=password('root');修改密碼
相關文章
- Mysql報錯Fatal error:Can't open and lock privilege tablesMySqlError
- 'mysql.column_stats' doesn't exist and Table 'mysql.index_stats' doesn't existMySqlIndex
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin
- FileZilla：425 Can't open data connection for transfer of解決辦法
- lower_case_table_names引數設定解決Error Code: 1146. Table doesn't exist?Error
- ERROR 1146 (42S02): Table 'mysql.slow_log' doesn't existErrorMySql
- MySQL 5.5原始碼安裝時啟動資料庫報錯"Table 'mysql.user' doesn't exist??"MySql原始碼資料庫
- MySQL 啟動報錯 Table 'mysql.plugin' doesn't existMySqlPlugin
- mysql can't connect error about privilege----not root userMySqlError
- Field ‘spu_id‘ doesn‘t have a default valu 解決辦法
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- Linux環境下MySQL報Table 'xxx' doesn't exist錯誤解決方法LinuxMySql
- linux操作提示：“Can't open file for writing”或“operation not permitted”的解決辦法LinuxMIT
- 解決Error (1133): Can’t find any matching row in the user tableError
- rman: can't open target
- about Res folder doesn't exist in android projectAndroidProject
- linux上“rman can't open target”問題解決Linux
- 帝國CMS重新整理資料表article提示Table ‘empirecms.phome_ecms_’ doesn’t exist的解決
- doesn't contain a valid partition tableAI
- Linux下安裝Oracle 錯誤解決 - Error: Can't open display:127.0..0.1:0.0LinuxOracleError
- MySQL查詢報錯：ERROR 1146 (42S02): Table 'craw.sitePageConfig' doesn't existMySqlError
- Fatal error: can't check configuration file '/home/watt/proxy/dError
- [BUG反饋]子查詢報錯，Base table or view not found: 1146 Table 'onethink.(' doesn't existView
- Xcode 無法開啟沙盒(can't open sandbox)XCode
- RMAN的"rman: can't open target"錯誤
- if doesn't support the "condition"attribute 問題解決
- MIRO Error:Table T169V: entry G180 does not existError
- 【MySQL】ERROR 1005 (HY000): Can't create table' (errno: 150)MySqlError
- pecl PHP Parse error: syntax error, unexpected 'new' (T_NEW) 以及 XML缺失解決辦法PHPErrorXML
- Supervisor 解決 can't find command *
- 解決can't find -lGL的問題
- 本機執行x程式出現：Can't open display 原因及其解決方法
- Dubbo廣播模式下報錯：Can't assign requested address解決辦法模式
- mysql [ERROR] Can't create IP socket: Permission deniedMySqlError
- Linux Couldn’t resolve host 解決辦法Linux
- VS 2017 Git failed with a fatal error的解決辦法GitAIError
- You can‘t specify target table ‘Person‘ for update in FROM clause
- cordova 解決can’t not find moudle " plugman platform ios"PlatformiOS