Hi - here's my prob and background info. Tried the fix - it didn't work.
MySQL Connection Failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
Any thoughts...?
I'm not sure if it's the same problem but here goes:
I just did a fresh install of RH 7.0 with apache, php, and mysql.
I had the same problem.
All I had to do was change the permissions on my MySQL directory (in your case
"/var/lib/mysql") so that my apache user (the user/group that apache runs as) has
access.
check to make sure it also changes permissions on the mysql.sock file. That's the
important one.
I believe apache only needs read (maybe execute) access.
chmod 755 /var/lib/mysql
(that's from memory, but you know the gist of the problem)
Groan..I knew linux was tough but I didn't think I needed a black belt. I've got
exactly the same prob after a straight redhat7 install. I tried to take milner's
advice and:
changed the /var/lib/mysql/mysql.sock to 755 for root who I'm logged in as. Then
tried to do the same thing for the Mysql directory. It won't change. Tried a re-boot.
Then figured there was something screwy with the directory.
Moved mysql.sock to /test
rmdir mysql
mkdir mysql
copied the file back in. The file now had rw permissions only. But in the test dir
root had all the permissions to it. Is it being blocked higher up in the tree.
My linux book isn't very good on dir permissions. Will chmod change these even if the
directory is not empty.
And how do u list permissions to a directory? ls -l only seems to work for files.
In the error log in the same directory I also get:
mysql.host doesn't exist - but this may be a susequent error.
I'm a complete newbie so any help would be greatly appreciated.
TIA
