Using Oracle SQL Developer as MySQL IDE

Need to follow below steps:

- Download desired MySQL connector, unzip and place to desired directory.

- From SQLDeveloper -> Tools -> Preferences -> Databases -> Third party JDBC driver.

  "Add Entry" for desired MySQL connector.

That's It!!!

Now you can observe MySQL tab in the DB Connections SQLDeveloper window.

References:

http://www.techrepublic.com/blog/programming-and-development/configuring-sql-developer-for-mysql/564

Cheers!

message from server: "Host is not allowed to connect to this MySQL server"

Today I came across the problem for remotely connecting to MYSQL database from an application hosted on different machine.

Solution for this issue is to run the following query for granting privileges  to desired user:

GRANT ALL PRIVILEGES ON *.* TO '<USER_NAME>'@'%' IDENTIFIED BY '<PASSWORD>' WITH GRANT OPTION;

Enjoy!!!