Client does not support authentication protocol requested by server

[pmiddend]

When trying to connect to me SQL server, I get this:

ERRException (ERR {errCode = 1251, errState = "08004", errMsg = "Client does not support authentication protocol requested by server; consider upgrading MySQL client"})

Any ideas on how to fix this? Is this related to #40?

[yura]

I had the same issue, got solution at https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server

[whatsupfudd]

Normally it's due to having the mysql db server running with 'caching_sha2_password' authentication, which isn't currently supported by mysql-haskell. The quick fix for one with access to the db server is to change the authentication method with (replace <...> with correct data):
alter user ''@'' identified with mysql_native_password by ''.