Windows system mysql5.7.18 installation graphic tutorial

MySQL installation tutorial for Windows system

download

1. Log in to https://dev.mysql.com/downloads/installer/

Select Microsoft Windows

Click Download

2. Click No thanks, just start my download. at the bottom of the page to start downloading

Install

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

2. Click Add...

3. Select I accept the license terms

Click Next

4. Select the product you want to install

I chose MySQL Server 5.7.18-x64 here

Then click Next

5. Click execute

6. Wait for 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 configuration 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 (It is recommended to select this option. Since I don’t often use MySQL on Windows, I uncheck this option here.)

Select standard system account

Click Next

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

Click Next

13. Click Execute

14Click finish

15. Click Cancel to stop configuring MYSQL

set up

If you need to log in remotely, you need to set up the following

1. Set up remote login for specified users

Login to mysql

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

1. Add firewall rules Open the control panel and click Firewall

Click Advanced Settings

Right-click Inbound Rules and click New Rule

Select the port , next

Select TCP and Specific local ports , enter 80,3306 , and click Next.

Select Allow the connection , and then click Next.

Select Domain, Private, Public , Next

Give this rule a name, such as Modify 80 and 3306 . Click Finish

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.