I am working with:
Windows 2000 Advance Server,
VB6,
MySQL 5.0.0-alpha-nt
MySQL ODBC Driver 3.51

I am connecting from VB application using the following connection string.
strCon = "DRIVER={MySQL ODBC 3.51 Driver};" _
& "SERVER=localhost;" _
& "PORT=3306;" _
& "DATABASE= myDatabase;" _
& "UID=root;" _
& "PWD=;" _
& "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384
It is working fine.

I have changed the password of user “root” using the following commands successfully:
mysql> use mysql;
mysql> update user set password=password('shohel') where user='root';
mysql> flush privileges;

After that I am using the connection string like that and I hope it should be:
strCon = "DRIVER={MySQL ODBC 3.51 Driver};" _
& "SERVER=localhost;" _
& "PORT=3306;" _
& "DATABASE= myDatabase;" _
& "UID=root;" _
& "PWD=shohel;" _
& "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384
But it is giving an error message. This is following:
“[MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client”

I can not understand the problem. Anybody can help me please.