Mysql5.7.17 winx64.zip unzip version installation configuration graphic tutorial,

Mysql5.7.17 winx64.zip unzip version installation configuration graphic tutorial,

1.download mysql-5.7.17-winx64.zip;

Link: https://pan.baidu.com/s/1tTqT2sn7cEaOwEvrQ-LrHg password: i444

2. decompress the package to a folder (for example ):

Decompress the package to the current folder.

3. modify the configuration file:

Open the decompressed folder (configuration file location for this example D: \ Development \ mysql \ mysql-5.7.17-winx64 \ mysql-5.7.17-winx64 \), delete the my-default.ini, and create a new my. ini

 

Modify my. ini as follows:

[Mysql] # set the default character set of the mysql client default-character-set = utf8 [mysqld] skip-grant-tables # set port 3306 = 3306 # set the mysql installation directory basedir = D: \ Development \ mysql \ mysql-5.7.17-winx64 \ mysql-5.7.17-winx64 # Set the mysql database data storage directory datadir = D: \ Development \ mysql \ mysql-5.7.17-winx64 \ mysql-5.7.17-winx64 \ data # maximum number of connections allowed max_connections = 200 # the character set used by the server defaults to the 8-bit latin1 character set character-set-server = utf8 # create a new table default-storage-engine = INNODB

Note: basedir = your own mysql installation path;
Datadir = mysql directory \ data;

4. Configure the environment variable Path

Right-click my computer-> properties-> advanced system settings-> environment variables-> Find Path from System Variables

Add the bin Path in the mysql directory to the end of Path (do not overwrite the original Path value ):

;D:\Development\mysql\mysql-5.7.17-winx64\mysql-5.7.17-winx64\bin 

5. Open cmd as an administrator

Click Start to search for cmd.

 

Click cmd.exe on the right and run it as an administrator.

6. Enter the mysql bin directory in cmd.

 

Enter:

D: \ mysql-5.7.9-winx64 \ bin> mysqld-install after successful installation, enter: D: \ mysql-5.7.9-winx64 \ bin> mysqld -- initialize to start mysql service: D: \ mysql-5.7.9-winx64 \ bin> net start mysql

7. After starting, do not close the current cmd and directly enter mysql. After Entering mysql, enter the following statement to set the user password:

mysql> update mysql.user set authentication_string=password('newpassword') where user='root';

8. After setting, exit mysql, close the cmd window, open the my. ini file, and comment out skip-grant-tables:

#skip-grant-tables, Save the file, open the cmd window (open as Administrator ),net stop mysqlStop the mysql service and restart the mysql service with net start mysql.

9. In the cmd window, entermysql -u root -p

Enter the password to log on;

10. The logon is successful. Entermysql> SET PASSWORD = PASSWORD('your_new_password');Then enter show databases; to view all databases currently

11. All configurations have been completed.

Summary

The above is a simple tutorial on installing and configuring MySQL 5.7.17 winx64.zip in the decompressed version. I hope it will help you. If you have any questions, please leave a message and I will reply to you in time. Thank you very much for your support for the help House website!