Windows-Based MySQL dev tools - MySQL Front and MySQL Maestro

[Matt]

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://glowhost.com/tools/your.ip.shtml

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

MySQL Maestro is quite a bit easier to configure.

Click on "register existing database"
Your hostname is yourdomain.com
Username: cpanelusername_databaseuser
Password: your database user's password

Don't forget to add yourself as an access host as we did above or you will not be able to connect.

---------------------------------------------------

Navicat is also quite easy to configure

Connection Name: Something to remember your database by.
Hostname/IP Address: yourdomain.com
Username: cpanelusername_databaseuser
Password: your database user's password

Don't forget to add yourself as an access host as we did above or you will not be able to connect.

========================================
TROUBLESHOOTING
==============

If you cannot connect, there can be several reasons:

1. You did not add yourself as an allowed remote access host in he database manager in your cPanel control panel.

2. You are behind a firewall. Temporarily disable all software and hardware firewalls, and try again. If you can connect this way, re-enable your firewalls and reconfigure them to allow for the mysql port 3306

3. You have typed in your database username or database username's password incorrectly. Double check this in your configuration script.

4. You are trying to connect to "yourdomain.com" instead of your actual domain name. Replace yourdomain.com in the examples above with your real website's domain name.