Today my client was facing problem to setup a remote mysql connection. He wanted to connect a database which belongs to another server and domain. Its fairly simple. But most of the tasks remains on the remote server.
Suppose, your remote domain/server is www.remote.com and your scripts are running in mydomain.com. I assume that you already have a database in the remote.com. We just need to access it from remote server. Also assuming that your database name is remoteco_main. Note, all databases & also usernames (for database connection) in cPanel are prefixed by your username of cPanel and _ (underscore). So remoteco in remoteco_main is the username of cPanel. So you have a complete database, username & password setup which works on remote.com.
- Login to cPanel of remote.com.
- Click Manage Remote MySQL Access
- Enter the IP Address of in the box “Host (% wildcard is allowed):“. It’s the IP address where your mydomain.com is hosted. Usually it is the server shared IP unless you have a dedicated IP address. You can also enter the domain name as Host.
- Click Add Hosts
- Now open your database configuration file in mydomain.com. In normal cases,the host was localhost.That is you may get the code as $dbhost=’localhost’ or $db_host=’localhost’.
- Now you need to replace the term localhost with actual domain or IP address. You enter remote.com or the IP of remote.com as host in the database configuration file.
$dbhost=’22.214.171.124′; //ip of the remote.com. you can also put remote.com here.
$dbname = ‘remoteco_db’; //database name
$dbuser= ‘remoteco_main’; //user name to access database
$dbpass = ‘123456’; //password of the database
Thats it, you should now be able to connect to your remote mysql server.