Client does not support authentication protocol requested by server

winterland1989 / mysql-haskell

Pure haskell mysql driver

BSD 3-Clause "New" or "Revised" License

122 stars 34 forks source link

Client does not support authentication protocol requested by server #42

Open pmiddend opened 3 years ago

pmiddend commented 3 years ago

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 commented 2 years ago

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 commented 2 weeks ago

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 'user>'@'<host' identified with mysql_native_password by ''.