can't connect mysql.sock error

mabus92920 · 04-14-2005, 09:20 PM

dude..I recently installed FC3 on my system. I activated httpd,and mysqld. when I tried to run my web application (which was done using php scripts)..it showed this "can't connect to mysql.sock" error..

when i tried to run phpinfo.ph (that only contains phpinfo(); ) it displayed the details properly, so I guess my php is working well.

this is a mysql problem right? how do I fix this ?

another thing..I didn't have this back then with RH9... and also, I got this error on a diferent system when I installed mysql, and I was able to fix it by turning down the firewall. This time, I didn't have to install mysql since I allready did it during intallation of the OS.

how do I fix this ? and what causes this problem?

s_deepak_123 · 04-14-2005, 10:52 PM

su to root, type the following:
service mysqld start
That should fix it.
To start the service automatically, you have to enable mysqld in the system tools -> services

duongvn · 04-14-2005, 11:16 PM

I think the problem here is that your mysql client cannot find the file mysql.sock
(default path is /tmp/mysql.sock).
Then, you should find this file in /var/lib/mysql/mysql.sock
You can also change the setting in file /etc/my.cnf to set the path to mysql.sock as well.

sachins · 04-15-2005, 07:44 AM

Yes I also had the same problem last month. I searched for the file mysql.sock but it seems it is nowhere to be found in my system. I use FC3. Could anyone post out the mysql.sock contents so that i can make the file and put it in its right place.

dylants · 04-15-2005, 09:12 AM

according to my system that is running mysql quite happily, mysql.sock is 0 bytes in size:

Code:

ls -l /var/lib/mysql/mysql.sock
srwxrwxrwx    1 mysql    mysql           0 Mar  2 10:40 /var/lib/mysql/mysql.sock

My mysql config file contains

Code:

cat /etc/my.conf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
...

when you start the service it should create this file.

service started by logging into root account and issuing:

Code:

service mysqld start

I am running RHEL3 - to make this service start when the machine boots I used:

Code:

# chkconfig mysqld on

confirmed with:

Code:

# chkconfig mysqld --list
mysqld          0:off   1:off   2:off   3:on    4:on    5:on    6:off

HTH

Dylan

pcweirdo · 04-15-2005, 10:04 PM

You can't copy the contents of mysql.sock! It's a socket, not a normal file!
See the 's' at the start of:
"
srwxrwxrwx 1 mysql mysql 0 Mar 2 10:40 /var/lib/mysql/mysql.sock
"

If your php scripts specifiy the mysql hostname with something other than 'localhost', for example using the name '127.0.0.1', php will try to use TCP/IP. Then you don't have to worry about every setup putting mysql.sock in a different place.

However, in php.ini:
"
; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =
"
Mine is blank, so it will use the built-in MySQL's defaults. You can change php.ini to have your actual socket in it. Everything works once you mess with the config files enough. You might try saving a backup before fiddling.

The main problem here is that the MySQL built into PHP has different settings to the MySQL server you have running.

mabus92920 · 04-15-2005, 10:38 PM

I solved the problem allreday.. I forgot the permissions on /home directory, when I set it , then everything came to place.. It's probably the app that didn' t have the privilege on accessing some folders.