64-bit WIN10 system installs the Green Edition mysql-5.7.16-winx64 tutorial _mysql

This article mainly introduces the 64-bit WIN10 system to install the green version of the Mysql-5.7.16-winx64 method, the specific content as follows:

1. Download MySQL Community Server

Address: http://dev.mysql.com/downloads/mysql/

Select Windows (x86, 64-bit), ZIP Archive for download.

2. Unpack the MYSQL installation package to the specified directory , my directory for D:\Program files\mysql\mysql-5.7.16-winx64, and copy a copy of My-default.ini file for backup.

3. Modify the My-default.ini file

Basedir = D:\Program files\mysql\mysql-5.7.16-winx64

DataDir = D:\Program Files\mysql\mysql-5.7.16-winx64\data

Port = 3306

Note: Remove source file above three lines before #

4. Add Environment variables

New system variable mysql_home, variable value: D:\Program files\mysql\mysql-5.7.16-winx64

Modify the system variable path to add%mysql_home%\bin;

Note: The values of the variables should be separated by English;

5. Registering Windows System Services

Open cmd with administrator privileges and enter the D:\Program Files\mysql\mysql-5.7.16-winx64\bin directory,

Enter Service installation command: mysqld install MySQL--defaults-file= "D:\Program Files\mysql\mysql-5.7.16-winx64\my-default.ini"

The registry to view the value of ImagePath, my "D:\Program files\mysql\mysql-5.7.16-winx64\bin\mysqld"--defaults-file= D:\Program files\ Mysql\mysql-5.7.16-winx64\my-default.ini "MySQL, which contains the mysqld, will not be modified.

The registry location is: \hkey_local_machine\system\currentcontrolset\services\mysql
Perform initialization of mysqld--initialize (Generate Data directory)

Execute net start MySQL

6. Modify root default password

Looking for MYSQL's initial password, use Notepad to open the D:\Program files\mysql\mysql-5.7.16-winx64\data directory suffix to err file, my for Desktop-kcihhjt.err

Search password keyword, my message is: A temporary password are generated for root@localhost: =2v&i*7nab0r
The generated initial password is =2v&i*7nab0r

Execute mysql-uroot-p

Enter the above initial password, you can enter the MySQL

Execute Set PASSWORD = PASSWORD (' 123456 ');

Change the password to 123456

Use Exit to exit MySQL, and then you can log in with the new password.

The above is a small set to introduce the 64-bit WIN10 system installed green version of the mysql-5.7.16-winx64 tutorial, 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!