MySQL_Win_Install

my.ini

[mysqld]
# 端口
port=3306
# 安装目录
basedir="D:\\yue\\software\\environment\\MySQL\\mysql-5.7.34-winx64"
# 数据的存放目录
datadir="D:\\yue\\software\\environment\\MySQL\\mysql-5.7.34-winx64\\data"
# 允许最大连接数
max_connections=200
# 允许连接失败的次数
max_connect_errors=10
# 服务端使用的字符集默认为utf8mb4
character-set-server=utf8mb4
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
# 插件认证方式
default_authentication_plugin=mysql_native_password
# SQL 模式
sql-mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
[mysql]
# 客户端默认字符集
default-character-set=utf8mb4
[client]
# 客户端连接服务端时默认使用的端口
port=3306
default-character-set=utf8mb4

配置环境变量：

%MYSQL_HOME%：D:\yue\software\environment\MySQL\mysql-5.7.34-winx64

PATH：%MYSQL_HOME%/bin

管理员运行 power shell

cd D:\yue\software\environment\MySQL\mysql-5.7.34-winx64\bin
mysqld --initialize
mysqld --install mysql5
net start mysql5
mysql -u root -p

初始密码：

D:\yue\software\environment\MySQL\mysql-5.7.34-winx64\data\LAPTOP-BUPJ0RRK.err

# 修改密码
alter user 'root'@'localhost' identified by '123456';
# 允许外部访问
grant all privileges on *.* to root@'%' identified by '123456' with grant option;
flush privileges;

删除服务

# 停止服务
net stop mysql5

win + r services.msc 停止服务

win + r regedit 在注册表中删除

# 删除服务
sc delete mysql5