How To Connect MySQL To Oracle SQL Developer

How To Connect MySQL To Oracle SQL Developer

MySQL : Connections in SQL Developer

Downloads:
Setup

Downloads

SQL Developer:
JDBC Driver for MySQL Connector/J
platform independent version

Setup

Download the latest "JDBC Driver for MySQL Connector/J" from here. Click the "Download" link next to the "JDBC Driver for MySQL Connector/J ", then select the platform independent version and download the zip file.

Open SQL Developer and navigate to "Tools -- Preferences --Database --Third Party JDBC Driver".

Click the "OK" button to exit the "Preferences" dialog.

When you create a new connection, you will notice a "MySQL" tab has now appeared. Enter the connection details and test the connection.

Hope this helps.

[nooruddin]

Great man thanks for the excellent help....its work fine for me.

[stepbystep]

hi, while connecting mysql DB using SQLDeveloper i get following error, can you please help me to fix it??


Status : Failure -Test failed: The server time zone value 'PDT' 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.

[MGL]

Except when you install the clinet it doesn't have mysql tab in the new connection window. Only the oracle tab. Getting the tab is the whole trick.