Connecting to remote MySQL from another server

[ipublicis]

I have two servers. A with the MySQL server and B with Application.

In server A I already add the domain app.domain.com has an authorized remote MySQL domain.
I also already created the DB and DB user.

Now I need to set the configuration part on the server B script

Host = ????
DB_User = serverAuser_username
Pass = somethingodd
Database = serverAuser_dbmane

What shall I put on Host (don't want to use an IP)

Thanks in advance.

 

[GOT]

You can point a subdomain to the IP and use that if you prefer, though there really isn't a problem with using just the IP.

Is there a private network between them? Because it would be better for the DB traffic to go over a separate interface.

 

[cPanelLauren]

Hello @ipublicis

There shouldn't be an issue with the hostname, this can be either. The documentation here may also be useful Manage MySQL Profiles - Version 76 Documentation - cPanel Documentation


Thanks!