How do you connect to a MySQL database using Oracle SQL Developer?

I have Oracle SQL Developer already installed and am able to connect to and query Oracle databases.

Using Help -> Check for Updates I was able to install the Oracle MySQL Browser extension but there are no connection options for MySQL databases.

Under Tools > Preferences > Databases there is a third party JDBC driver path that must be setup. Once the driver path is setup a separate 'MySQL' tab should appear on the New Connections dialog.

Note: This is the same jdbc connector that is available as a JAR download from the MySQL website.

In fact you should do both :

1. Add driver

   • Download driver https://maven.atlassian.com/content/groups/public/mysql/mysql-connector-java/5.1.29/
   • To add this driver :
   • In Oracle SQL Developper > Tools > Preferences... > Database > Third Party JDBC Drivers > Add Entry...
   • Select previously downloaded mysql connector jar file.

2. Add Oracle SQL developper connector

   • In Oracle SQL Developper > Help > Check for updates > Next
   • Check All > Next
   • Filter on "mysql"
   • Check All > Finish

3. Next time you will add a connection, MySQL new tab is available !

Here's another extremely detailed walkthrough that also shows you the entire process, including what values to put in the connection dialogue after the JDBC driver is installed: http://rpbouman.blogspot.com/2007/01/oracle-sql-developer-11-supports-mysql.html