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?
There is no way to grant them permission with cPanel. You can only create user/pass and...
1. First log in to your Cpanel 2. Click MySQL Databases...
We run the latest stable version of MySQL 5.
We have no limit for MySQL connections.
We offer mySQL but no, we do not support MS SQL.
Powered by WHMCompleteSolution