centos7.2 mariadb 完成安全配置后出现 1045 (28000)，centos7.2mariadb

centos7.2 mariadb 完成安全配置后出现 1045 (28000)，centos7.2mariadb

错误详细:

mariadb 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

解决方法:

# systemctl stop mariadb.service

# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

mysql -u root mysql

MariaDB [mysql]> UPDATE user SET Password=PASSWORD('新密码') where USER='root'; 

MariaDB [mysql]> FLUSH PRIVILEGES;

MariaDB [mysql]> quit

# systemctl start mariadb.service
//重启服务,尝试进入控制台:

# mysql -u root -p
//输入刚刚设置的密码并回车