Connect AWS RDS Aurora MySQL from Oracle SQL Developer

Many a times developers who have been using SQL Developer for long time wants to connect MySQL database using Oracle SQL Developer instead of using MySQL Workbench

By default Oracle SQL Developer does not provide MySQL connection type

Download mysql-connector jar, e.g. mysql-connector-java-8.0.19.jar
In SQL Developer, navigate to Tools>Preferences and choose option Database>Third Party JDBC Drivers

Add Entry for the downloaded jar file

Now try creating new connection for MySQL, option for MySQL appears now. If it does not then re-start the Oracle SQL Developer IDE

Create new MySQL connection now and connect

Leave a Reply

Your email address will not be published. Required fields are marked *