Latest installation tutorials for mysql-5.7.17, mysql-5.7.17 tutorials

Latest installation tutorials for mysql-5.7.17, mysql-5.7.17 tutorials

 

Mysql-5.7.17-winx64 is now the latest version of Mysql, which is free of installation, so you need to make some configuration: 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
Port = 3306
; Set the installation directory of mysql
Basedir = E: \ mysql5.7
Set the directory for storing mysql database data
Datadir = E: \ mysql5.7 \ data
; Maximum number of connections allowed
Max_connections = 200
The default character set used by the server is the 8-bit latin1 character set.
Character-set-server = utf8
The default storage engine used to create a new table
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 the new button under system variables, and enter the variable name: MYSQL_HOME. Enter the 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:) EnterMysqld installPress enter to run it. Note that mysqld is not mysql.

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

6: EnterNet start mysqlStart 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.