I don't know if you have fixed this probelm, but I had the same problem on Red Hat
7.0. I had installed the rpm files from MySQL.com and RedHat.com. The problem was
solved by doing the following.
chmod 755 the "mysql" directory that contains the "mysql.sock" file.
I am currently running the latest release of MySQL Server & Client.
Don't take this advice as perfect. I am a newbie also.
Mike,
"bobit" <[EMAIL PROTECTED]> wrote ..
> 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
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php