Table of Contents

,

Enable pwd auth on mysql 8.0 on CentOS

yum localinstall https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
yum install mysql-community-server
systemctl start mysqld
systemctl status mysqld
grep 'temporary password' /var/log/mysqld.log
mysql_secure_installation
UNINSTALL COMPONENT 'file://component_validate_password';
ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY 'password';
default-authentication-plugin = mysql_native_password
//validate_password.policy = 0
max_connections = 1024
max_connect_errors = 10000

Tested on

See also