MySQL: Retrieval of the RSA public key is not enabled for insecure connections.

[niconicotsuka]

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?

[v-echaithra · Accepted solution]

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 Reference

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Chaithra E.

[niconicotsuka]

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?

[v-echaithra]

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 Community

If our response addressed your issue, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Chaithra E.

[niconicotsuka]

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?