MySQL 5.7 在 windows 安装方法

原官网下载地址： http://dev.mysql.com/downloads/mysql/

当前安装环境： windows 8.1 + mysql 5.7.13

解压文件到目录：D:\A_Software\mysql-5.7.13-winx64

创建目录：

D:\A_Software\mysql-5.7.13-winx64\log

D:\A_Software\mysql-5.7.13-winx64\data

D:\A_Software\mysql-5.7.13-winx64\data\binlog

以下都在命令行操作

配置文件

> D:\A_Software\mysql-5.7.13-winx64\my.ini

[mysqld]
basedir = "D:/A_Software/mysql-5.7.13-winx64/"
datadir = "D:/A_Software/mysql-5.7.13-winx64/data/"
tmpdir  = "D:/A_Software/mysql-5.7.13-winx64/data/"
socket  = "D:/A_Software/mysql-5.7.13-winx64/data/mysql.sock"
log-error = "D:/A_Software/mysql-5.7.13-winx64/log/mysql_log_err.log"
log-bin   = "D:/A_Software/mysql-5.7.13-winx64/data/binlog/mysql_bin.log"
secure-file-priv = null

port = 3306
server_id = 1
autocommit = 1
event_scheduler = 1
log_slave_updates = 1
explicit_defaults_for_timestamp = 1
max_connections = 100
binlog_format = row
character-set-server = utf8
default-storage-engine=innodb
transaction_isolation = read-committed

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER

# 环境变量
> set  PATH "%PATH%;D:\A_Software\mysql-5.7.13-winx64\bin;
> setx PATH "%PATH%;D:\A_Software\mysql-5.7.13-winx64\bin;

# 初始化
> mysqld --defaults-file="D:/A_Software/mysql-5.7.13-winx64/my.ini" --initialize --explicit_defaults_for_timestamp  

# 添加服务 (移除服务：mysqld remove)
> mysqld --install MySQL --defaults-file="D:/A_Software/mysql-5.7.13-winx64/my.ini" 

# 启动mysql服务（停止：net stop mysql）
> net start mysql

# 首次访问mysql (须重新设置root密码)
> mysql -u root
mysql> alter user 'root'@'localhost'identified by'mysql';
mysql> flush privileges;


#【另：忘记root密码设置方法】

# 停止服务，启动服务（忽略授权表）
> net stop mysql
> mysqld -nt --skip-grant-tables; 

# 打开另一个命令行窗口，重新访问mysql
> mysql -uroot

# 进入mysql更改root密码
mysql> select host,user from mysql.user;
mysql> alter user 'root'@'localhost'identified by'mysql';
mysql> flush privileges;
mysql> quit;

# 关闭服务窗口（mysqld -nt --skip-grant-tables）
> net start mysql
> mysql -u root -p