How do I Access Remote Mysql Database from Dedicated Server ?
First you must allow the ip in the firewall. To do this,
- Please login to your WHM as root
- Click on ConfigServer Security&Firewall under Plugins Category
- Supply the IP of your remote desktop [ You can get it my visiting www.getmyip.co.in in the browser of the desktop ] in the green text box agains “Quick Allow” button
- Click on Quick Allow button
Then login to the cpanel of the domain where the mysql database is created.
- Under Databases click on Remote Mysql
- Supply the ip address of your remote desktop which you have got above and click on Add Host button