One person can be authorized to use more than one 'user' account, to accommodate a variety of wants.ĭoing the following sets the database up on the server. But the database server keeps a list of 'users', and each user can access one or more databases, with privileges which can be different for different databases. Remember: Databases do not, as such, have passwords.

You do the following once, each time you want to start a new database on the server. When you have all of the elements in place, each time you want to add a database to the MySQL server, and connect to it from within LibreOffice Base, you need to do the following. You can do it! But get it set up and working before you try to access it with a 'Base' front end. I've written elsewhere about MySQL, and how to set up a server. (Also free and multi-platform, I'm glad to say.) But it is a sophisticated system, with lots to recommend it.

Getting that set up may give you a few headaches. Especially if your are just starting with LibreOffice Base.)īefore you can use Base as your front end for interacting with data held on a MySQL server, you need.

but do, please (for your sake) consider setting it up to use the Firebird engine when using an embedded engine. (You don't need to have a MySQL server on your system to use LibreOffice Base. And you don't have to give up continuing the use Base with other databases the 'simple' (embedded engine) way. Getting 'Base' (the database manager supplied as part of the free, multi-platform LibreOffice suite) to work as a front end for a MySQL database server is not hard.

Libreoffice access database