Friday, September 3, 2010

MySQL with Oracle SQL Developer

Issue

Trying to connect to MySQL database using Oracle's SQL-Developer receiving the
following error message:

Status: Failure -com.mysql.jdbc.Driver
or
Status: Failure -Unable to find driver: com.mysql.jdbc.Driver

Solution

Download mysql JDBC connector from:
http://dev.mysql.com/downloads/connector/j/5.1.html

extract it on your PC and take the following file:
mysql-connector-java-5.1.5-bin.jar

... place it into sqldeveloper\sqldeveloper\extensions

then go to sqldeveloper -> Tools -> Preferences
Database -> Third Party JDBC Drivers
click "Add Entry" and select mysql-connector-java-5.1.5-bin.jar

restart sqldeveloper and you should be able to connect to mysql at this point.





-----Error---------communications link failure last packet sent successfully----



$ sudo vi /etc/mysql/hosts.allow

And add a line:
mysqld : 127.0.0.1 : allow

No comments:

Post a Comment

Followers