ID: 10763
Updated by: cardinal
Reported By: [EMAIL PROTECTED]
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] [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
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
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
