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

Source: Internet
Author: User
Tags configuration settings

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
  1. WINDOWS2008R2 System Firewall in the Control Panel to find (also can be found in the Server Manager)

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

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

  4. Inbound Rules

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

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

  6. Operation Settings

    Then in the Operation settings, select "Allow connection"

  7. 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,

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

  9. 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

  10. Outbound Rules

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

  11. 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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.