Re: help with mysql connect error

Tim McGeary wrote:

Please include the list in replies.

Sorry, I meant to, but hit the wrong button.

Tim McGeary wrote:

Stut wrote:

Tim McGeary wrote:

I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following error via the PHP web page I am building:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /var/www/html/software/index.php on line 18 Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

Given that you can connect through the socket on the CLI, I'm gonna guess that it's a permissions issue. Does the user that Apache (or whatever web server you're using) runs as have access to mysql.sock?

Currently mysql.sock is owned by mysql.mysql with S777 permissions. Should the ownership be different? Despite the ownership, wouldn't S777 allow any user to access it?

Indeed it should. Have you tried writing a CLI script and seeing if that works?

I confess I don't know what at CLI script is. What would I write?

To be run on the command line. Same as a web-based PHP script, but no need to output any HTML. Just write a script that tries to connect to the database and spits out success or failure. Then run php script.php on the command line (CLI === Command Line Interface) and see what happens. -Stut