准备my.ini文件
[mysql]
skip-grant-table
default-character-set=utf8
[mysqld]
port=3306
basedir=G:\mysql-8.0.20-winx64
datadir=G:\mysql-8.0.20-winx64\data
max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
explicit_defaults_for_timestamp=1
修改密码:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码'