win10安装mysql8

[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

#安装服务
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