MySQL 5.7 zip file installation under Windows

1. Download the latest version of MySQL.

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

2. Unzip to the folder.

D:\software\mysql\mysql5.7a

Copy My-default.ini to My.ini

3. Edit My.ini

[Mysqld]

# These is 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 data directory.

4. Install the MySQL service.

Use Administrator Command mode.

Go to the Bin directory.

Execute command mysqld-install mysql57a

5. Initialization

Mysqld–initialize

The data generation directory is as follows:

6. Start the 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 log on again.

mysql–uroot–p–p3308

This time you don't have to enter a password to log in.

Execute the use MySQL

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

Delete again:

Skip-grant-tables configuration.

Restart the MySQL service.

Using commands

Mysql–uroot–proot–p3308 then it's ready.

MySQL 5.7 zip file installation under Windows