Hey folks,
Bcaching_sha2_password and it’s the default auth plugin now. Here is the list of compatible connectors to check if your app is ok with that or if you should call the dev team.
Example: If, for some reason, you get stuck with the following error (PHP sample), you have to do a few changes.
Connect Error: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client
default-authentication-plugin with mysql_native_password value, restart the server and set the password again with the following command.
Config File:
[mysqld] /... other configs .../ default-authentication-plugin=mysql_native_password
SQL:
ALTER USER 'adv'@'localhost' IDENTIFIED WITH mysql_native_password BY '1AB@8CD#E91F22!';
So, look out before just doing a update on your server, or you could break your app 😉