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: Paul Radcliffe
Date: April 16, 2006 03:24AM

Yes I found all the stuff about old_passwords - there is a long discussion on the PHP site - in the section on the mysql_connect function. It seems the mysql connector library in PHP 4 has not been updated to match MySQL 4 and later - at least the Windows version hasn't. I found that putting old_passwords in my.ini didn't fix the problem, but manually converting all the user passwords to the OLD_PASSWORD format did, using an SQL query such as: set password for user@host = OLD_PASSWORD('password')

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 16, 2006 03:24AM


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.