Some of you may wish to use tools like MySQL Front and MySQL Maestro to access your cPanel databases from your desktop instead of using PHPMyAdmin which comes preinstalled on your site with the latest stable version, and is constantly updated for those of you who did not know we had it in there for you.
Here is how to set them up:
First go to this page and get your IP address:
http
https://glowhost.com/tools/your.ip.shtmlweb-hosting-technical-support/what-is-my-ip.html
Put that on your clipboard and login to your cPanel > MySQL and all the way at the bottom is a part for remote access hosts. Put your IP in there. If you get a new IP every time you log on to the Internet from your ISP then you may wish to put a % sign at the end of your IP which will act as wildcards allowing access from 0-255. So for example:
123.456.789.% or 123.456.%.% but be warned you are now allowing remote access to your databases from lots of people! it were mine I would not allow any access hosts but my own IP if I had to use one of these tools to connect, then remove it after I was done with the session for the most secure way to do it remotely.
For MySQL Front:
1. On the General Tab it will ask for Login Information, with one text box. That is your cPanel username.
2. On the connection tab it will ask for:
Server
Port
Connection type
Timeout
Compression
You can keep all the defaults. The only thing it asks for is the Server. Type in yourdomain.com (not http://yourdomain.com)
3. Next is the Login tab. It asks for:
User
Password
database
So, assuming you are familiar with how to set your databases up in cPanel, then it would look something like this:
User: cpanelusername_databaseusername
Password: your database user's password
Database: cpanelusername_databasename
4. The cache tab does not need anything messed with.
...