Solution: After centos7.2 mariadb completes the security configuration, 1045 (28000) appears)

Solution: After centos7.2 mariadb completes the security configuration, 1045 (28000) appears)

Error details:

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

Solution:

# Systemctl stop mariadb. service # mysqld_safe -- user = mysql -- skip-grant-tables -- skip-networking & mysql-u root mysqlMariaDB [mysql]> UPDATE user SET Password = PASSWORD ('new password ') where USER = 'root'; MariaDB [mysql]> flush privileges; MariaDB [mysql]> quit # systemctl start mariadb. service // restart the service and try to enter the console: # mysql-u root-p // enter the password you just set and press ENTER