Posted by Paul on 11/06/06 12:43

"Paul" <lof@invalid.com> wrote in message
news:_ft3h.6577$lY5.4574@bignews6.bellsouth.net...
>I recently installed php 4.4.4 using windows binaries on Windows XP Pro. I
>also installed MySQL 4.1. I usually use Pear DB but I tried MDB2 and it
>worked fine until a client uses a different version so I reverted back to
>straigh PHP mysql function calls.
>
> I use this code:
> $link = mysql_connect('localhost', 'username', 'password');
> if (!$link) {
> die('Could not connect: ' . mysql_error());
> }
> echo 'Connected successfully';
>
> And get this error:
> Warning: mysql_connect() [function.mysql-connect]: Client does not support
> authentication protocol requested by server; consider upgrading MySQL
> client in D:\MyDocuments\web\client\login.php on line 3
>
> Line 3 = $link = mysql_connect('localhost', 'username', 'password');
>
> This is from the PHP.ini file:
> ;Windows Extensions
> ;Note that MySQL and ODBC support is now built in, so no dll is needed for
> it.
>
> Therefore I assumed I didn't have to do anything to get access especially
> since MDB2 worked.
>
> Any ideas of what to do?

I finally got it working. Several days ago I tried using "UPDATE
mysql.users SET password = OLD_PASSWORD...

And it did not make a difference. I verified the password was chanegd to
the old format.

Yestrday, I tried it again and it worked. Something else must have changed
in the interim. Anyway, I got it working.

Manyt hanks to everyone who replied to my plead for help!

[Back to original message]