The latest installation tutorial for mysql 5.7.17 is illustrated in the text.

The latest installation tutorial for mysql 5.7.17 is illustrated in the text.

Mysql-5.7.17-winx64 is now the latest version of Mysql, which is free of installation, so some configuration is required

: Https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17-winx64.zip

1. Download the installation package and decompress it to a folder.

2: copy the my-default.ini, rename it my. ini, and open the input mysql basic configuration in Notepad:

[Mysql]; set the default character set of the mysql client default-character-set = utf8 [mysqld]; set port 3306 = 3306; set the mysql installation directory basedir = E: \ mysql5.7; set datadir = E: \ mysql5.7 \ data as the data storage directory of the mysql database; max_connections = 200; the default character set used by the server is the 8-bit latin1 character set character-set-server = utf8. When creating a new table, the default storage engine default-storage-engine = INNODB

3: Set Environment Variables

The procedure is as follows:

1) Right-click my computer-> properties-> advanced system settings (advanced)-> Environment Variables

Click new Under System Variables

Input variable name: MYSQL_HOME

Input variable value: E: \ mysql-5.7.17

2) Select the Path in the system variable and click the edit button to add the variable value to the variable value: % MYSQL_HOME % \ bin. Note that this variable is added to the original variable value and separated, the original variable value cannot be deleted.

4: Open the cmd window as an administrator and switch the directory to the bin directory of the decompressed file. (Details: Enter mysqld install and press enter to run the command. Note that mysqld is not mysql.

5: Enter the "mysqld -- initialize -- console" command to obtain the mysql initial password. The purpose of mysqld -- initialize is to initialize the data directory. Otherwise, the data folder does not appear in the folder of mysql5.7.

6: Enter net start mysql to start the service. (Net stop mysql Service)

7: start using mysql, enter the command: mysql-uroot-p, and then enter the initial password.

8. Change the password.

9: mysql> flush privileges; # update Permissions

10: Exit quit.

11. log out of the system and enter mysql-u root-p. Log On with the username root and the new password 123456.

The above is a detailed description of the latest mysql 5.7.17 installation tutorial. I hope it will help you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!