Results 1 to 1 of 1

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

  1. #1
    Matt's Avatar
    Matt is offline GlowHost Administrator
    Join Date
    Jan 2005
    Location
    Behind your monitor
    Posts
    5,264

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

    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.
    Last edited by Matt; 08-04-2005 at 05:21 PM.
    Send your friends and site visitors to GlowHost and get $125 plus bonus!
    GlowHost Affiliate Program | Read our Blog | GlowHost's Facebook | Follow us on Twitter | GlowHost on Google+

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16