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';

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.


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

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to