HOW DO I CONNECT TO MY DATABASE USING A PROGRAM?

If you wish to administer your database from your own computer, via a program like navicat or cocoamysq, you will need to add an "access host" via the MySQL Database Icon in the cPanel.

To do that enter the IP address of the computer with the the SQL software into the access host box.

Also make sure your username matches the username created in the MySQL database section of CPanel, and make sure you add the user to the database you want to access.

Was this answer helpful?

 Print this Article

Also Read

HOW DO I IMPORT A DATABASE (PHPMYADMIN) FROM A .SQL FILE?

1.  First log in to your Cpanel 2.  Click MySQL  Databases...

HOW DO I IMPORT A DATABASE (COMMAND LINE)?

**SSH access is needed for this process. Also you will need the file in .sql format, meaning it...

HOW DO I CREATE AN EMPTY MYSQL DATABASE?

1. First log in to your Cpanel 2. Click MySQL Databases 3. Create a...

HOW DO I CREATE A MYSQL BACK-UP?

1.  First log in to your Cpanel 2.  Click MySQL  Databases...

HOW DO I GRANT PERMISSIONS TO CPANEL FOR MY MYSQL DATABASE ADMINISTRATOR WITHOUT GIVING THEM THE DOMAIN PASSWORD?

There is no way to grant them permission with cPanel. You can only create user/pass and...

Powered by WHMCompleteSolution