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