Exporting MySQL connection on SQL Developer 4 to 19

3742130

Recently, I have installed SQL Developer v19 on my laptop. I used to connect to MySQL, through a TS, running version 4 of SQL Developer. I have exported the connections through the export connection tool, encrypted the password. However, when I restore these to my laptop, running Java v1.8.0_181, the connections are restored (in a separate connection group, called MySQL) without the details of the DB. Even the port number has been defaulted to the Oracle 1521.

Can anyone help please?

Attached is the screenshot of the MySQL connections after the import.

Gaz in Oz

If you haven't already download and add the mysql java connector which will add "MySQL" to the drop down list. under Connections -> Database Type.

For example:

Tools -> Preferences -> Database -> Third Party JDBC Drivers

Then when you goto Connections, the MySQL database option will be there.

You could try re-importing your mysql connections now and see how you go. If you have no success with the imporrting (sqldev 4 is very behind and old WRT 19...) just re-create them from scratch.

Gaz in Oz

If you haven't already download and add the mysql java connector which will add "MySQL" to the drop down list. under Connections -> Database Type.

For example:

Tools -> Preferences -> Database -> Third Party JDBC Drivers

Then when you goto Connections, the MySQL database option will be there.

You could try re-importing your mysql connections now and see how you go. If you have no success with the imporrting (sqldev 4 is very behind and old WRT 19...) just re-create them from scratch.

3742130

Thanks Gaz in Oz... imports perfectly well, after following your instructions. Wasn't aware about this, since our DBA did needful in that installation, running on a shared folder on that Terminal Server.

Cheers and thanks again.

Ajay