The server requested authentication method unknown to the client [caching_sha2_password]


Enter Your Query:
Use '%' for wildcards and quotes for "exact phrases"


Top Level » MySQL / MariaDB

The server requested authentication method unknown to the client [caching_sha2_password]Last Modified: Sep 25, 2019, 10:58 pm
MySQL 8.0 supports a new authentication plugin called caching_sha2_password.
For the most part, this may cause confusion in several areas, including the one-click phpMyAdmin login / SSO.

If you login to phpMyAdmin as da_admin and check your mysql.user table, if you have any Users created by DA, including the SSO logins that start with "da_sso_" which have the "plugin" column set to caching_sha2_password, then the work-around is to force the default back to mysql_native_password by editing:

/etc/my.cnf

and in the [mysqld] section, add code

default-authentication-plugin=mysql_native_password

and restart mysqld.

We'll continue to monitor the prevalence of this issue, and if it's widespread, then we'll include:
IDENTIFIED WITH mysql_native_password BY 'password'
in the CREATE USER section, when applicable.

© 2018 JBMC Software, Suite 173  3-11 Bellerose Drive, St Albert, AB  T8N 1P7  Canada.  Mon-Fri 9AM-5PM MST