ID: 10763
Updated by: cardinal
Status: Open
Bug Type: MySQL related
Operating system: 
PHP Version: 4.0.5
Assigned To: 

Not a bug.

Previous Comments:

[2001-05-09 15:34:53] [EMAIL PROTECTED]
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  
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
#password       = your_password
port            = 3306
socket          = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
port            = 3306
socket          = /var/lib/mysql/mysql.sock
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
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

PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to