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)
It definitely looks like a connection problem, as it isn't getting a
chance to login.
Tim
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
