Can't connect to MySQL with PHP

Anon

I have run out of ideas and need some help. I've tried implementing all the solutions outlined throughout this site and nothing works yet.

I'm running RedHat 7.1. I installed the latest release of MySQL and run every test in the books. Everything works perfectly.

When I try to connect with either MySQLGUI or PHP I get the error:

Can't connect to local MySQL server though socket " (111)

I've ensured that the mysql.sock exists in var/lib/mysql.

I've created the link in the /tmp/ folder.

I've updated the my.cnf file

I've rest all permissions on those files to chmod 777

etc. etc. etc...

As I stated, the MySQL is running and everything tests fine.

Any help would definately be appreciated. I've spent two days on this so far and read every thread, readme file, and help file I can find.

Anon

I dont know much, But might be that Php is not complied with mysql.

Please see phpinfo()

saloon12yrd

Hi Randy,

sounds like you're using 'localhost' as hostname. Try using the IP or whichever hostname you set to the DB Server.
In that case PHP won't use the socket (at the price of some speed) but TCP/IP for the connection.
However it's very strange that you can't use the socket at all and you should try to fix that.
Did you check the "socket" entry in the my.cnf for client AND server?
Can you connect from localhost using the commandline?
[...]

Greets,

Dominique

P.S.: PHP has built in mySQL client libaries so it can always talk to mySQL. Maybe not as good as it would be able to if it was compiled with current libaries but it can. Sorry mandar 😉

Anon

Yes, I checked the socket entry and tryed both /tmp/mysql.sock as well as /var/lib/mysql/mysql.sock (both exist so I thought I'de try both).

Yes, I can connect from the command line. As a matter of fact in other threads from Sinansi (MySQL A😎 and the manual and in the readme files there are a sequence of tests that can be run and all tests pass with flying colors.

I really starting to think this is a permissions problem but I;m not good enough on Linux to figure it out. I think Apache can't get access to the socket or mysql.optons file. I can't even get MySQLGUI to connect yet everything works from MySQLAdmin without any problems.

I'm targeting the permissions just because both MySQLGUI and PHP fail. I don't think MySQLGUI uses PHP (it looks like java). That being the case, why would both fail to work?

Anyone run into permission problems before?

I did try setting my.cfg, and mysql.sock permissions in various configurations including user:mysql and group:mysql and made sure that apache user was a member of group mysql. I also used chmod 777 on both. I also tryed adding group nobody to the permissions.

Still nothing.

Any more help would be appreciated. Thanks for the comments so far.

saloon12yrd

We run into a similar situation a while back but I can't recall it completely.

Look in the 'mysql' DB, tables 'user' AND 'db' for which host the access is granted. Make sure it is the same in both tables.
Use this string as host on mysql_connect.

Aside from that, if Apache/PHP and MySQL reside on the same machine try fidling around with 'localhost' and '127.0.0.1' which mean the same but cause different behaviour.

Best of luck!

Dominique