MySQL SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket

 

[Problem]：

PDOException: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in lock_may_be_available() (line 167 of /var/www/html/includes/lock.inc). 

[Situation]：

socket入徑有誤

[Solution]：

1、查看mysql的socket文件位置： 

cat /etc/my.cnf

[mysqld]

datadir=/storage/db/mysql

socket=/storage/db/mysql/mysql.sock

user=mysql 

2、將路徑加入到/etc/php.ini中

[MySQL]

...省略n行...

mysql.default_socket = "/storage/db/mysql/mysql.sock"

3、重啟mysql

service mysqld restart

4、解決

[Reference]：

https://www.cnblogs.com/52php/p/5683343.html