RE: [PHP] can't access mysql by mysql_connect

Sounds like you didn't resync the mysql tables Login to mysql as root and do a: FLUSH PRIVILEGES xie xie. Loz. -----Original Message----- From: KaiYI Chen [mailto:kaiyic@yahoo.com] Sent: October 3, 2000 03:11 PM To: php-general@lists.php.net Subject: [PHP] can't access mysql by mysql_connect Hi there, My platform is RedHat 7.0 along with mysql 3.23.22beta and php 4.0.1 I did the following to chage root password of mysql: #mysqladmin -p password newpassword After that, I have no problem running mysql command(e.g. #mysql -p) using the new password. However, my php script (new password as argument to mysql_connect function) got error: Warning: MySQL Connection Failed: Access denied for user: 'root@myhost' (Using password: YES) Once I pass the old password as argument to mysql_connect, the php script runs fine. Could anybody help me out with this?? K __________________________________________________ Do You Yahoo!? Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! http://photos.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net