mysql-authentication-plugin-caching-sha2-password-is-not-supported

/etc/my.cnf
default-authentication-plugin=mysql_native_password

SELECT user, host, plugin FROM mysql.user;

mysql > CREATE USER 'username'@'hostname' IDENTIFIED WITH mysql_native_password BY 'password';