MySQL 5.7.9 Installation-free configurationEnvironment: WIN10 64-bit
MySQL version: Mysql-5.7.9-winx64.zip (http://dev.mysql.com/downloads/mysql/)
First of all, 5.7.9 This version is configured differently than the previous install-free version. (The. msi installation and other versions of this method can be ignored)
Steps:
1, after downloading the Mysql-5.7.9-winx64.zip file on the official website, unzip to the specified directory: F:\java\mysql\mysql-5.7.9-winx64
2, create the Data folder in the F:\java\mysql\mysql-5.7.9-winx64 directory
3, rename My.default.ini to My.ini in the Bin directory, and add the following code in the My.ini directory:
Basedir = F:\java\mysql\mysql-5.7.9-winx64
DataDir = F:\java\mysql\mysql-5.7.9-winx64\data
Port = 3306
4, configuring environment variables, Path=f:\java\mysql\mysql-5.7.9-winx64\bin
5, open the command line with administrator privileges, go to the F:\java\mysql\mysql-5.7.9-winx64\bin directory,
Execution: mysqld--initialize--user=mysql--console
6, execute the above command first, the library will be generated. Note that there is a temporary password to write down.
F:\java\mysql\mysql-5.7.9\bin>mysqld--initialize--user=mysql--console2015-11-03t02:12:10.856918Z0 [Warning] TIMESTAMPWith implicitDEFAULT valueIsDeprecated. --explicit_defaults_for_timestamp server option (see documentationFor more details).2015-11-03t02:12:10.856918Z0 [Warning]' No_zero_date ',' No_zero_in_date 'and' Error_for_division_by_zero ' SQL modes should be usedWithStrict mode. They'll be mergedWithStrict modeIn aFuture release.2015-11-03t02:12:10.856918Z0 [Warning]' No_auto_create_user ' SQL mode wasNotSet.2015-11-03t02:12:14.162565Z0 [Warning] InnoDB:New log files created, lsn=457902015-11-03t02:12:14.884331Z0 [Warning] innodb:creating FOREIGN KEY constraint system tables.2015-11-03t02:12:15.123784Z0 [Warning] No existing UUIDhave been found, so we assume itIs the first time, this serverhas been started. Generating aNew UUID:4d177d5b-81d0- 11e5-bb66-c454443dc023. 2015-11-03T02: 12:15.176861z 0 [Warning] Gtid table is not ready to is used. Table ' mysql.gtid_executed ' cannot be opened. 2015-11-03t02: 12: 15.189872z 1 [Note] A temporary password is generated for [email protected]: >gqoshvy! 03e
7, such as the execution of the temporary password is: >gqoshvy!03e
8, perform the installation service command: Mysqld–install
9, Execute start service command: net start MySQL
10, here, MySQL is ready to install. Then execute: mysql-uroot-p
11, enter the password just now: >gqoshvy!03e
12, execute Password change command: Set password = password (' password ')
13, at this point, you changed the password of the root account to password.
MySQL 5.7.9 Installation-free configuration