Nov 10, 2018

How to connect to MySQL from LibreOffice Base

When you open LibreOffice Base you get the "Database Wizard" and you have three options:

  • Create a new database (Creates a new odb database)
  • Open an existing database file (Opens an existing odb database)
  • Connect to an existing database (Will show a default connection)

Select "Connect to an existing database" and if you have the MySQL connector installed you select MySQL from the connectors, click Next

Select "Connect directly", click Next

At the next Dialog box select "Server/Port" enter in Database Name for your database (for example "Work" if you have database named "Work"), the Server (the url for the server or if on your computer "localhost"), the port defaults to 3306 and unless you changed the port, the port number is correct.

Click on Next.

On the next Dialog box enter the username. Click "Password required" if you need to enter a password. To verify the username & password click test connection and enter your password. If all is correct you should get a message:
"The connection was tested successfully" 
Click OK then Click Next.

On the next Dialog box you can either accept the defaults or change them then Click Finish. You should now see your MySQL database in Base.