Ask Your Question
0

How to connect to a single MySQL database via LibreOffice Base

asked 2019-07-24 16:22:29 +0200

apollothethird gravatar image

I'm having problems connecting to a single MySQL database. Any attempt to connect to a MySQL database lists all visible databases as tables in the LibreOffice Base configuration.

The tutorials and documentation that I find appears to be clear with these steps:


Steps for Connecting to the Mysql Database

From LibreOffice -> File -> New -> (Database Wizard) -> (tick) Connect to an exiting database -> (select) MySOL -> (click) Next -> (tick) Connect directly

Then I fill out the form with:

Database Names: test
Server: localhost

Then I click Next -> (I enter username and check Password required and click) Test Connection -> (The results is successful). -> OK

(click) Next -> (yes register, open for editing , click) Finish (click) Save


After numerous attempts carefully following the steps the results are the same, all visible databases showing up as tables.

Can someone advise me of what is missing or needs to be done?

Some research suggests this may have something to do with the way Objects and namespace are handled in recent versions of MySQL A Schema is handled as a database. If that is the case, is there a method of specifying schema as the database to connect to?

This is my environment:

OS:              Ubuntu 18.04.2 LTS
LibreOffiice:    Version: 6.0.7.3
mysql:           Ver 14.14 Distrib 5.7.26, for Linux (x86_64)
MySQL Connector: Built-in - version 1.0.2

-- L. James

-- L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-07-25 08:55:48 +0200

updated 2019-07-25 08:58:49 +0200

I think you have to install the right native MySQL connector which you can find in this page; https://extensions.libreoffice.org/ex...

If my answer helped you, vote it with ✔ (here on the left)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-07-24 16:22:29 +0200

Seen: 43 times

Last updated: Jul 25