• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 413
  • Last Modified:

Connecting Sql Developer to Mysql

Hello Folks,

Can someone give me some instructions on how to connect sql developer to a Mysql?
I have it installed and don't see any option to do so.

I would believe it can connect to Mysql but just not with its current default downloaded setting?

Thanks in advance..
0
Eaddy Barnes
Asked:
Eaddy Barnes
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you mean the oracle sql developer?
you cannot connect that to mysql from what I know, as there is no matching connector...
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
well, let me correct myself ... it looks like that the new mysql j connector can allow it:
http://dev.mysql.com/downloads/connector/j/5.0.html

configuration document:
http://www.oracle.com/technetwork/database/migration/omwb-getstarted-093461.html
0
 
ghieorCommented:
You may try downloading the mysql JDBC connector from http://dev.mysql.com/downloads/connector/j/5.1.html 
then extract it on your PC and take the mysql-connector-java-5.1.5-bin.jar file and place it into the SQL Developer folder usually in sqldeveloper\sqldeveloper\extensions
After this start SQL Developer and click on the Tools:Preferences menu then pull up the Database:Third Party JDBC Drivers. if it's not already present there you can click on the Add Entry button, which brings up a Select Path Entry dialog box. Navigate to wherever you’ve stored the JAR file and select it to load into Preferences.
After this, you should be able to set up connections to MySQL databases.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now