Configure SQuirreL with MySQL

SQuirreL is great because is universal and platform independent. You can use it to connect to almost every database that you can imagine.
The only drawback is that it doesn't ship with the database drivers due to licensing issues.

So here is a step-by-step procedure for connecting to MySQL from SQuirreL.

First of all verify that you have network access to the mysql host and its port. Usually mysql servers run at port 3306, so test the connection from your host:
telnet 3306

If you get something like:
telnet: Unable to connect to remote host: Connection refused

then you won't be able to connect.

The correct response you should get is something like:
Connected to

Then you must check that the database user you will be using has access from the host that the squirrel client will run.

You can check the privileges using phpmyadmin, or by command line:
GRANT USAGE ON *.* TO 'user'@'hostname'

Now go to SQuirrel's website, download and install it.

When you run the program you will see on your left pane a list of database drivers. Most of them are not installed, so we have to manually install the drivers we use often, eg MySQL, Oracle, Sybase etc.

Now, download the platform independent mysql jdbc driver from

Unzip/untar the downloaded file. In the uncompressed folder you should see a file named mysql-connector-java-X.X.XX-bin.jar. Place this file file into the lib subfolder under SQuirreL's install folder.

This is the mysql jdbc driver.
We are now ready to install the mysql jdbc driver.
Scroll down to the MySQL driver, double-click it and set the Extra Class Path as illustreted below:

Press OK, if everything is fine, then you will see the following screen:

Now you can create your connection(s) to any mysql database(s) by using the aliases tab:

Use the "Test" button to test your connection
Hopefully the connection should be created successfully...

Have fun with your queries!


  1. Thanks a lot for the tutorial, I was stuck with connecting but your tutorial helped me a lot.

  2. Thank you very much for the tutorial, it worked fine :D

  3. Thanks so much for your clear tutorial! The official site certainly lacks a lot of this documentation.

  4. You can check free tool Valentina Studio which I think is far superior to other GUI tools.

  5. Thank you so much for this tutorial.
    It is a helpful post.

  6. Great tutorial. I should note that when attempting this with hostgator I could never get telnet to work, but it worked fine when connecting through squirrel. I used my cpanel username and password, and I used the ip address that it showed me inside cpanel on the left column towards the bottom.

  7. An important catch: for SQuirreL to be able to load the driver/connector you need to place its .jar file into the lib subfolder under SQuirreL's install folder.

  8. Thanks for taking the time to write the tutorial!

  9. Thank you!

    How did you know to add jdbc:mysql:// and then the port number at the end (:3306) of the URL?

  10. This is ansuperior writing service point that doesn't always sink in within the context of the classroom. In the first superior writing service paragraph you either hook the reader's interest or lose it. Of course your teacher, who's getting paid to teach you how to write an good essay, 
    python Training institute in Pune
    python Training institute in Chennai
    python Training institute in Bangalore

  11. This comment has been removed by the author.

  12. This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.. 
    Best Devops online Training
    Online DevOps Certification Course - Gangboard

  13. This is quite educational arrange. It has famous breeding about what I rarity to vouch. Colossal proverb.
    This trumpet is a famous tone to nab to troths. Congratulations on a career well achieved. This arrange is synchronous s informative impolites festivity to pity. I appreciated what you ok extremely here 

    Selenium training in bangalore
    Selenium training in Chennai
    Selenium training in Bangalore
    Selenium training in Pune
    Selenium Online training