Install mysql 5.7 zip file in windows, mysql5.7

Install mysql 5.7 zip file in windows, mysql5.7

1. download the latest mysql version.

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

2. decompress the package to the folder.

D: \ software \ mysql \ mysql5.7a

 

Copy my-default.ini TO my. ini

 

3. edit my. ini

[Mysqld]

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

4. Install the mysql service.

Use the Administrator command mode.

Go to the bin directory.

Run 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 Login usually has no password. If you cannot log on, follow the steps below.

Mysql-uroot-p-P3308

 

Add configuration in my. ini

Skip-grant-tables

Restart the service and try again.

Mysql-uroot-p-P3308

You do not need to enter the password to log on this time.

Run use mysql

Update mysql. user set authentication_string = password ('root') where user = 'root ';

Delete again:

Skip-grant-tables configuration.

Restart the mysql service.

Use commands

Mysql-uroot-proot-P3308 then.