December 9, 2015 | Article | No Comments
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:
- Slackware64 14.0
- Eclipse Juno
- SQL Explorer 3.6.1
However, unless you are not using Eclipse, the Operating System should give no problem.
- 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
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:
- mysql-connector-java-5.1.25.tar.gz (or mysql-connector-java-5.1.25.zip if you prefer to)
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.