|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.cnfand in the [mysqld] section, add code
default-authentication-plugin=mysql_native_passwordand 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