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: [email protected]
> 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]
