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.  We've included the how-to steps, directly from Cpanel's manual, below.

1. Enter a server's host name (if you're connecting from another site) or IP address (your IP can be found at http://whatismyip.com')  in the "Host (% wildcard is allowed)" text box.
2. Click on the "Add Host" button.

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.

  • 0 Utenti hanno trovato utile questa risposta
Hai trovato utile questa risposta?

Articoli Correlati

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...

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)...

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...

How can I make my own site backup?

The easiest way to make a website backup is via the Control Panel. When you log into the...

How do I access the Raw Logs from cPanel?

cPanel comes with a number of log analyzing programs such as AWStats and Webalyzer, but suppose...

Powered by WHMCompleteSolution