ERROR 2002 (HY000): Can\'t connect to local MySQL server through socket \'/var/lib/mysql/mysql.sock\' (2)---如何解決
2016-07-11 07:37:37
12175
錯(cuò)誤信息為:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

解決思路:
1.檢查mysql服務(wù)器是否啟動(dòng)
# netstat -ntlp | grep 3306
2.檢查你的mysql.sock在哪個(gè)路徑下
#more /etc/my.cnf | grep sock

3.由于更改mysql數(shù)據(jù)庫(kù)目錄,我錯(cuò)誤把my.cnf里的socket路徑改為/home/mysql了,下圖的路徑為正確路徑,改過(guò)來(lái)并重啟mysql服務(wù)。

會(huì)員登錄
賬號(hào)登錄還沒(méi)有賬號(hào)?立即注冊(cè)