MySQL Forums
Forum List  »  PHP

Re: Can't connect php/4.4.1 to Mysql 5.0.16 : Client does not support authentication protocol requested by server; consider upgrading MySQL client
Posted by: Bill Karwin
Date: April 11, 2006 11:53AM

I don't think any version of PHP contains the upgraded client. You would have to build PHP from source.

Alternatively, run your MySQL server with the --old-passwords option to let it store passwords compatible with the old MySQL client in PHP.

That could explain why Paul's Linux host seems to work -- it's running with the --old-passwords option already. Use the following statement in mysql to check:

show variables like 'old_passwords';

See this page for more information:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Regards,
Bill K.

Options: ReplyQuote


Subject
Written By
Posted
Re: Can't connect php/4.4.1 to Mysql 5.0.16 : Client does not support authentication protocol requested by server; consider upgrading MySQL client
April 11, 2006 11:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.