Re: help with mysql connect error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[root@webtest html]# rpm -qa MySQL*
MySQL-shared-compat-5.0.27-0.rhel3
MySQL-client-standard-5.0.27-0.rhel3
MySQL-python-0.9.1-6
MySQL-server-standard-5.0.27-0.rhel3
MySQL-devel-standard-5.0.27-0.rhel3

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

--
Postgresql & php tutorials
http://www.designmagick.com/

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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux