Ask Your Question

How to change JDBC mysql to direct mysql connect in Base

asked 2019-09-05 04:51:49 +0200

zanjibar gravatar image

LibreOffice 6.3 could connect MySQL directory. My Old base document connect MySQL database via JDBC driver. So I wanna change JDBC mysql driver to direct connection. How to change JDBC mysql to direct mysql connect in Base?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-09-05 06:03:06 +0200

Ratslinger gravatar image

updated 2019-09-05 06:31:01 +0200


Normally you would do this from the menu Edit->Database->Connection Type... and select the connection from the dropdown.

Seems this cannot be accomplished in 6.3.x and can't say when the problem started.

It appears this is now a bug and you should report on Bugzilla.

Dropped MySQL when the Native connector changed but have on another system (simply for Ask testing) and now it appears you can only change to MySQL(JDBC) from another connector - any connector. So the only method (aside from loading an older LO version) to create a direct connection for MySQL is to create a new Base file. there you can select ODBC, JDBC or Native.

On Ubuntu 18.04, just reloaded LO v6.1.4.2 at random and the dropdown has options for ODBC, JDBC and Native(loaded via extension).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-09-05 04:51:49 +0200

Seen: 23 times

Last updated: Sep 05