It looks like I need some help with MySQL. I'm looking at some code that uses MySQL as a back end, and I need a working ODBC connection to it. I've got MySQL 5.0 (from the MySQL Website) installed on Windows. I used the installer, and had it install everything. I then grabbed an ODBC Driver from here.

So now, I try installing a driver, and when I use the "test connection" option in the ODBC console, I get this:

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

Trouble is, that looks like the most up to date client. I'm sure I've misconfigured something; anyone have a tip? Thanks in advance.