How to enable mysql remote connection in the wdcp background

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!