Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer 19 and MySQL?

j4nd3r53nFeb 25 2020 — edited Feb 25 2020

I have SQL Developer Version 19.2.1.247 on Debian Linux, with Java version "13.0.2" 2020-01-14 (I know, not supported, but it seems to work), and JDBC driver installed from mysql-connector-java_8.0.19-1ubuntu18.04_all.deb.

I have connected successfully to mysql (Ver 8.0.19 for Linux on x86_64 (MySQL Community Server - GPL)) and can see the system databases with their tables and an empty test database I created for this purpose. However, when I right-click on 'Tables' under any of the databases, I don't see any options for creating a table. I haven't found any information about whether this simply isn't implemented yet, and one would hope that with MySQL now being an Oracle product, this would work. I can create tables, indexes, triggers etc in the mysql CLI and see them perfectly in SQL Developer, but I can't even select a mysql database and open a worksheet for it, apparently; it almost feels like this is by design. Should I be able to get this to work?

Comments
Post Details
Added on Feb 25 2020
3 comments
238 views