Re: help with mysql connect error

Tim McGeary wrote:

Chris wrote:

Tim McGeary wrote:

Stut wrote: Ok, so I did the recommended process of: mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')

    -> WHERE Host = 'some_host' AND User = 'some_user';

mysql> FLUSH PRIVILEGES; This allows the CLI script to run successfully, but the web php file still gives me the original error. Any ideas? The error again is: 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)

'13' means permission denied. $ perror 13 System error: 13 = Permission denied What are the permissions on the /var/lib/mysql/ directory? Maybe php can't get into that, thus it can't get to the socket file. Try chmod 755 /var/lib/mysql to allow any user to be able to read files in that folder (but not change anything)...

You are correct, it was the directory permissions! Thank you so much. That is also great information about what the error numbers mean. Where or how can I find out what those numbers mean for future reference?

With a *nix / *bsd shell, pass it to 'perror': perror XXX and if perror knows what it is, it will let you know... mysql (or other apps) might use numbers that perror doesn't know, then it becomes a bit tougher but a search usually helps. -- Postgresql & php tutorials http://www.designmagick.com/