mariadb for Linux错误 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using passwor

解决办法重置密码。(生产上要注意,重启服务的哦,会断业务的)
mariadb for Linux错误 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using passwor
1、配置跳过mariadb验证
vi /etc/my.cnf
在[mysqld]后面任意一行添加“skip-grant-tables”用来跳过密码验证的过程
mariadb for Linux错误 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using passwor

2、重启mariadb
systemctl restart mariadb.service #重启MariaDB

3、登录
mariadb for Linux错误 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using passwor
4、修改密码
update mysql.user set password=password(‘linux’) where user=‘root’;
flush privileges;
quit
mariadb for Linux错误 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using passwor
5、删除配置文件中的 skip-grant-tables
mariadb for Linux错误 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using passwor
6、重启服务登录
mariadb for Linux错误 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using passwor