connecting to mysql database

[sarathi]

I have 2 phpmyadmin mysql db's online with my web hosting. They are both mysql v. 5.0.67. I can connect fine to one of them, but the second one gets this error message: "Client does not support authentication protocol requested by server; consider upgrading MySQL client" I read online that I have to reset the password to use the pre mysql 4.1 password, but when I try to do this with: SET PASSWORD FOR user@host = OLD_PASSWORD('password'), I get this error: "#1044 - Access denied for user 'user'@'%' to database 'mysql'" I don't know how to fix this problem.. If anyone can help me that would be so great. 

 

Thanks.

[BLaZuRE]

I have 2 phpmyadmin mysql db's online with my web hosting. They are both mysql v. 5.0.67. I can connect fine to one of them, but the second one gets this error message: "Client does not support authentication protocol requested by server; consider upgrading MySQL client" I read online that I have to reset the password to use the pre mysql 4.1 password, but when I try to do this with: SET PASSWORD FOR user@host = OLD_PASSWORD('password'), I get this error: "#1044 - Access denied for user 'user'@'%' to database 'mysql'" I don't know how to fix this problem.. If anyone can help me that would be so great. 

 

Thanks.

I'd talk to your web hosting provider.  They should be able to offer support for you, considering this is a webhosting issue, not something gone wrong in your database or coding.  I'm suspecting that they've got some kind of authentication tool set up (I know CPanel does).  You have to set up users with passwords for each database before you can use mysql_connect(...);.  Also, their MySQL server may have settings that trump yours, so if your username is test, it may be something like domainname_test, test, username_test, etc.

What do you mean "pre-mysql 4.1 password", have you used those databases when they were version 4.1 or earlier?  If not, that shouldn't be an issue.  By the way, PHPMyAdmin is simply an interface for your databases, it doesn't describe your database in any way.  It just helps you manage them.

Good luck.

[PFMaBiSmAd]

The error is due to the php version, more specifically the mysql client library that php was built with. If you are still using php4, you should find out what method your host provides to upgrade to php5.