1

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 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. But does it?

  • 1
    @Vérace Yes, that works fine - I can see my tables and everything else, if they already exist. – j4nd3r53n Feb 24 at 15:35
  • 1
    @MichaelKutz No - the problem seems to be that I can't actually select a database. At least, if the database is empty, then I get an error: 'No database selected', whereas if there are tables, nothing seems to happen at all. – j4nd3r53n Feb 24 at 15:37
  • 1
    @WilsonHauck I know, but thank you for commenting. I know how to do things in mysql, but I can't get SQL Developer to work as expected. – j4nd3r53n Feb 25 at 8:28
  • 1
    @WilsonHauck Oracle SQL Developer - sorry, I didn't know there was a MySQL Developer – j4nd3r53n Feb 25 at 12:56
  • 1
    MySQL Workbench (free) might be a better tool than Oracle SQL Developer to work with your MySQL database. There likely is NO MySQL Developer tool (free). – Wilson Hauck Feb 25 at 14:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.