wiki:enable_pwd_auth_on_mysql_8.0_on_centos
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
- mysql 8.0
See also
wiki/enable_pwd_auth_on_mysql_8.0_on_centos.txt · Last modified: 2021/03/08 15:55 by antisa