在使用mysql 時 有時會登入遇到錯誤 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
以下方法幾步解決問題, 讓mysql恢複如初(不會删除原有表和資料):
1.找到mysql安裝目錄,以我的為例:D:\Program Files\MySQL\MySQL Server 5.0\bin ,在bin 目錄下找到 MySQLInstanceConfig.exe,運作它
mysql 解決 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) 2.點選Reconfigure Instance, 然後一路Next至此處:
mysql 解決 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) (以下同安裝時的情況)點選第3個框,選擇gbk。
3.如下圖:
mysql 解決 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) 4.填寫新密碼:
mysql 解決 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) 6.點選execute 大功完成!
mysql 解決 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) 7. 重新進入mysql:
mysql 解決 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)