How to enable mysql remote connection in the wdcp background

Source: Internet
Author: User
You can set N users to access the corresponding database in the mysql database, N addresses to access the corresponding users, or N databases, generally, the local connection of N addresses is localhost or 127.0.0.1. by default, remote access or connection is not enabled, but it is special... you can set N user access and N address access for the corresponding database in the mysql database.
You can also set up to access N databases and connect to N addresses.

Generally, localhost or 127.0.0.1 is used locally.
For security, remote access or connection is disabled by default.

However, some special applications or requirements require remote connection. The following describes how to set up wdcp in the background:
1. log on to the background
2. mysql management
3. create a database user, as shown in figure


Replace the username, password, IP address, and database with what you want.

Note: the IP address in the host name is set according to your actual situation, that is, the remote IP address you need to connect to. if you are using a local connection, it is the IP address of your local internet access.

If the connection is not available after it is added, check whether the firewall (iptables) has enabled access to port 3306.

This document is excerpted from http://www.wdlinux.cn!
Related Article

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.