MySQL 5.7 Zip files in Windows installation tutorial detailed _mysql

1. Download the latest version of MySQL.

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

2. Extract to Folder.

D:\software\mysql\mysql5.7a

Copy My-default.ini to My.ini

3. Editor My.ini

# These are commonly set, remove the # and set as required. 
Basedir = "d:/software/mysql/mysql57a" 
datadir = "D:/software/mysql/mysql57a/data" 
port=3308

Modify the installation directory and the data directory.

4. Install MySQL service.

Use Administrator Command mode.

Go to the Bin directory.

Execute command mysqld-install mysql57a

5. Initialize

Mysqld–initialize

The data generated in the directory is as follows:

6. Start MySQL service.

Net–start mysql57a

7. Password-Free login configuration.

The first logon generally does not have a password, if you cannot log in follow the steps below.

mysql–uroot–p–p3308

Add Configuration in My.ini

Skip-grant-tables

Restart the service and retry the logon.

mysql–uroot–p–p3308

This time you do not have to enter the password to log in.

Execute use MySQL

Update Mysql.user set Authentication_string=password (' root ') where user= ' root ';

And then delete:

Skip-grant-tables configuration.

Restart the MySQL service.

Using commands

mysql–uroot–proot–p3308 and then it's OK.

The above is a small set to introduce the MySQL 5.7 zip file in Windows installation tutorial detailed, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!