Configure SQL Developer with MySQL

Configure SQL Developer with MySQL

Do you know that we can use SQL Developer to connect to non-Oracle databases like MySQL too.

As a result this makes SQL developer a handy tool to use it as a multi-database GUI – meaning you can have a UI which is open against different database vendors.

Configure SQL Developer for MySQL

Below are steps to configure SQL Developer with MySQL.

Configure SQL Developer for MySQL

Go to Tools –> Preferences 

Configure SQL Developer for MySQL

Expand Database and click on Third Party JDBC Driver

Configure SQL Developer for MySQL

 

Add Entry and select

C:\Stixs\ mysql-connector-java-5.1.15-bin.jar  (the path where the MySQL connector jar is present)

4

Now in the SQL developer editor, open New Connection

5

In New / Select Database Connection window, you will find MySql tab where you can provide MySql database details to connect to.

 

 

6

Enter the Following details on selecting the MySQL tab.

  1. Connection Name
  2. Username
  3. Password
  4. Hostname
  5. Port
  6. Click on the Test button
  7. If the connection is established then we see Status: Success

Note:  Below snapshot gives more details about the above numbering.

7

Now you can set up connections to Oracle and MySQL databases in the same SQL Developer GUI. It’s that simple!!!

Thanks for reading the blog.

——————————————————————————–

You may also like this

——————————————————————————–

About TechnoStixs.com

Oracle ATG Commerce modules and its components

TechnoStixs.com is a dedicated weblog for Java/J2EE and web developers. We take pride in our work. Every publication is carefully analyzed, written and tested to ease the understanding of the topic or subject.

We cover Java Core Technologies, eCommerce, J2EE Frameworks, Web Service, Build Tools, Unit Test Frameworks and Others.

1,433 total views, 1 views today

Add comment