ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

✔️ 리눅스, xampp-linux-1.7.7에서 테스트하였습니다.

1 문제상황

[root@jmnote ~]# php update_0.php
PHP Warning:  mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /root/update_0.php on line 2

• mysql.sock의 위치를 확인

[root@jmnote ~]# find / -name mysql.sock
/opt/lampp/var/mysql/mysql.sock
[root@jmnote ~]# netstat -an | grep mysql
unix  2      [ ACC ]     STREAM     LISTENING     780037 /opt/lampp/var/mysql/mysql.sock
[root@jmnote ~]# find / -name php.ini
/etc/php.ini
/opt/lampp/etc/php.ini
[root@jmnote ~]# cat /opt/lampp/etc/php.ini | grep ^mysql.default_socket
mysql.default_socket =
[root@jmnote ~]# vi /opt/lampp/etc/php.ini

php.ini에서 다음 항목을 수정

mysql.default_socket = /opt/lampp/var/mysql/mysql.sock

XAMPP 재시작

[root@jmnote ~]# /opt/lampp/lampp restart
Stopping XAMPP for Linux 1.7.7...
XAMPP: Stopping Apache with SSL...
XAMPP: Stopping MySQL...
XAMPP: Stopping ProFTPD...
XAMPP stopped.
Starting XAMPP for Linux 1.7.7...
XAMPP: Starting Apache with SSL (and PHP5)...
XAMPP: Starting MySQL...
XAMPP: Starting ProFTPD...
XAMPP for Linux started.

2 해결

• /var/lib/mysql/ 디렉토리를 생성
• mysql.sock 심볼릭 링크 설정

[root@jmnote ~]# mkdir /var/lib/mysql/
[root@jmnote ~]# ln -s /opt/lampp/var/mysql/mysql.sock /var/lib/mysql/mysql.sock
[root@jmnote ~]# ll /var/lib/mysql
total 0
lrwxrwxrwx 1 root root 31 Feb  3 15:51 mysql.sock -> /opt/lampp/var/mysql/mysql.sock
[root@jmnote ~]# php update_0.php