ID: 10763 Comment by: quallity-uniform858 at hotmail dot com Reported By: iandbigejunk at yahoo dot com Status: Bogus Bug Type: MySQL related Operating System: Red Hat 7 PHP Version: 4.0.5 New Comment:
<a href=http://quallity-extreme-un.da.ru>uniform quallity</a> Previous Comments: ------------------------------------------------------------------------ [2001-05-09 15:41:11] [EMAIL PROTECTED] Not a bug. ------------------------------------------------------------------------ [2001-05-09 15:34:53] iandbigejunk at yahoo dot 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. --------------------- [EMAIL PROTECTED] 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! ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=10763&edit=1
