mysql-5.7.16-winx64 装配_mysql

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

我这里下载的是：MySQL Community Server 5.7.16（Windows (x86, 64-bit), ZIP Archive）

win7 系统安装到D盘根目录

1、将压缩包解压到D盘根目录

      D:/mysql-5.7.16-winx64

2、修改D:/mysql-5.7.16-winx64/my-default.ini文件

 basedir = D:/mysql-5.7.16-winx64  datadir = D:/mysql-5.7.16-winx64/data  port = 3306  server_id = 1  tempdir = D:/mysql-5.7.16-winx64/temp   skip-grant-tables skip-networking 

完整配置如下：

# For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the # *** default location during install, and will be replaced if you # *** upgrade to a newer version of MySQL.  [mysqld]  # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M  # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin  # These are commonly set, remove the # and set as required.  basedir = D:/mysql-5.7.16-winx64  datadir = D:/mysql-5.7.16-winx64/data  port = 3306  server_id = 1  tempdir = D:/mysql-5.7.16-winx64/temp   # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M   sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES   #修改mysql 配置文件跳过密码验证，密码修改完成后请将他们注释掉 skip-grant-tables skip-networking

3、添加系统变量MYSQL_HOME,变量值为：D:/mysql-5.7.16-winx64

在系统变量path中添加%MYSQL_HOME%/bin;(记得加英文分号)

4、安装mysql 服务

以系统管理员身份打开cmd命令行，命令行中切换到D:/mysql-5.7.16-winx64/bin目录，输入：

mysqld --install

5、初始化mysql

还是在刚才的命令窗口，输入：

mysqld --initialize

 输入命令后会创建data目录及相关文件

6、启动mysql服务

net start MySQL

7、修改root默认密码

用记事本打开D:/mysql-5.7.16-winx64/data/下后缀位.err 的文件。我这里是WIN-6.err。

查找password，这里v%eKW7DekFrt是随机生成的密码，用于下面登陆使用。

[Note] A temporary password is generated for root@localhost: v%eKW7DekFrt

8、执行mysql -uroot -pv%eKW7DekFrt登陆mysql

mysql -uroot -pv%eKW7DekFrt

9、输入命令修改密码

SET PASSWORD = PASSWORD('123456');

密码设置为123456，exit退出MySQL，然后就可以重新登陆了。

————————————————————————————————————

在到第6步，启动MySQL服务时候遇到一个问题，服务无法启动，提示没有错误信息。。。

通过下面命令删除，重新安装了一下，然后启动服务ok。

mysqld –romve 删除mysql服务

mysqld –install 安装mysql服务

mysqld –initialize 一定要初始化

net start mysql 启动服务