authentication method mysql 8.0查询_MySQL安装教程

方式一：

1.从MySQL官方网站（https://dev.mysql.com/downloads/mysql/）下载最新的MySQL压缩包：mysql-8.0.18-winx64.zip

2.将压缩包解压到指定文件夹

3.配置环境变量：略

4.编辑配置文件my.ini：

[mysqld]
port=3306
basedir=D:mysql8.0mysql-8.0.18-winx64
datadir=D:mysql8.0mysql-8.0.18-winx64data
max_connections=200
max_connect_errors=10
character-set-server=utf8mb4
default-storage-engine=INNODB
default_authentication_plugin=mysql_native_password
[mysql]
default-character-set=utf8mb4
[client]
port=3306

5.以管理员身份运行cmd，进入mysql的bin目录：

mysqld --initialize --console
mysqld --install
net start mysql
mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY '********';