MySQL Forums
Forum List  »  MySQL for Excel

Re: Trying to connect Excel to MySQL database
Posted by: Javier Treviño
Date: November 26, 2018 01:20PM

If you setup MySQL Server 8.0.x to use the new SHA256 authentication as the default authentication plugin, then you won't be able to connect through MySQL for Excel, since the current release still does not support the SHA256 authentication.

You need to setup the Server to use the native authentication in order to be able to connect with MySQL for Excel, or wait until this gets supported in the next release of MySQL for Excel.


Javier Treviño
MySQL on Windows Team

Options: ReplyQuote

Written By
October 02, 2018 10:46PM
Re: Trying to connect Excel to MySQL database
November 26, 2018 01:20PM

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.