MySQL冷备份恢复数据库后,登录报错:
[root@localhost mysql]# vim /etc/my.cnf #添加skip-grant-tables设置免密登录
[root@localhost data]# systemctl restart mysqld
[root@localhost data]# mysql -uroot -p
mysql> set password for 'root'@'localhost' = password('abc123');
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
mysql> flush privileges; #修改密码报警,刷新权限
Query OK, 0 rows affected (0.00 sec)
mysql> set password for 'root'@'localhost' = password('abc123'); #密码修改成功
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> quit
Bye
[root@localhost data]# vim /etc/my.cnf
#进入配置文件,将之前的免密登录设置skip-grant-tables删除
[root@localhost data]# systemctl restart mysqld
[root@localhost data]# mysql -uroot -pabc123
# 在次登录验证