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. 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. The free licensing agreement supports any number of computers and users. 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 is part of the open source LibreOffice suite and is a credible alternative to the many commercial databases available.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |