Connecting to remote MySQL from another server

ipublicis

Member
Apr 27, 2018
10
2
3
Lisboa, Portugal
cPanel Access Level
Root Administrator
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

Get Proactive!
PartnerNOC
Apr 8, 2003
1,542
207
343
Chesapeake, VA
cPanel Access Level
DataCenter Provider
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.
 
  • Like
Reactions: cPanelLauren