Forum Discussion
MySQL: Retrieval of the RSA public key is not enabled for insecure connections.
I am unable to connect a MySQL 8 database server. When I enter the server IP and database name and click the "OK" button, the following error message appears and I cannot proceed.
MySQL: Retrieval of the RSA public key is not enabled for insecure connections.
My versions are as follows:
PowerBI Desktop version 2.141.1253.0 64bit
Mysql Connector/NET 9.2.0
This is apprently a common issue with MySQL and the common fix quoted is add SSLMODE=enable to the connection string except I cant see how the edit the connection string.
There is no field to enter a connection string on the MySQL Connector/NET screen. What should I do?
Hi niconicotsuka ,
Yes you can use MySQL Connector/NET instead of the ODBC driver. Please refer to the following documents for reference
Reference : MySQL :: MySQL Connector/NET Developer Guide
MySQL :: MySQL Connector/NET Developer Guide :: 4.1 Creating a Connector/NET Connection String
MySQL :: Connectors and APIs Manual :: 4.4.5 Connector/NET Connection Options ReferenceIf our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra E.
4 Replies
Hi niconicotsuka ,
Yes you can use MySQL Connector/NET instead of the ODBC driver. Please refer to the following documents for reference
Reference : MySQL :: MySQL Connector/NET Developer Guide
MySQL :: MySQL Connector/NET Developer Guide :: 4.1 Creating a Connector/NET Connection String
MySQL :: Connectors and APIs Manual :: 4.4.5 Connector/NET Connection Options ReferenceIf our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra E.I looked at the reference, but I don't know what to do in the case of PowerBI. There is no field to enter a connection string in the first place.
Is there no other way than to use ODBC?
Hi niconicotsuka ,
Please refer to the similar issue discussed in the thread below, which has already been resolved.
Solved: Re: MySQL: Retrieval of the RSA public key is not ... - Microsoft Fabric CommunityIf our response addressed your issue, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra E.I would like to use MySQL Connector/NET instead of the ODBC driver. Is it possible to solve this by editing the MySQL Connector/NET registry or something?
