Monday, October 18, 2021

I am getting error while conencting to MySQL server - "Unable to load authentication plugin ‘caching_sha2_password’.

 The issue is not with Toad Edge but with MySQL 8.

  1. Change the encryption of the user’s password by altering the user with below Alter command :

ALTER USER ‘username’@‘ip_address’ IDENTIFIED WITH mysql_native_password BY ‘password’;

Or

  1. Change the authentication plugin in my.cnf file for Linux / my.ini file in Windows:

[mysqld]

default_authentication_plugin=mysql_native_password

Restart the mysql server to take the changes in affect and try connecting via mysql with any mysql client.

No comments:

Post a Comment