mysql数据库跳过密码设置密码的方法主要是通过修改配置文件的方法
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 ~]# mysql
mysql> update mysql.user
-> set
-> authentication_string=password("654321")
-> where
-> user="root" and host="localhost";
Query OK, 1 row affected, 1 warning (0.06 sec)
Rows matched: 1 Changed: 1 Warnings: 1
在更改密码之后需要恢复之前的设置
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 ~]# mysql -uroot -p654321
mysql>alter user root@"localhost" identified by "123456";
Query OK, 1 row affected, 1 warning (0.06 sec)