Windows2008 firewall How to set port exception, server configuration MySQL how to open remote access

Server cmd Enter mysqlmysql-u root-p input password
Open remote
Grant all privileges on * * to [email protected] '% ' identified by ' password ';
Flush privileges; Then firewall release 3306 Port method/step

2. WINDOWS2008R2 System Firewall in the Control Panel to find (also can be found in the Server Manager)

4. Click to go to the 08 Firewall Settings tab and note the "Advanced Settings" to set

6. , in the upper right of the firewall settings, there is a "create rule"

8. Inbound Rules

   Go to the Rules Wizard page and select the "Port" type

10. This case takes an open webmail custom port For example, select a specific port such as 8008

12. Operation Settings

    Then in the Operation settings, select "Allow connection"

14. Secure Domain Selection

    The next step is to focus on the area of the rule domain that you want to allow to apply to. All options are recommended,

16. Then the name of the rule, which can be arbitrarily named. Add comments, such as XX server XX application

18. Check configuration (the difference between outbound and inbound is the point of the port)

    After setting up, click on the inbound rule to view it. You can see just the configuration settings

20. Outbound Rules

    The outbound rules are set up the same way, notice.  protocol type, with TCP. UDP you can select all and all types

22. Test port

    After setting up the server firewall port, the intranet also needs to set the mapping on the router. Can be tested online by webmaster tools,

Windows2008 firewall How to set port exception, server configuration MySQL how to open remote access