MySQL 8

• MySQL 8 Your password does not satisfy the current policy requirements
• ERROR 1045 (28000): Plugin caching_sha2_password could not be loaded
• How to disable MySQL X Protocol (mysqlx_port)

MySQL 8 use caching_sha2_password as the default authentication method. Many MySQL clients still do not support this method. If you need to use the old method, you can set the authentication plugin as mysql_native_password. You can also set this as the default method by editing my.cnf file.

[mysqld]
default_authentication_plugin=mysql_native_password

To change a user to use mysql_native_password, run

ALTER USER 'USERNAME'@'localhost' IDENTIFIED WITH 'mysql_native_password' BY 'PASSWORD_HERE';