Access MySQL in one cPanel from another Server cPanel

[bealefay]

Hello
I have two cPanel and i have the application files in one cPanel and MySQL in another cPanel. I want to store data into second cPanel.

1. I have created the Remote MySQL in 2nd cPanel with IP Address of First cPanel.
2. In 1st cPanel i have given host as 2nd cPanel host and 2nd cpanel's Database username, password.

The problem is i cannot coonect to mySQL database. I am using PHP Application
Any ideas ?

 

[cPanelLauren]

In order to allow this you'd need to have a Remote MySQL host Profile added - the following goes over this:

Additional MySQL Access Hosts | cPanel & WHM Documentation

This interface allows you to permit remote hosts (servers) to access MySQL® databases on your server, or to access a remote MySQL server that you configured via WHM's Manage MySQL Profiles interface.

docs.cpanel.net

Through cPanel the following should be helpful as well:

Remote MySQL® | cPanel & WHM Documentation

This feature allows remote hosts (servers) to access MySQL® databases on your account.

docs.cpanel.net

Troubleshoot MySQL® Profiles | cPanel & WHM Documentation

This document describes additional steps to follow if you experience problems when you attempt to connect to your remote MySQL® server.

docs.cpanel.net