天天看點

mysql 解決 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

在使用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)