Setting up a Remote MySQL connection in cPanelWritten by Tim Sisson
If you need to connect to your database using third party software that does not run on the server, such as a MySQL client on your desktop a remote MySQL connection can be made. First you will have to allow the connection from within cPanel for the IP address you are connecting from.
What program do I use to connect Remotely?
There are a few programs you can use to connect remotely to your database. HTML editors like DreamWeaver can connect to your databases remotely as well. There are Free Open Source programs you can use like MySQL Workbench or or Heidi SQL. Below are some links to programs you can use to connect to your databases remotely.
Adding an IP address to allow a remote MySQL connection
First, you will need to make sure you have the IP address that will be accessing the database. These rules protect the database by only accepting external connections that you have set up. If you are connecting to a database from your current connection, you can obtain your current IP address by visiting this link: current IP address. Once you have the IP address that you wish to connect remotely, log into cPanel and click on "Remote MySQL" under the Databases Heading.
Now, since you have added the IP address to remote MySQL connections you will be able to connect to the databases. You can add as many IP addresses as you need.
Using a Wildcard to allow all IP's
You may find you need to use a wildcard if your IP address changes regularly. You can add a wildcard by using the % symbol. This will add all IP addresses in that range.
If you want to list all IP addresses in the range 220.127.116.11 to 18.104.22.168 you'd add the IP address 174.77.92.%.
If you need further assistance with connecting to a database remotely please contact our support department.
- How to determine IP's
- i want to create a report in moodle 2.5 that has field like name , coasre name, marks obtained , prcentage, grade and also want download from moodle in excel format plese reply me procedure thks in advance
- i want ocreate a costom report that has field name , coarse ,marks , percentage