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:
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:
mysql -h x.x.x.x -u USERNAME -p DATABASE
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