>I just upgraded from MySQL 4.0.something to 4.1.1 (alpha).
Did you set new passwords using MySQL 4.1.1?
When I try to connect to MySQL in a PHP script, I get the following error:
"mysql_connect(): Client does not support authentication protocol
requested by server; consider upgrading MySQL client in file.php on line
130"
I have not changed anything in my PHP configuration. I can connect to
MySQL with the user/password used in PHP from the command line (with
mysql.exe).
If you created new passwords using MySQL 4.1.1, then unless you
started the server with some option like "--old-passwords", the
account you are trying to connect to CANNOT be accessed by clients
older than 4.1.1 (maybe 4.1.0).
If you kept the same mysql database (the user/privileges database)
when you upgraded, it should still work. What does
"use mysql; select length(password) from user;"
return? 16 is an old-style password. 41 is a new one.
45 is some bastard version used only in 4.1.0, I think.
See the MySQL 4.1.1 manual for details on this.
Gordon L. Burditt