mysql報Can
mysql啟動報 [ERROR] Can't read from messagefile '/usr/local/mysql/share/errmsg.sys'
網上有一些解決方案,讓mysql找到正確路徑。
這裡提供一個逆向解決方案。
在mysql程式碼裡可以找到errmsg.sys
[root@mysql1 5627]# find . -name errmsg.sys
./sql/share/danish/errmsg.sys
./sql/share/bulgarian/errmsg.sys
./sql/share/english/errmsg.sys
./sql/share/dutch/errmsg.sys
./sql/share/slovak/errmsg.sys
./sql/share/ukrainian/errmsg.sys
./sql/share/greek/errmsg.sys
./sql/share/portuguese/errmsg.sys
./sql/share/estonian/errmsg.sys
./sql/share/czech/errmsg.sys
./sql/share/korean/errmsg.sys
./sql/share/serbian/errmsg.sys
./sql/share/japanese/errmsg.sys
./sql/share/hungarian/errmsg.sys
./sql/share/french/errmsg.sys
./sql/share/swedish/errmsg.sys
./sql/share/polish/errmsg.sys
./sql/share/romanian/errmsg.sys
./sql/share/russian/errmsg.sys
./sql/share/german/errmsg.sys
./sql/share/spanish/errmsg.sys
./sql/share/norwegian-ny/errmsg.sys
./sql/share/norwegian/errmsg.sys
./sql/share/italian/errmsg.sys
把英文的放到它要求的路徑完事。
[root@mysql1 5627]# cp ./sql/share/english/errmsg.sys /usr/local/mysql/share/errmsg.sys
cp: overwrite `/usr/local/mysql/share/errmsg.sys'? y
開始我以為是要寫點錯誤日誌,給它touch一個就行,結果還是報錯。
原來errmsg是多語言支援用的。
網上有一些解決方案,讓mysql找到正確路徑。
這裡提供一個逆向解決方案。
在mysql程式碼裡可以找到errmsg.sys
[root@mysql1 5627]# find . -name errmsg.sys
./sql/share/danish/errmsg.sys
./sql/share/bulgarian/errmsg.sys
./sql/share/english/errmsg.sys
./sql/share/dutch/errmsg.sys
./sql/share/slovak/errmsg.sys
./sql/share/ukrainian/errmsg.sys
./sql/share/greek/errmsg.sys
./sql/share/portuguese/errmsg.sys
./sql/share/estonian/errmsg.sys
./sql/share/czech/errmsg.sys
./sql/share/korean/errmsg.sys
./sql/share/serbian/errmsg.sys
./sql/share/japanese/errmsg.sys
./sql/share/hungarian/errmsg.sys
./sql/share/french/errmsg.sys
./sql/share/swedish/errmsg.sys
./sql/share/polish/errmsg.sys
./sql/share/romanian/errmsg.sys
./sql/share/russian/errmsg.sys
./sql/share/german/errmsg.sys
./sql/share/spanish/errmsg.sys
./sql/share/norwegian-ny/errmsg.sys
./sql/share/norwegian/errmsg.sys
./sql/share/italian/errmsg.sys
[root@mysql1 5627]# cp ./sql/share/english/errmsg.sys /usr/local/mysql/share/errmsg.sys
cp: overwrite `/usr/local/mysql/share/errmsg.sys'? y
開始我以為是要寫點錯誤日誌,給它touch一個就行,結果還是報錯。
原來errmsg是多語言支援用的。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26239116/viewspace-1869883/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Mysql報錯Fatal error:Can't open and lock privilege tablesMySqlError
- MySQL 建立外來鍵報錯Can't write; duplicate key in tableMySql
- MySQL 5.5 原始碼安裝報錯"[ERROR] Can't start server"MySql原始碼ErrorServer
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- mysql 啟動報錯Can't connect to local MySQL server through socket '/data/mysql/mysql/mysql.sock'(111)MySqlServer
- MYSQL報1022錯誤:Can't write;duplicate key in table '.....'MySql
- MySQL 5.5 關閉資料庫報錯"Can't connect to local MySQL server through socket"MySql資料庫Server
- mysql匯入報錯Variable 'sql_notes' can't be set to the value of 'NULL'MySqlNull
- MySQL報錯'ERROR 2002 (HY000): Can't connect to local MySQL server through'MySqlErrorServer
- 【MySQL】ERROR 1093 You canMySqlError
- 【MySQL】Slave can not handle replication events with the checksum ...MySql
- 協議CAN&報文&仲裁協議
- Can'tconnecttolocalMySQLserverthroughsocket'/var/lib/mysql/mysql.sock'(2)MySqlServer
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin
- mysql遇到Variable can’t be set to the value of ‘NULL’MySqlNull
- mysql can't start dues to the disk space is fullMySql
- How MySQL Can Finally Kick Some MongoDBMySqlMongoDB
- error:'Can'tconnecttolocalMySQLserverthroughsocket'/var/lib/mysql/mysql.sock'(2)'ErrorMySqlServer
- MySQl報錯之@@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_MODE = ONMySql
- mysql [ERROR] Can't create IP socket: Permission deniedMySqlError
- eslint --fix 報錯 can't not find modulesEsLint
- MongoDB報錯:"assertion" : "can't map file memory"MongoDB
- MySQL連線提示Can't connect to local MySQL server through socketMySqlServer
- Can't connect to local MySQL server through socket '/tmp/mysql.sock'MySqlServer
- 【MySQL】Can't get stat of './mysql/slow_log.CSV' (Errcode: 2)MySql
- MYSQL ERROR 2003 (HY000) CanMySqlError
- Mysql update in報錯 [Err] 1093 - You can't specify target table 'company_info' for update in FROM clauseMySql
- 連線MySQL錯誤:Can't connect to MySQL server (10060)MySqlServer
- MySQL 2003 - Can’t connect to MySQL server on (10060)MySqlServer
- mysql中You can’t specify target table for update in FROM clMySql
- MySQL不能啟動 Can't start server : Bind on unix sockeMySqlServer
- mysql can't connect error about privilege----not root userMySqlError
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock錯誤MySqlServer
- 解決Can 't connect to local MySQL server through socket '/tmp/mysql.sock '(2) "MySqlServer
- 異常:Can't connect to MySQL server (10060)MySqlServer
- 使用邊緣計算閘道器分析CAN報文
- Swift代理報錯Optional can only be applied to members of an @objc protocolSwiftAPPOBJProtocol
- 32bit Pl/SQL developer 報can not find oci.dllSQLDeveloper