在一台服务器上创建Mysql主机，然后从另一台服务器访问数据库？

Question

我有两个服务器，分别是abc.com和xyz.com。在abc.com上，我创建了一个数据库。我想在xyz.com中访问这个数据库。

我已经在abc.com上创建了远程主机123.123.123.123。但是不知道下一步。

提前感谢

Answer 1

我认为您应该首先阅读cPanel/WHM文档，了解如何为您的cPanel/WHM服务器配置远程mysql服务器：https://documentation.cpanel.net/display/ALD/Remote+MySQL

As a basic guideline the steps would be as follow:
- create a mysql database in a cPanel's user account
- create a mysql username and password for that database
- grant rights to that user for that database
- add the ip address of the mysql remote host you want to use
- check your server firewall and be sure that you grant access to mysql (tcp port 3306) to that ip address;
- from the remote host try doing a **telnet cpanel-server-ip 3306** and see if you can connect