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,740
300
363
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

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,304
1,250
313
Houston