mysql windows下安装

1,下载文件我这里是mysql-5.7.15-winx64.zip 解压到一个目录
2，检查旧的服务是否删除，否则执行sc delete mysql
   删除，切换到bin目录下，执行mysqld --remove 我的当前目录是D:\software\mysql\mysql-5.7.15-winx64\bin
3，创建配置文件my.ini(解压的根目录)
内容：
[mysqld]
#basedir代表自己MySQL的安装根目录
basedir = D:\\software\\mysql\\mysql-5.7.15-winx64
#datadir代表自己MySQL的数据库保存的目录，如果没有在MySQL安装的根目录下新建一个data文件夹
datadir = D:\\software\\mysql\\mysql-5.7.15-winx64\\data
#port代表端口号
port = 3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
4，使用管理员启动dos并切换到mysql根目录，执行安装和启动服务操作
D:\software\mysql\mysql-5.7.15-winx64>bin\mysqld --defaults-file=my.ini --initialize-insecure
D:\software\mysql\mysql-5.7.15-winx64>bin\mysqld --install
Service successfully installed.

D:\software\mysql\mysql-5.7.15-winx64>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。

如果想安装一个不同名字的服务请执行：

bin\mysqld --install MySQL57 --defaults-file=“D:\software\mysql\mysql-5.7.15-winx64\my.ini”

4，测试

D:\software\mysql\mysql-5.7.15-winx64>bin\mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.15 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, 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.