Skip to content
Home » MySQL » SQL Developer for MySQL

SQL Developer for MySQL

How do I enable MySQL in SQL Developer?

By default, SQL developer can be used to connect only Oracle databases.

SQL Developer - Default Connection Option - Only Oracle Database
SQL Developer - Default Connection Option - Only Oracle Database

As you can see, there's only Oracle tab in the connection option. Luckily, SQL developer provides a very special feature that can import the third party JDBC driver into SQL developer. So that we can connect the third party databases other than Oracle's via this driver.

The question is, how do I enable MySQL in SQL Developer? To connect MySQL databases from Oracle SQL Developer, we take the following steps to make SQL developer connect MySQL:

  1. Download MySQL JDBC driver from mysql.com.
  2. Open preference dialog in Tools's menu.
  3. Find "Third Party JDBC Driver".
  4. Add an Entry for MySQL JDBC driver.
  5. Check MySQL connections.

Download MySQL JDBC Driver

Before we import MySQL JDBC driver into SQL developer, we need to download it. Please go to MySQL :: Download Connector/J and look for a proper connector to download.

In the download page, please select Platform independent for your windows platform.

Please note that, in the compressed file, only one JAR file is useful. In my case, the file is called mysql-connector-java-8.0.14.jar. And I put it at the conventional path of JDBC library.

SQL Developer - jdbc - lib Content
SQL Developer - jdbc - lib Content

Open Preference Dialog

Click on "Preference" function on "Tools" menu to open the dialog.

SQL Developer - Tools Menu
SQL Developer - Tools Menu

Find "Third Party JDBC Driver"

Expand "Database" and click on "Third Party JDBC Driver" in the preference dialog, then click Add Entry.

SQL Developer - Preference - Database - Third Party JDBC
SQL Developer - Preference - Database - Third Party JDBC

Add an Entry for MySQL JDBC Driver

Select on our new driver file in the file selector to add the new JDBC driver.

SQL Developer - Preference - Database - Third Party JDBC - Select Path Entry
SQL Developer - Preference - Database - Third Party JDBC - Select Path Entry

Now SQL developer has imported MySQL JDBC driver.

SQL Developer - Preference - Database - Third Party JDBC - MySQL Driver Added
SQL Developer - Preference - Database - Third Party JDBC - MySQL Driver Added

Check MySQL Connections

Now, let's check the connection options again.

SQL Developer - Connection Options - MySQL Tab
SQL Developer - Connection Options - MySQL Tab

As we can see, there's a new MySQL tab that offers capability to connect MySQL databases. If the new tab didn't show up as expected, you may reopen SQL developer to make it available.

Now we can test the functionality of this MySQL JDBC driver by providing database information and credentials, then click Test.

SQL Developer - MySQL Connection Test - Status: Success
SQL Developer - MySQL Connection Test - Status: Success

The test is successful. Which means the new driver is working now.

16 thoughts on “SQL Developer for MySQL”

  1. I got an error when i click “Test”:
    Status : Failure -The server time zone value ‘WIB’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

  2. Hi, any instructions for DBLINK? I can query the MySQL server on a remote machine thru SqlDeveloper your instructions are spot on.
    I have an oracle database server with the same dataset and trying to compare the 2 databases and see where my differences are in some tables. I can do this Oracle to oracle with DBLINK. I can create the DBLINK to MySQl byt my Query says NO TNS LISTENER. I am assuming that I need to setup ODBC connection for DBLINK to MySql but having a hard time finding instructions.
    Thanks in advance!

Leave a Reply

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