Mysql Error: Authentication requires secure connection.

Authentication requires secure connection.

This is an error usually seeing in MySQL-8.0 while connecting to database. In MySQL 8.0, caching_sha2_password is the default authentication plugin rather than mysql_native_password in earlier versions. To connect to the server using the caching_sha2_password plugin, we must use either a secure connection or an unencrypted connection that supports password exchange using an RSA key pair.

Inorder to solve this problem, we can change the encryption of the user's password by altering the user with the alter command.

ALTER USER 'username'@'host' IDENTIFIED WITH mysql_native_password BY 'password';

Here we need to replace the values of username, host and password with the corresponding data.

Now the user can be connect to the database without any issues.

That's all…

Leave a Reply

Your email address will not be published. Required fields are marked *