Configure Squirrel SQL to connect to MySQL

"Squirrel SQL" is a great light weight generic SQL client that I have started using for more than 10 years now. As Java based it can be used from Windows, Linux, Mac OS as well

This is how to configure Squirrel SQL 3.6 on Windows 8.1 to connect to MySQL server ver 5.6 running on CentOS 7.

Steps:
1- Download MySQL Connector/J ver 5.1.34 & extract to any local folder C:\oracle\mysql\mysql-connector-java-5.1.34
2- You will find MySQL Driver in the drivers with red x mark as indicator that MySQL driver is not  defined.
3- Double click "MySQL Driver".

4- Click "Extra Class Path" tab.
5- Click "Add" and select jar file from %MYSQL_JAVA_CONNECTOR%\mysql-connector-java-5.1.34-bin.jar
6- Click Ok, and we are done defining the driver.
7- Now create an alias for the DB.

Your driver dialog should look like:

No comments:

Post a Comment