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:

Comments


  1. This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic.

    Online Reputation Management

    ReplyDelete
  2. Its fantatic explaintion lot of information gather it...nice article....
    seo company in Chennai

    ReplyDelete

Post a Comment