Installation text tutorial for mysql5.7.18 in windows, text for mysql5.7.18

Installation text tutorial for mysql5.7.18 in windows, text for mysql5.7.18

Windows MySQL installation tutorial

Download

1. login https://dev.mysql.com/downloads/installer/

Select Microsoft Windows

Click Download

2. Click No thanks at the bottom of the page and just start my download.

Install

1. Double-click the downloaded file mysql-installer-community-5.7.18.1.msi to start Installation

2. Click Add...

3. Select I accept the license terms

Click Next

4. Select the product to be installed

Here I select mysql server 5.7.18-x64

Click Next.

5. Click execute

6. Wait a moment and the installation is complete.

Click Next

7. click Next.

8. Select standalone MYSQL server/classic MYSQL replication

Click Next

9. Select Development machine for config type.

Click Next

10. Enter the Root password twice.

Click Next

11. Select configure MYSQL server as a windows service

Select start the MYSQL server at system startup (this option is recommended. Because mysql on windows is not frequently used, I will cancel this option here .)

Select standard system account

Click Next

12. Determine whether to open the port based on your needs. I did not open the port.

Click Next

13. Click Execute

14. Click finish.

15. Click Cancel to stop configuring MYSQL.

 

Set

If you need to log on remotely, perform the following settings:

1. Set remote logon for the specified user

Log on to mysql

use mysqlselect host, user from user;update user set host = "%" where user = "root";flush privileges;

1. Add a firewall rule to open the control panel and click Firewall

 

Click Advanced Settings

 

Right-click the inbound rule and click Create rule

 

Select port and next step

Select TCP and a specific local port, enter 80, and next

Select allow connection. Next Step

Select domain, private, and public. Next

Set a name for this rule, for example, modify 80 and 3306. Click Finish

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.