How can I access my database from my computer?

Cpanel comes with many database access tools, and if your software package uses mysql, it will typically also have some sort of system built into it for managing and reviewing your data.  But suppose you still want to be able to access your database directly, using a program on your own system.  How would you connect?

With your hosting account, you need only to make sure you've added appropriate users to your database, and added your IP address as an allowed host to access your database. 
  1. Find out your IP number on your computer.  Go to http://www.whatismyip.com and it will tell you your IP Number
  2. Open cPanel for your site and click on the Remote MySQL Icon under the Databases Section
  3. Enter the IP number in the box

You will also likely need database connection drivers on the computer you'd lke to connect with..  ODBC is a popular option, however, we as your hosting company do not support installation and configuration of any drivers for your own system.  If you need help configuring database connectivity drivers, please search the web (again, ODBC is a popular option so you can try searching for that), contact the developer of the software you'd like to use with your database, or contact support for your operating system.

Je li Vam ovaj odgovor pomogao?

 Ispiši članak

Također pročitajte

Hotlink Protection - Stop people from borrowing your imagery and bandwidth

  One of the more popular methods of protecting the linking to your images is called "Hotlink...

Creating a MySQL Database using Cpanel

It's actually alot easier than you'd think. From the cpanel main page, click on mysql. Then:1)...

A blue screen flashed while loading cPanel, is something wrong?

If you have been alarmed by a blue screen quickly flashing in your browser when logging into...

Can't access cpanel - How to open a port in Windows Live OneCare

If you are able to access your site, but not Cpanel, chances are that port 2082 is being...

Powered by WHMCompleteSolution