MySQL Forums
Forum List  »  MySQL for Excel

Re: MySQL for Excel - caching_sha2_password not supported
Posted by: Javier Treviño
Date: July 25, 2018 04:48PM

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

Options: ReplyQuote

Written By
Re: MySQL for Excel - caching_sha2_password not supported
July 25, 2018 04:48PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.