Using Oracle SQL Developer with MySQL

Posted on July 15, 2011 by Paul McGarrick
Filed Under MySQL, SQL Developer

A few months back I blogged about using Oracle’s excellent SQL Developer tool with Microsoft SQL Server databases. In a similar way you can also connect to MySQL – here’s how…

You will need to download the most recent version of Connector/J from the MySQL website. This is the official JDBC driver for MySQL, made available under the GPL.

Once you have the driver unarchived, move the .jar file somewhere permanent. I like to put all my third party JDBC drivers together in the SQL Developer root directory.

Next go to Tools > Preferences > Database > Third Party JDBC Drivers. click Add Entry and browse to the jar file.

You should now find a new tab has appeared when you next create a new database connection.

Simple eh?

Comments

One Response to “Using Oracle SQL Developer with MySQL”

  1. John on August 9th, 2012 1:13 pm

    Thanks for the tip, Paul!

Leave a Reply