Re: Can't Connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

At 05:15 PM 10/24/2006, ROGER DEBRY wrote:

I know that this is a common problem, and I have honestly searched though many forums, faqs, and mailing list archives for an answer. I get this message when trying to connect to a local MySQL database with the statement

      $db = mysql_connect('localhost', 'myUserID', 'myPassword')
             or die("Could not connect to mysql");

I know that the MySQL server is running, I can connect to it on the command line with the MySQL client, using the same user name and password as in the mysql_connect statement. I know that the socket is there where it is supposed to be, and that everyone has read and execute privileges to it. localhost is defined correctly in my hosts file. I have tried this with both the defaults for the socket 's path in php.in, and by explicitly typing in the path to the socket. The statement fails with the same error message no matter which I do. I have tried everything that I have found to look at on the many forums, etc. that I have looked at. I am at a loss as what to do next. Any suggestions would be helpful. Thank you Roger deBry

Well, we don't really have any useful information. A couple of things: 1. Echo the error number and error message which PHP returns. Your die() message masks the error. 2. Use phpinfo() to check that MySQL is enabled in PHP. 3. Check the synatx/parameters for mysql_connect() at http://www.php.ca/mysql_connect 4. You could force a TVP/IP connection by replacing lacalhost with 127.0.0.1 HTH - Miles -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.408 / Virus Database: 268.13.11/493 - Release Date: 10/23/2006