{{tag>mysql 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:mariadb_reenable_password_authentication|mariadb reenable password authentication]]