1、下载

地址: https://dev.mysql.com/downloads/mysql/

win10安装mysql8_初始化



2、解压

步骤略


3、在mysql目录下新建my.ini

[mysql]
default-character-set=utf8mb4
[mysqld]
port = 3306 
basedir=D:\mysql-8.0.23-winx64
datadir=E:\mysqlspace\8\data
max_connections=200
character-set-server=utf8mb4
default-storage-engine=INNODB



4、使用管理员打开cmd，进入到mysql的bin目录下

#安装服务
mysqld install

#无密码初始化
mysqld --initialize-insecure --user=root --console

#启动服务
net start mysql

#使用客户端连接mysql
mysql -uroot

#连接后修改root密码，支持远程访问
update user set Host = '%';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

#退出客户端
exit


ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';