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

Question

I need to set up MySQL database in my computer. I downloaded the Windows (x86, 32-bit), MSI Installer from here.

I run the installer. At the final stage, the installer reach Apply configuration stage.

But it stops at Starting Server. The log says:

    MySQL error 0: Retrieval of the RSA public key is not enabled for insecure connections. Failed to connect to MySQL Server 8.0.11 after 10 attempts. Ended configuration step: Starting Server

I already entered a root and added a user and created a password for them. The passwords had yellow warning, meaning that they are not strong, but also not weak. The wizard accepted them so I proceeded.

Can you please help me identify the source of the problem and how to solve it?

EDIT: I am using Windows 10. The server is my localhost.

Answer 1

I had the same problem after importing some new data into my DB.

Deleting and then recreating my MySql User worked for me.

Answer 2

This is an old question. I found that in C#, adding "sslMode=REQUIRED" to the connection string solved my problem. You can probably also try "sslMode=PREFERRED"

Hope that helps someone with this problem out.