Linux MySQL8忘记密码，已启动无法连接

MySQL应为在写shell脚本多次MySQL控制台外操作数据库，导致进不去了

先说错误怎么造成的
写shell想让他自动化修改初始密码，然后就不断调试，最后导致MySQL直接登录不上了
mysql版本为8以上

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

经过不断的调试排错，感觉密码被改了，但是试了所有密码都不行
所以采用一点暴力的手段，进入维护模式
修改MySQL的配置文件

vim /etc/my.cnf
#加入以下内容
skip-grant-tables

#然后重新启动MySQL
[root@master bin]# systemctl start mysqld
[root@master bin]# mysql

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
mysql> select user,host,authentication_string from mysql.user;
+------------------+-----------+------------------------------------------------------------------------+
| user             | host      | authentication_string                                                  |
+------------------+-----------+------------------------------------------------------------------------+
| root             | %         | $A$005$8y{>!">Lyd^?{e\TPFA55BNDDkDOiUWxTrzK.GAZJvGp6DeD8ypcWD0pf1C |
| mysql.infoschema | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.session    | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.sys        | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
+------------------+-----------+------------------------------------------------------------------------+
4 rows in set (0.00 sec)

mysql> update mysql.user set authentication_string=password('root') where user='root';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('root') where user='root'' at line 1

我们发现一些修改密码的命令都不能用，所以我们用下面的命令‘

mysql> use mysql;
mysql> update user set authentication_string='' where user='root';
mysql> flush privileges;
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你要修改的密码';
mysql> flush privileges;

然后我们把my.cnf里面添加的东西删掉，重新启动MySQL用新的密码就可以登录了

成功！！！！