在官网下载MySQL

解压后进入目录，创建配置文件my.cnf

[mysqld]
port=3306
basedir=C:\Program Files\MySQL\mysql-5.7.44-winx64
datadir=C:\Program Files\MySQL\mysql-5.7.44-winx64\data


default-storage-engine=INNODB
character_set_server=utf8
collation-server = utf8_general_ci
init_connect='SET NAMES utf8'
default-time-zone = '+08:00'
log_timestamps = system
lower_case_table_names = 1
symbolic-links=0
sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER'

back_log = 512
max_connections = 4096
max_connect_errors = 1024
max_allowed_packet = 50M

### cluster
server-id=1
slave_skip_errors=1032,1062
expire_logs_days=30

### master 主库
log-bin=mysql-bin
sync_binlog = 1
binlog-ignore-db = mysql,information_schema
binlog_checksum = none
binlog_format = mixed
binlog_cache_size=1M

### slave 从库
#relay-log=slave-relay-bin
#relay-log-index=slave-relay-bin.index
#log_slave_updates=1
#read_only=1

[mysqld_safe]
log-error=C:\Program Files\MySQL\mysql-5.7.44-winx64\data\mysqld.log

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

[mysql]
default-character-set=utf8

[WinMySQLAdmin]
C:\Program Files\MySQL\mysql-5.7.44-winx64\bin\mysqld.exe
#解压根目录\bin\mysqld.exe

配置环境变量

新建变量：MYSQL_HOME

变量值：C:\Program Files\MySQL\mysql-5.7.44-winx64

在Path中添加 %MYSQL_HOME%\bin

以管理员身份运行 CMD命令行程序

进入安装目录 cd C:\Program Files\MySQL\mysql-5.7.44-winx64\bin

运行命令 mysqld --initialize --console

命令行界面会返回初始密码

运行命令mysqld --install 安装MySQL服务

运行命令net start mysql 启动MySQL

运行命令mysql -uroot -p 输入前面获取的初始密码

修改初始密码，开启MySQL远程访问

# 修改初始密码
alter user 'root'@'localhost' identified by 'password';
# 开启远程访问 (改表法)
update user set host = '%' where user='root';
flush privileges;

windows开放端口

卸载MySQL的方法

以管理员身份运行 CMD命令行程序

进入mysql安装目录cd C:\Program Files\MySQL\mysql-5.7.44-winx64\bin

net stop mysql
sc delete mysql

删除文件夹C:\Program Files\MySQL\mysql-5.7.44-winx64 即可