ODBC w/ password

[Rick Lones]

I am using mysql 4.1.2 on a Win2K (SP3) host. I cannot seem to create a
useable MyODBC DSN unless I set user=ODBC with no password. When I try
to test a non-null password in the DSN configuration dialog for ODBC
3.51 I get the error message:

"[MySQL][ODBC 3.51 Driver] Client does not support authentication
protocol requested by server; consider upgrading MySQL client"

This sounds like a server configuration issue but the client (presumably
the ODBC driver in this case?) is being blamed, apparently.

I have tried this on both MyODBC 3.51 and 2.50, getting nowhere. Can
anyone help with this?

Thanks,
-rick-

[Aggro]

Rick Lones wrote:

"[MySQL][ODBC 3.51 Driver] Client does not support authentication
protocol requested by server; consider upgrading MySQL client"

There was a similar problem few days ago (or weeks). The solution might
help you to:

---------------
Here's the solution:
SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
http://dev.mysql.com/doc/mysql/en/Old_client.html
---------------