How do you connect to a MySQL database using Oracle SQL Developer?
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 :
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.
Add Oracle SQL developper connector
- In Oracle SQL Developper > Help > Check for updates > Next
- Check All > Next
- Filter on "mysql"
- Check All > Finish
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