Home
> Debian, Java, LibreOffice, LinuxMint, MySQL, Ubuntu > Connect to MySQL database from LibreOffice Base
Connect to MySQL database from LibreOffice Base
LibreOffice’s Base program can provide a quick easy way to access a MySQL database and write some reports against data. The following outlines how to easily setup LibreOffice Base to connect to MySQL. It assumes that you already have LibreOffice Base installed. It works just as easily for OpenOffice Base.First we need to install the JDBC driver for MySQL
sudo apt-get install libmysql-java
Next
- Open up any LibreOffice program and then click on Tools->Options.
- Expand LibreOffice option and then click on Java.
- Click on the Class Path button on the right followed by Add Archive.
- Browse to /usr/share/java/mysql-connector-java.jar
- Click Ok and choose to restart LibreOffice.
- Now open LibreOffice Base and choose to Connect to an existing database.
- In the drop-down menu choose MySQL, and connect using JDBC.
- Click on the Test class button to make sure the JDBC driver loads successfully. If it doesn’t, then check that you followed the previous steps properly. If it does load then simply enter the settings as it relates to your MySQL database.
- If you get the JDBC driver to load properly, but you cannot connect to your MySQL database,
- then I would recommend installing the mysql client and making sure you can connect from the MySQL client first.
- If the JDBC driver loads properly, and you can connect to your database with the MySQL database, then you should not have any problem connecting with LibreOffice.
Note : This Tutorial Article is tested on Debian family OSs.
Ref : http://maxolasersquad.blogspot.com/2011/03/connect-to-mysql-database-from.html
after your step 7 there should be a step 7A. when selecting the info of ‘Connection to a MySQL db using JDBC’ entering the Database name – enter it, Server – MUST BE ‘LOCALHOST’ Port number – 3306, then do your number 8 of ‘Test class’.
also the date accepted by LibreBase is NOT 000-00-00 format. It will NOT accept this format.
Connect to Access Database using Java
http://javasrilankansupport.blogspot.com/2012/02/connect-to-access-database-using-java.html
Hi,
I have read this document but, after performing steps 7 and 7A , data source is not able to establised connection and encountered an error of “failed connection to the data source” along with “access denied for user ‘root’ @’localhost’ (using password:YES)”.
I have also installed mysql client, by using “sudo apt-get install mysql-client” command, but don’t know how to connect to mysql client.
Thank you for help in advance!
where do you enter the user name and password for the MySQL Database?
Excellent way of describing, and nice post to obtain information about my presentation subject matter, which i am going to deliver in
school.
Good! I have an issue: on mac where I can find the right path to place the mysql connector?