windows下安装mysql5.7版本

具体步骤如下：

1. 从官网下载对应的版本。官方网址：mysql服务下载地址
2. 解压到本地。我的路径是：D:\Program Files\mysql-5.7.16-winx64
3. 设置环境变量。
   • 添加一个系统变量。变量名：MYSQL_HOME，变量值是mysql的安装目录，我这里是：D:\Program Files\mysql-5.7.16-winx64
   • 在Path变量中添加的末尾添加 ;%MYSQL_HOME%\bin
4. 在安装目录下新建一个文本文档，并改名为 my.ini，并添加如下内容，保存。

[WinMySQLAdmin]
Server=D:\Program Files\mysql-5.7.16-winx64\bin\mysqld.exe
[mysqld]
basedir=D:\Program Files\mysql-5.7.16-winx64
datadir=D:\Program Files\mysql-5.7.16-winx64\data
port = 3306
server_id = 1
max_connections=1024
log_bin = mysql-bin
explicit_defaults_for_timestamp = TRUE

5. 在安装目录下新建一个文件夹命名为data用来存放数据。

6. 管理员身份进入cmd执x行初始化命令:mysqld --initialize --user=mysql --console

C:\Users\Administrator>mysqld --initialize --user=mysql --console
2016-12-07T07:29:17.384477Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-12-07T07:29:18.266527Z 0 [Warning] InnoDB: Creating foreign key constraint
system tables.
2016-12-07T07:29:18.648549Z 0 [Warning] No existing UUID has been found, so we a
ssume that this is the first time that this server has been started. Generating
a new UUID: dd3b2bf3-bc4e-11e6-8a79-6c0b8469263a.
2016-12-07T07:29:18.693552Z 0 [Warning] Gtid table is not ready to be used. Tabl
e 'mysql.gtid_executed' cannot be opened.
2016-12-07T07:29:18.727554Z 1 [Note] A temporary password is generated for [email protected]
localhost: x>%B_fO)v1VV

产生一个随机密码，用记事本保存下来：x>%B_fO)v1VV

如果出现了以下警告：

2016-12-07T07:18:13.748519Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see doc
umentation for more details).

检查你的my.ini 中explicit_defaults_for_timestamp = TRUE是否配置正确

2016-12-07T07:18:13.749519Z 0 [ERROR] --initialize specified but the data direct
ory has files in it. Aborting.

这是前面安装失败导致D:\Program Files\mysql-5.7.16-winx64\data下产生了旧数据，将旧数据删掉即可。

7. 输入安装命令：mysqld --install

C:\Users\Administrator>mysqld --install
Service successfully installed.

表示安装成功

8. 输入启动命令：net start MySQL

C:\Users\Administrator>net start MySQL
发生系统错误 2。
系统找不到指定的文件。

解决办法：修改mysql注册表。

开始-->运行-->regedit-->HKEY_LOCAL_MACHINE-->SYSTEM-->CurrentControlSet-->services-->mysql(服务名)-->ImagePath

将ImagePath的路径更改为：

"安装目录\bin\mysqld" --defaults-file="安装目录\my.ini" MySql
我这里是：
"D:\Program Files\mysql-5.7.16-winx64\bin\mysqld" --defaults-file="D:\Program Files\mysql-5.7.16-winx64\my.ini" MySql
更改后 服务成功启动。

>MySql 服务正在启动 .

MySql 服务已经启动成功。

9. 输入进入mysql命令：mysql -u root -p

   D:\Program Files\mysql-5.7.16-winx64\bin>mysql -u root -p
   Enter password: 这里输入第6步产生的随机密码
   Welcome to the MySQL monitor. Commands end with ; or \g.
   Your MySQL connection id is 2
   Server version: 5.7.16-log
   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.
   mysql>

   出现了mysql> 表示成功进入到mysql

10. 修改root用户的初始密码：set password for [email protected] = password('要修改的密码');

mysql> set password for [email protected] = password('要修改的密码');
Query OK, 0 rows affected, 1 warning (0.01 sec)

11. 查看mysql数据库：show databases;

mysql> show databases;
+--------------------+
| Database |
+--------------------+

| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)

参考文章：
http://jingyan.baidu.com/article/8cdccae946133f315513cd6a.html
http://blog.csdn.net/yanlintao1/article/details/52202736
http://www.oschina.net/question/727667_121198