Phillip, You probably didn't need to upgrade - just set the mysql password to use "old_password":
FTFM: "As indicated earlier, a danger in this scenario is that it is possible for accounts that have a short password hash to become inaccessible to pre-4.1 clients. A change to such an account's password made via GRANT, PASSWORD(), or SET PASSWORD results in the account being given a long password hash. From that point on, no pre-4.1 client can authenticate to that account until the client upgrades to 4.1. To deal with this problem, you can change a password in a special way. For example, normally you use SET PASSWORD as follows to change an account password: SET PASSWORD FOR 'some_user'@'some_host' = PASSWORD('mypass'); To change the password but create a short hash, use the OLD_PASSWORD() function instead: SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass'); OLD_PASSWORD() is useful for situations in which you explicitly want to generate a short hash. " So, you could have just updated the password using : SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass'); > -----Original Message----- > From: Philip Thompson [mailto:[EMAIL PROTECTED] > Sent: Monday, January 30, 2006 9:33 AM > To: mysql@lists.mysql.com > Subject: Re: Support between MySQL and PHP > > Thanks to everyone's help. Instead of downgrading MySQL, I > went ahead and upgraded to PHP5. After I did that, it seemed > to fix the connection issue I was having. > > ~Philip > > > On Jan 30, 2006, at 4:41 AM, James Harvard wrote: > > > MySQL versions >= 4.1 use a new, more secure authentication > protocol. > > Probably the version of PHP you are using does not support it. > > > > Ah, here it is: > > http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html > > > > HTH, > > James Harvard > > > > At 1:18 pm -0600 29/1/06, Philip R. Thompson wrote: > >> I just installed MySQL5 and currently have PHP 4.3.11 > installed. I am > >> wanting to connect to the mysql database on localhost, but > I get the > >> following results: > >> > >> ---------- > >> <? $link = mysql_connect('localhost', 'user', 'password'); ?> > >> "Client does not support authentication protocol requested > by server; > >> consider upgrading MySQL client" > >> ---------- > >> > >> Well, I have the lastest stable version of MySQL, so I did > some more > >> research on what the problem might be. When I checked my > information > >> for PHP using phpinfo(), it gave me the "Client API version" for > >> MySQL was 3.23.49. So, I'm thinking my version of PHP > cannot connect > >> to my version of MySQL. I then considered if I installed > the MySQLi > >> extension for PHP (supports versions of MySQL > 4.1), > would that help > >> me? Or, if I just upgraded PHP to version 5, would that help me? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]