Exploring MySQL Database with SQL Explorer Plugin for Eclipse

Home / Exploring MySQL Database with SQL Explorer Plugin for Eclipse

In previous article, we have discuss how to explore SQLite database using third party program, SQLite Manager on Mozilla Firefox. Now let’s cover another DBMS, MySQL.

In this article we will discuss about installation of SQL Explorer plugin for Eclipse. For this purpose I use:

  1. Slackware64 14.0
  2. Eclipse Juno
  3. SQL Explorer 3.6.1

However, unless you are not using Eclipse, the Operating System should give no problem.

Prerequisite

  1. MySQL DB

If you have not installed MySQL, please read related article first. This article will use assumption you have installed MySQL on your system.

Obtain the Material

SQLExplorer can be downloaded from it’s download page

The one we use is the 3.6.1 release, or you can direct download here.

Next is MySQL Connector Java. This will act as connector so the plugin can communicate to MySQL database. Download the connector from it’s download page: http://dev.mysql.com/downloads/connector/j/

At this point we have two package:

  1. sqlexplorer_plugin-3.6.1.zip
  2. mysql-connector-java-5.1.25.tar.gz (or mysql-connector-java-5.1.25.zip if you prefer to)

Installation

Open up terminal and go to your download page (place you have all the materials we need) then invoke these commands:

unzip sqlexplorer_plugin-3.6.1.zip
cp -R features plugin <eclipse path>

Replace the <eclipse path> with your actual eclipse installation path.

Next, we need to install the connector.

tar -xf mysql-connector-java-5.1.25.tar.gz
cd mysql-connector-java-5.1.25
cp mysql-connector-java-5.1.25-bin.jar /usr/share/mysql/

Now open up Eclipse and there should be a new perspective SQL Explorer.

, ,

About Author

about author

xathrya

A man who is obsessed to low level technology.

Leave a Reply

Your email address will not be published. Required fields are marked *

Social media & sharing icons powered by UltimatelySocial