Re: MySQL for Excel - caching_sha2_password not supported

[Javier Treviño]

Hi Anrie,
The latest released version of MySQL for Excel does not support SHA256 connections. So what you tried to do should work, which is changing the default-authentication-plugin to use the mysql_native_password plugin, but if you installed the MySQL Server using the MySQL Installer and during the configuration you selected to use the SHA256 authentication, any of the MySQL users that you created during the configuration were setup to use a SHA256 authentication.

So, before you change the default_authentication_plugin, you need to login with the user and credentials you did your setup, then create other users where you ensure the users are created to authenticate with the mysql_native_password plugin, then you can stop your server change the Server's default_authentication_plugin value and after you start the Server you should be able to login with the users you created to authenticate with the native authentication.

Best regards.

====================================
Javier Treviño
MySQL on Windows Team