Mysql-5.7.11-winx64.zip installation Configuration

1. Download

Http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.11-winx64.zip

2. Unzip the ZIP package;

D:\Program files\mysql-5.7.11-winx64

3. Configure environment variables,

3.1 Add path Path,

D:\Program Files\mysql-5.7.11-winx64\bin

3.2. Modify the Mysql-default.ini configuration file,

Original

# These is commonly set, remove the # and set as required.# Basedir = ... # datadir = .... # port = .... # server_id =. ....

Switch

# These is commonly set, remove the # and set as required.  Basedir = D:\Program files\mysql-5.7.11-winx64 datadir = D:\Program files\mysql-5.7.11-winx64\data port = 3306# server_id = .....

4. Enter command prompt cmd as Administrator

Microsoft Windows [Version 6.1.7601]copyright (c)2009Microsoft Corporation. All rights reserved. C:\Windows\system32>mysqld--initialize--user=mysql--Console2016-05-08t02:58:49.494014z 0 [Warning] TIMESTAMP with implicitDEFAULTvalue is deprecated. please use--explicit_defaults_for_timestamp server Option (see documentation forMore details).2016-05-08t02:58:49.530016z 0[Warning] ' no_zero_date ', ' no_zero_in_date ' and ' Error_for_division_by_zero ' SQL modes should is used with strict mod E. They willbe merged with strict modeincha future release.2016-05-08t02:58:49.530016z 0[Warning] ' no_auto_create_user ' SQL mode is not set.2016-05-08t02:58:52.348376z 0 [Warning] innodb:new log files created, lsn=457902016-05-08t02:58:52.869005z 0[Warning] innodb:creating foreign key constraintsystem tables.2016-05-08t02:58:53.432037z 0[Warning] No existing UUID have been found, so we assume that's the first time that this server has been started . Generatinga New uuid:cc42ac67-14c8-11e6-90e5-08606e8d1296.2016-05-08t02:58:53.533043z 0[Warning] Gtid table is not a ready-to-be used. Table ' mysql.gtid_executed ' cannot be opened.2016-05-08t02:58:53.791057z 1 [Note] A temporary password is generated for[Email protected]localhost:uis<c (. I (0ygc:\windows\system32>d:d:\>CD Mysqld:\mysql>D:\mysql>mysqld--install Mysqlservice successfully installed. D:\mysql>net start mysqlthe MySQL service is starting. The MySQL service was started successfully. D:\mysql>mysql-u Root-penter password:uis<c (. I (0ygset password for[email protected] = password (' hxl520 ');

Mysql-5.7.11-winx64.zip installation Configuration