跳过密码检测
1.在[mysqld]模块内添加跳过密码检测策略
[root@localhost ~]# vim /etc/my.cnf
skip-grant-tables
2.重启mysqld服务
[root@localhost ~]# systemctl restart mysqld
3.进入数据库修改密码
[root@localhost ~]# mysql -u root
5.6版本修改密码
mysql> update mysql.user SET PASSWORD=PASSWORD(‘321.com’) WHERE user=‘root’;
5.7版本修改密码
mysql> UPDATE mysql.user SET authentication_string=password(‘123.com’) where User=‘root’ and Host = ‘localhost’;
mysql> FLUSH PRIVILEGES;
mysql> EXIT;
4.删除my.cnf 跳过密码检测策略参数
skip-grant-tables
重启mysqld服务,用新设置的root密码进行登录
[root@localhost ~]# mysql -u root -p123.com