[PHP-DEV] Bug #10763 Updated: MySQL Connection Failed: Can't connect to local MySQL server through socket

[cardinal]

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=1
--
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 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DEV] Bug #10763 Updated: MySQL Connection Failed: Can't connect to local MySQL server through socket

[cardinal]

ID: 10763
Updated by: cardinal
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: MySQL related
Operating system: 
PHP Version: 4.0.5
Assigned To: 
Comments:

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  
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=1
--
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 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]