Installation and deployment tutorial of the latest MySQL version 5.7.17 (64bit ZIP green version) under Win 8 or above

First of all, the blogger is playing the community version, which is enough for learning and testing.

Blogger's configuration:

System: Win 8.1 Pro
Database and version: MySQL 5.7.17 64bit
Database management software: Navicat for MySQL

1. Obtaining MySQL and Navicat

MySQL: https://dev.mysql.com/downloads/
Navicat: https://www.navicat.com.cn/download

You need to register an Oracle account to download, so skip the account registration.

Install MSI is the best, automatic deployment, but it is only 32bit

The following is a 64-bit, ZIP green version. This tutorial mainly teaches you how to install MySQL using the green version.

After downloading, it is recommended to use MD5 to compare the integrity

I put the above resources on the network disk (with crack patches) quietly:
Link: https://pan.baidu.com/s/1miI79Bq Password: hk3y

How to use the crack patch:
http://jingyan.baidu.com/article/0aa22375b6cbb988cc0d642d.html

2. System environment deployment

Right click "My Computer" → "Properties" → "Advanced System Settings" → "Environment Variables"

Only process the system variables (red box).

Create a new MYSQL_HOME D:\mysql-5.7.17-winx64 (the location of your mysql)

At this point, the environment variables are configured.

3. Installation of MySQL

3.1. Create a new empty folder named "data"
3.2. Modify the configuration file, or create a new one yourself. For the properties that need to be included, refer to my-default.ini

3.3. Run CMD as an administrator (location C:\Windows\System32\cmd.exe, you can create a shortcut on the desktop)

3.4. Command Input

Finally, enter exit to exit

After the first step, some folders and files will appear in the data folder

4. Introduction to database management software

Navicat is a fast, reliable and very affordable database management tool designed to simplify database management and reduce system management costs. It is designed to meet the needs of database administrators, developers and small and medium-sized enterprises. Navicat is built with an intuitive graphical user interface that allows you to create, organize, access and share information in a secure and easy way.

5. Remote connection method

First, on the host that serves MySQL, change the firewall settings to Advanced Settings → Inbound Rules → New Rules

Then keep going to the next step until you reach the rule name.

5.2. Navicat settings on the host

Use the address and username in the picture above on the other computer.

knock off!

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.