Tim McGeary wrote:
Stut wrote:
Tim McGeary wrote:
But I do have a MySQL 5 client:

[EMAIL PROTECTED] html]# rpm -qa MySQL*

or are you saying that the PHP libs have a MySQL 4 client in there? If that is the case, how should I rebuild PHP?

Yes, and it depends on what OS, where it originally came from, etc. The alternative is to change the password of the MySQL user you're using - the link in my last post explains how to do this.

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)...

Postgresql & php tutorials

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

Reply via email to