步骤如下:
1、[root@node104 ~]# systemctl stop mysqld.service
2、[root@node104 ~]# vi /etc/tc/my.cnf
3、在my.cnf中增加skip-grant-tables,退出vi
4、[root@node104 ~]# systemctl start mysqld.service
5、[root@node104 ~]# mysql -u root -p ----此时不需要密码登录
6、在-->mysql命令模式下执行UPDATE user SET authentication_string = PASSWORD('root') WHERE user = 'root';
7、立刻生效FLUSH PRIVILEGES;
8、[root@node104 ~]# systemctl stop mysqld.service
9、[root@node104 ~]# vi /etc/tc/my.cnf --->去除skip-grant-tables
10、 [root@node104 ~]# systemctl start mysqld.service
11、[root@node104 ~]# mysql -u root -p --->此次登录需输入刚才设置的密码
12、ok .....