MySQL Forums
Forum List  »  MySQL for Excel

Re: Value 'Preferred' is not of the correct type
Posted by: Javier Treviño
Date: June 19, 2018 09:36AM

I believe the problem is caused by the MySQL Connector/NET library shipped with MySQL for Excel. Newer versions of MySQL Server use by default the caching_sha2_password authentication, which is not supported by the connector used in the latest MySQL for Excel version.

The suggestion of installing the latest Connector/NET might work.
Have you given it a try?


Javier Treviño
MySQL on Windows Team

Options: ReplyQuote

Written By
Re: Value 'Preferred' is not of the correct type
June 19, 2018 09:36AM

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.