Tuesday, May 11, 2021

authentication plugin caching_sha2_password is not supported

 Getting the below error message when you connect to mysql8

authentication plugin caching_sha2_password is not supported

In MySQL 8.0, caching_sha2_password is the default authentication plugin rather than mysql_native_password.

Login to Mysql as root

Check whether the mysql user plugin is mysql_native_password or caching_sha2_password

select Host,User,plugin from mysql.user;

If its caching_sha2_password, change to mysql_native_password

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '{Password}';


Try now!

No comments:

Post a Comment