TMyConnection and Read Only Accounts

scaupp · Post by **scaupp** » Wed 24 Sep 2008 14:04

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.

Dimon · Post by **Dimon** » Fri 26 Sep 2008 15:29

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

scaupp · Post by **scaupp** » Fri 26 Sep 2008 17:50

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).

eduardosic · Post by **eduardosic** » Fri 26 Sep 2008 18:56

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.