Yes, you can connect to your databases remotely using your cPanel VPS. However, there are a few steps that you will need to perform prior to the remote mysql becoming enabled. However, you will need to do the following steps which are outlined below from within your cPanel hosting account first:
cPanel VPS Account:
- Login to your cPanel on your cPanel VPS
- Click on "Remote MySQL"
- Enter "%" into the top box and click "Add Host"
- That's done!
Once the above is completed within your cPanel hosting account, you will be able to now connect remotely to the MySQL server from your other virtual or dedicated hosting accounts by doing:
Connecting Remotely to your cPanel VPS:
- To connect remotely, you will need a connect string such as:
mysql -h x.x.x.x -u USERNAME -p DATABASE
- Simply replace the "x.x.x.x" with the IP address of your VPS hosting account
- Done!
If you have any further questions, or need any assistance in configuring your remote MySQL connection on your cPanel VPS hosting account, please get in contact with our cPanel VPS support team, and we'll be glad to assist you further.
Remote MySQL is very handy feature. Just got to keep the hosting access strict to avoid some breaches.
Posted by Rodrigo - Wed, Apr 4th, 2012 6:00 PM