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

해결되지 않은 문제입니다.

문제상황

[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

[root@jmnote ~]# find / -name mysql.sock
/opt/lampp/var/mysql/mysql.sock
[root@jmnote ~]# find / -name php.ini
/etc/php.ini
/opt/lampp/etc/php.ini
[root@jmnote mysql]# netstat -an | grep mysql
unix  2      [ ACC ]     STREAM     LISTENING     780037 /opt/lampp/var/mysql/mysql.sock
[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.