ERROR 1045 (28000): Plugin caching_sha2_password could not be loaded

When I try to connect to a MySQL 8 server, I get the following error

This is because of MySQL 8 use more secure authentication. This is not supported by your MySQL installation. What you can do is connect using MySQL 8 client or change the authentication method to use old authentication.

To create a user with the old authentication method, use the following SQL commands

To change a user to use mysql_native_password, run

if you need to set this server wide, edit my.cnf and add

See MySQL

Leave a Reply

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