MySQL 啟動失敗原因與解決方法 收集

01.PORT被占用

解決方法(cmd) : 

 netstat -aon|findstr "3306"
 tasklist|findstr "uid"
 taskkill /f /t /im XXX.exe

02.找不到對應的ini檔 [這也是同一台電腦(主機/PC) 啟動多個MySQL方法]

解決方法(bat) : 

 "C:\Users\jashliao\Desktop\192_168_1_68 API\20191004\SYWEB-V8-Workstation(Delta)\SYWEB-V8-Workstation\bin\Debug\mysql\bin\mysqld_v8.exe" --defaults-file="C:\Users\jashliao\Desktop\192_168_1_68 API\20191004\SYWEB-V8-Workstation(Delta)\SYWEB-V8-Workstation\bin\Debug\mysql\my.ini"

03.實際查詢備份

C:\Users\jashliao> netstat -aon|findstr "3307"
  TCP    0.0.0.0:3307           0.0.0.0:0              LISTENING       14664
  TCP    127.0.0.1:3307         127.0.0.1:60656        ESTABLISHED     14664
  TCP    127.0.0.1:3307         127.0.0.1:60657        ESTABLISHED     14664
  TCP    127.0.0.1:60656        127.0.0.1:3307         ESTABLISHED     7872
  TCP    127.0.0.1:60657        127.0.0.1:3307         ESTABLISHED     7872

C:\Users\jashliao> tasklist|findstr "14664"
mysqld_v8.exe                14664 Console                    7     13,524 K

C:\Users\jashliao> tasklist|findstr "7872"
SYWEB-V8-Workstation(syws     7872 Console                    7    327,916 K