Shulou(Shulou.com)06/01 Report--

Windows system MySQL installation tutorial

download

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

Select Microsoft Windows

Click Download

two。 Click No thanks, just start my download at the bottom of the page. Start downloading

Installation

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

two。 Click Add...

3. Select I accept the license terms

Click Next

4. Select the products to be installed

I chose mysql server 5.7.18-x64 here.

Then click Next

5. Click execute

6. Wait a moment, the installation is complete.

Click Next

7. Click Next

8. Select standalone MYSQL server / classic MYSQL replication

Click Next

9.config type Select Development machine

Click Next

10. Enter the password for Root, twice.

Click Next

11. Check configure MYSQL server as a windows service

Check start the MYSQL server at system startup (it is recommended that you select this option. Since I don't use mysql on windows very often, I cancel this option here. )

Check standard system account

Click Next

twelve。 According to their own needs to decide whether to open the port, I did not open the port.

Click Next

13. Click Execute

14 Click finish

15. Click Cancel to no longer configure MYSQL

Set up

If you need to login remotely, you need to make the following settings

1. Set the specified user to log in remotely

Log in to mysql

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

1. Add firewall rules to open the control panel, click Firewall

Click Advanced Settings

Right-click the inbound rule and click New Rule

Select port, next step

Select TCP and a specific local port, and enter 80JI 3306. Next step

Select allow connection, next step

Select domain, private, public, next step

Give the rule a name, such as: modify 80 and 3306. Click finish

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.