cannot connect to local mysql server

Anon

Hi,
i have Red Hat 7.0 on my machine. i am writing a simpe login script where all the usernames and passwords are stored in the mysql database. i am using PHp as my server script. On running this page, i get an error-
MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'. i have no idea what the problem. Anyone has any ideas or suggestions ???

Anon

Is your mysql running?
can you connect to it through the "mysql" command?

Anon

Just a guess but check the my.ini file and make sure your paths are correct.
I had a similar issue and changed the ini file paths and it worked.

but like I said-- Its a guess

good luck

Mark

Anon

I just fixed the same problem on my RH7 machine.. All you need to do is change the permissions on the /var/lib/mysql directory (chmod 777 /var/lib/mysql) and it will work.

[deleted]

EEEEEK!! (worthy of at least two excalamtion marks)

Never ever 777 your mysql dir. That's like telling the world "please come in and delete my database"

The only file you may have to change access rights for is the mysql.sock file. The rest must stay protected.

Like Mark said, make sure the paths are set correctly so mysqld creates the mysql.sock where the mysql client expects it to be.

On a side note, making sure Mysqld actually runs is also a good idea.

Anon

Using redhat's mysql rpm (bah, i'm lazy) it keeps the mysql.sock in /var/lib/mysql/ but php (compiled with --with-mysql=/usr/ ) still looks in /tmp for the mysql.sock. My fix was
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

Not exactly the cleanest fix but atleast this way everybody (mysql console clients and php) is happy.

the chmod 777 is a bad idea but it pointed me to the right place atleast.

Anon

I have a similar problem when running a php script within apache. When I run php from the shell on the server, I can access the database correctly. However, when I run the php script from a web browser using apache, I get the following error:

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Any Ideas?

Chris

[deleted]

http://www.xs4all.nl/~vinny/index.html#3