cmd 下執(zhí)行 輸出錯(cuò)誤日志
C:\software\mysql-8.0.20-winx64\bin>mysqld.exe --validate-config --log-error=error.log
2020-05-31T13:21:24.736679Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file 'C:\software\mysql-8.0.20-winx64\bin\ oftware\mysql-8.0.20-winx64\share\errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
C:\software\mysql-8.0.20-winx64\bin>mysqld.exe --validate-config --log-error=error.log
2020-05-31T13:22:59.594770Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file 'C: oftware\mysql-8.0.20-winx64 hare\errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
發(fā)現(xiàn)路徑不對(duì)析校，
my.ini 中的 \s被轉(zhuǎn)義了(\s代表正則表達(dá)式中的一個(gè)空白字符)
修改如下：
# 設(shè)置mysql的安裝目錄
basedir="C:\\software\\mysql-8.0.20-winx64"
# 設(shè)置mysql數(shù)據(jù)庫(kù)的數(shù)據(jù)的存放目錄
datadir="C:\\software\\mysql-8.0.20-winx64\\data"
打印輸出MySQL 錯(cuò)誤日志配置如下：
# 在my.ini中添加
log-error="C:\\software\\mysql-8.0.20-winx64\\logs\\mysql_log_err.log"
