Devart Forums

Using MyDAC 2.0. When I try to connect to our mySQL server using one of our accounts that has read-only access to the DB, I get an error:

Client does not support authentication protocol requested by server; consider upgrading MySQL client.

Works fine with the regular account, but not the read only one. It's important that we use the read-only account since this copy of the database is replicated and we want to avoid accidentally writing to the DB, breaking the replication.

Thank you.

We have fixed this problem in the current MyDAC version. You should upgrade to MyDAC 5 to solve the problem.

The upgrade is one option, fortunately I found a mySQL admin with his ducks in a row. You can simply do this command in mySQL:

set password for 'readonlyusername'@'%' =
OLD_PASSWORD('whateverthepasswordis');

And Bob's your uncle (and for free).

scaupp wrote:The upgrade is one option, fortunately I found a mySQL admin with his ducks in a row. You can simply do this command in mySQL:

set password for 'readonlyusername'@'%' =
OLD_PASSWORD('whateverthepasswordis');

And Bob's your uncle (and for free).

MyDAC 5 includes a lot of new and important features, compatibility with all mysql version and more..

Upgrade from version 2 to Version 5 is a Good idea.