#10763 [Com]: MySQL Connection Failed: Can't connect to local MySQL server through socket
| From: | quallity-uniform858 at hotmail dot com | Date: | Tue, 20 Jul 2004 15:02:57 +0000 |
| Subject: | #10763 [Com]: MySQL Connection Failed: Can't connect to local MySQL server through socket | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-62859@lists.php.net to get a copy of this message | ||
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] cardinal@php.net
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.
---------------------
[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!
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=10763&edit=1