win10安装mysql8

1、下载

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

2、解压

步骤略

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

[mysql]
default-character-set=utf8mb4
[mysqld]
port = 3306 
basedir=D:mysql-8.0.23-winx64
datadir=E:mysqlspace8data
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