MySQL8 免安装版安装

下载地址

MySQL :: Download MySQL Community Server

解压后

创建 my.ini

[mysqld]
port=3306
basedir=E:\\httpserver\\mysql\\mysql-8.0.30-winx64
datadir=E:\\httpserver\\mysql\\mysqlData
max_connections=200
max_connect_errors=10
default-time-zone=+08:00
character-set-server=utf8mb4
default_authentication_plugin=mysql_native_password
default-storage-engine=INNODB

[mysql]
default-character-set=utf8

[client]
port=3306
default-character-set=utf8

管理员 CMD

@ 初始化: 会生成mysql初始密码，一定要记录
mysqld --defaults-file=E:\\httpserver\\mysql\\mysql-8.0.30-winx64\\my.ini --initialize --console

@ 安装服务
mysqld --install MySQL8 --defaults-file=E:\httpserver\mysql\mysql-8.0.30-winx64\my.ini 

@卸载服务
mysqld -remove MySQL8

@启动服务
net start MySQL8

@停止服务
net stop MySQL8

@使用初始化密码进入mysql
mysql -u root -pSuPAo&d8Y3+S

@修改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
@提交
flush privileges;