I ended up re-installing Mysql and potentially lost all my data since the last and infrequent backup - lesson learned. Do a Mysql backup data dump first, so you don't lose data if things go wrong.

WARNING When playing with Users and priviledges, be careful you don't lock yourself out. I no longer see all my other schema that I have in mysql, so a partial success. Information_schema from appearing, but as schema are listed alphabetically, bookings takes preferenc at top of the table list, so I can live with it. Then when I view the tables in bookings.odb, I only see the bookings schema and the information_schema. Then when I open 'bookings.odb', I need to sign in with user 'bookings' for the schema restrictions to be applied Then in 'Users and Privileges', I assigned schema priviledge to the bookings schema only. Using Mysql Workbench, I created a user called bookings. 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). I have an LO database called 'bookings.odb', which only needs access to the bookings schema in Mysql. Then rerstricting these users to the specific schema they need access to. I have had partial succes by assigning different users for each of my odb databases. Firstly may I point out that in essence, the terms database and schema are synonymous within Mysql, so where LO refers to database, you may take it that it when using Mysql, it actually refers to Mysql schema!

Libreoffice base mysql connector