Connecting to remote MySQL from another server

ipublicis

• December 27, 2018 19:39

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

  • December 28, 2018 12:26

  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.

  0
• 

  cPanelLauren

  • December 28, 2018 19:16

  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!

  0

Please sign in to leave a comment.