MYSQL Error when test connecting using odbc

[csuryas]

Hi
i use mysql ver 4.1.7 and when i create odbc connection and testing its connection there a error like this:
'Client does not support authentication protocol requested by server; consider upgrading MySQL Client'
anyone know what must i do?
thanks for reply

[khp]

The problem is probably that you are using an older client library to connect to the database, the authentication mechanism in mysql was upgraded as of version 4.1 to use a different password hashing function.
You can solve this in two ways, update your client library (don't know if a newer odbc library exsists). Or set the password for the account you want to use on the server, using the old_password() function.

This is discussed here

http://dev.mysql.com/doc/mysql/en/Old_client.html

[csuryas]

Dear khp,

thanks for your reply. i have read the link you're supplied yesterday and i have change the password for one user but i forgot to supplied the odbc the username i have changed the password. i use 'root' which is the password have not been changed so the odbc client raise that error. i known that problem this morning and after i change the user name myODBC can connect to mySQL :o

best regards

[csuryas]

Dear khp,

thanks for your reply. i have read the link you're supplied yesterday and i have change the password for one user but i forgot to supplied the odbc the username i have changed the password. i use 'root' which is the password have not been changed so the odbc client raise that error. i known that problem this morning and after i change the user name myODBC can connect to mySQL :o

best regards