root@host51 ~]# vim /etc/my.cnf
[mysqld]
skip-grant-tables -----添加此行,该行的意思是跳过授权
#validate_password_policy=0
#validate_password_length=6
[root@host51 ~]# systemctl restart mysqld
[root@host51 ~]# /etc/init.d/mysqld restart
[root@host51 ~]# mysql
5,输入以下命令开始修改root用户的密码(注意:命令中mysql.user中间有个“点”)
mysql> update mysql.user set password=PASSWORD('新密码') where User='root';
6,刷新权限表
mysql> flush privileges;
7,退出
mysql> quit
在更改密码之后需要恢复之前的设置
root@host51 ~]# vim /etc/my.cnf
[mysqld]
#skip-grant-tables
[root@host51 ~]# systemctl restart mysqld
[root@host51 ~]# mysql -uroot -p'新密码'
mysql>alter user root@"localhost" identified by "123456";
Query OK, 1 row affected, 1 warning (0.06 sec)
6,刷新权限表
mysql> flush privileges;
7,退出
mysql> quit
4、 重启服务:
执行:
killall mysqld (杀死mysql进程)
/etc/init.d/mysql start (启动mysql服务