User Tools

Site Tools


wiki:enable_pwd_auth_on_mysql_8.0_on_centos

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

Except where otherwise noted, content on this wiki is licensed under the following license: CC0 1.0 Universal
CC0 1.0 Universal Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki