windows zip安装mysql_Windows下压缩包安装Mysql

1. 下载mysql压缩包

2. 解压到指定目录，例如D:\Program Files\mysql-5.7.25-winx64

3. 在目录下创建配置文件my.ini

[mysqld]

port= 3306basedir=D:/Program Files/mysql-5.7.25-winx64

datadir=D:/Program Files/mysql-5.7.25-winx64/data

max_connections=200character-set-server=utf8default-storage-engine=INNODB

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysql]default-character-set=utf8

4. 安装命令

D:\Program Files\mysql-5.7.25-winx64\bin>mysqld -install

Service successfully installed.//安装成功

5. 初始化命令

D:\Program Files\mysql-5.7.25-winx64\bin>mysqld --initialize-insecure --user=mysql

成功没有提示，失败有相应提示。

6. 启动命令

D:\Program Files\mysql-5.7.25-winx64\bin>net start mysql

MySQL 服务正在启动 .

MySQL 服务已经启动成功。

7. 修改密码

D:\Program Files\mysql-5.7.25-winx64\bin>mysqladmin -u root -p password 123456 //123456就是设置的密码

Enter password: //由于默认没有密码，直接回车即可

8. 一个典型的问题

在执行步骤4的时候，提示已经安装

D:\Program Files\mysql-5.7.25-winx64\bin>mysqld -install

The service already exists!The current server installed:"D:\Program Files\mysql-5.7.23-winx64\bin\mysqld" MySQL

此时需要执行以下命令：

8.1 确认Mysql服务是否已经注册

D:\Program Files\mysql-5.7.25-winx64\bin>sc query mysql

SERVICE_NAME: mysql

TYPE :10WIN32_OWN_PROCESS

STATE :1STOPPED

WIN32_EXIT_CODE :0 (0x0)

SERVICE_EXIT_CODE :0 (0x0)

CHECKPOINT :0x0WAIT_HINT :0x7d0

8.2 删除注册服务

D:\Program Files\mysql-5.7.25-winx64\bin>sc delete mysql

[SC] DeleteService 成功

可以重新安装了mysqld -install