Bug #10763 Updated: MySQL Connection Failed: Can't connect to local MySQL server through socket

ID: 10763 Updated by: cardinal Reported By: iandbigejunk@yahoo.com Old-Status: Open Status: Bogus Bug Type: MySQL related Operating system: PHP Version: 4.0.5 Assigned To: Comments: Previous Comments: --------------------------------------------------------------------------- [2001-05-09 15:34:53] iandbigejunk@yahoo.com Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/test.php on line 4 Could not connect Problem: mysql sever not talking to php Solution: Edit /etc/my.cnf to point to /var/lib/mysql/mysql.sock note you may need to create the directory in /var/lib also Important to change the ownership of the mysql directory using chmod -0777 Here is a listing of the way the directory should look. --------------------- [root@hobbes mysql]# ls /var/lib/mysql mysql.sock ---------------------- note mysql.sock should be pink! here is part of the mysql conf file which should be modified to handle correct volume of traffic. --------------- # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = table_cache=64 set-variable = sort_buffer=512K set-variable = net_buffer_length=8K set-variable = myisam_sort_buffer_size=8M log-bin server-id = 1 user = mysql # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=10000 ------------------ Good Luck Hope this Helps! --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=10763&edit=2