Authentication plugin ‘caching_sha2_password’ cannot be loaded (SOLVED )100%

Error :- Connection failed: Authentication plugin ‘caching_sha2_password’ cannot be loaded:

/usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

Solution :-

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourpassword';
FLUSH PRIVILEGES;

Leave a Reply

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