MySQL 5.7.27 x64 windows 安装 配置

下载地址

https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.27-winx64.zip

安装

zip解压到 D:\download\mysql-5.7.27-winx64

配置

• 新建配置文件D:\download\mysql-5.7.27-winx64\my.ini
• 编辑my.ini

[mysqld]
basedir = D:\\download\\mysql-5.7.27-winx64
datadir = D:\\download\\mysql-5.7.27-winx64\\data
port = 3306
character_set_server=utf8
autocommit=0
transaction-isolation = READ-COMMITTED
# max_allowed_packet = 32M
# sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
# sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
[client]
default-character-set=utf8

• 设置D:\download\mysql-5.7.27-winx64\bin到windows环境变量path
• 管理员身份运行cmd黑窗口
• 安装服务
  • 如果不带上前面这串【D:\download\mysql-5.7.27-winx64\bin\】路径的话，安装的服务的启动路径是【“C:\Program Files\MySQL\MySQL Server 5.7\mysqld”】

D:\download\mysql-5.7.27-winx64\bin\mysqld install

• 初始化

mysqld --initialize	

• 启动MySQL服务
  • 这里的参数mysql不区分大小写，MySQL，mysql都可以

net start mysql

• 停止MySQL服务

net stop mysql

• 移除服务

mysqld remove

• 查找初始密码
  • D:\download\mysql-5.7.27-winx64\data\DESKTOP-M3NNULT.err

A temporary password is generated for root@localhost: !jiePQ.yK7Lo