windows mysql 免安装版_windows部署mysql（免安装版）

1、官网 https://dev.mysql.com/downloads/mysql/ 下载mysql.zip;

选择需要的版本下载

2、解压后会发现没有data目录(这时启动会失败)

解决：cd到mysql的bin目录执行下mysqld --initialize命令再继续下面的配置即可成功

3、重置root密码(123456)

a.停止mysql服务

b.已管理员身份 打开一个cmd窗口输入mysqld --skip-grant-tables，注意这个cmd命令窗口不要关闭

c.重新打开一个cmd窗口，运行下面命令

C:\Users\Administrator>mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 4

Server version: 5.7.19 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>use mysql

Database changed

mysql>update user set authentication_string=password('123456') where user='root';

Query OK, 0 rows affected, 1 warning (0.06 sec)

Rows matched: 1  Changed: 0  Warnings: 1

mysql>

将mysql的root密码重置为123456

这样就可以了