mysql8.0.19忘记密码处理方法详解

1在配置文件中添加skip-grant-tables后重启mysql，然后直接登录

[root@tyjs09 ~]# cat /etc/my.cnf
[mysqld]
user=mysql
basedir=/application/mysql
datadir=/data/mysql/data
socket=/tmp/mysql.sock
server_id=6
port=3306
gtid-mode=on
enforce-gtid-consistency=true
log_error=/data/mysql/data/mysql.log
log_bin=/data/binlog/mysql-bin
secure-file-priv=/tmp
innodb_flush_method=O_DIRECT
lower_case_table_names=1
skip-grant-tables