LibreOffice Base is similar to Microsoft Access but it is free (open source). LibreOffice Base actually not a database by it self - the default database for LibreOffice base is HSQLDB. LibreOffice Base also can used front-end database like MySQL, Access Database etc.
If we use LibreOffice default base HSQLDB, only one person can using the database at one time. So, if we want to make a multiple user - we can use MySQL for example as a front-end.
Note:
LibreOffice Base actually one of the products LibreOffice. There are another products in LibreOffice such as Writer Document, Calc Spreadsheet, Impress Presentation, Draw Drawing, Math Formula. But in this article, we only discuss about the LibreOffice Base.
Steps:-
- Download LibreOffice: https://www.libreoffice.org/download/download/
- Install LibreOffice base as usual
- Download MySQL (MySQL Community Server): https://dev.mysql.com/downloads/mysql/
- Install MySQL as usual: See this youtube as guideline how to isntall: https://www.youtube.com/watch?v=BdF7HUmuU-s&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=80
Choosing a Setup Type
Setup Type | Description |
Developer Default Install all products need for MySQL development purpose |
Installs the MySQL Server and the tools required for MySQL application development. This is useful if you intend to develop applications for an existing server. This Setup Type includes: * MySQL Server * MySQL Shell * MySQL Router * MySQL Workbench * MySQL for Excel * MySQL for Visual Studio * MySQL Connectors * Examples and tutorials * Documentation |
Server only Install only the MySQL Server product |
Installs only the MySQL Server. This type should be used where you want to deploy a MySQL Server, but will not be developing MySQL applications. |
Client Only Install only the MySQL Client produts, without a server |
Installs the tools required for MySQL application development, but does not include the MySQL Server itself. This is useful if you intend to develop applications for an existing server. This Setup Type includes: * MySQL Shell * MySQL Router * MySQL Workbench * MySQL Visual Studio Plugin * MySQL Connectors * Examples and tutorials * Documentation |
Full Install all included MySQL products and features |
Installs all of the products available in this catalog including MySQL Server, MySQL Shell, MySQL Router, MySQL Workbench, MySQL Connectors, documentation, samples and examples and much more. |
Custom Manually select the products that should be installed on the system |
Installs all of the products available in this catalog including MySQL Server, MySQL Shell, MySQL Router, MySQL Workbench, MySQL Connectors, documentation, samples and examples and much more. |
To connect MySQL server, the are 3 type:
- Connect with ODBC
- Connect with JDBC
- Direct
To connect with ODBC - we need JRE. The problem is, (JRE) Version 8 Update 201 was the last free JRE. Starting from JRE Version 8 Update 211 commercial users will be required to pay for its usage to Oracle.
To solve this problem (no need to pay - is by using free open source alternative). So we can use the OpenJDK. Download here: https://adoptopenjdk.net/. See this article: http://www.bluechip-india.com/no-brainer-alternative-to-oracle-java-runtime-jre/ and also see this youtube for installation: https://youtu.be/WewvpxrjXro
How to configure java on windoew 10:
To connect with JDBC - we need Connector J. Download here (Community version): https://dev.mysql.com/downloads/connector/j/. See this youtube for setting: https://youtu.be/aP5wXmnWxGE
- Log in to post comments