

This is my environment: OS: Ubuntu 18.04.2 LTS

If that is the case, is there a method of specifying schema as the database to connect to? Base includes additional functionality that allows you to create full data-driven applications.

It can access databases created by many database programs, including Microsoft Access, MySQL, Oracle, and PostgreSQL. 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. Base uses the HSQLDB database engine to create database documents. (click) Next → (yes register, open for editing, click) Finish (click) SaveĪfter numerous attempts carefully following the steps the results are the same, all visible databases showing up as tables.Ĭan someone advise me of what is missing or needs to be done? Then I click Next → (I enter username and check Password required and click) Test Connection → (The results is successful). #Steps for Connecting to the Mysql Databaseįrom LibreOffice → File → New → (Database Wizard) → (tick) Connect to an exiting database → (select) MySOL → (click) Next → (tick) Connect directly The tutorials and documentation that I find appears to be clear with these steps: LibreOffice is an office suite of programs including a word processor (Write), a spreadsheet (Calc), a presentation program (Impress) and more. Any attempt to connect to a MySQL database lists all visible databases as tables in the LibreOffice Base configuration. I’m having problems connecting to a single MySQL database.
