Compatibility Issue of MySQL 5.7 & 8.0

[billy1624]

Hi, I was trying the library for the first time and connecting to MySQL. However, I found a compatibility issue on two different version of MySQL.

Using the same connection string mysql://username:password@127.0.0.1/db, it cannot login to MySQL 8.0 but successful on MySQL 5.7.

Error message when logging in MySQL 8.0 are as follows:

MySqlDatabaseError { code: Some("28000"), number: 1045, message: "Access denied for user \'username\'@\'localhost\' (using password: YES)" }

Thank you so much!!

[Handfish]

I also ran into this problem, but have more information and a solution.

MySQL 8.0 changed its default authentication plugin from mysql_native_password to caching_sha2_password. Since PHP doesnt understand caching_sha2_password, I had edited my user accounted previously to set it back to 5.7 defaults. This is what caused your error on my machine.

ALTER USER 'user'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new_password'

In order to make connections with SQLX, it seems user account must be identified by the default authentication plugin. I've updated my user back tocaching_sha2_password and the connection works.

ALTER USER 'user'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'new_password'

[billy1624]

Thanks!! @Handfish

[leontoeides]

Amazing! Thank you @Handfish!

[axzsd]

Thanks!!! @Handfish

[Vrajs16]

@abonander Can close as already fixed.