Hi everyone,
I am very new to LibreOffice Base, and still rather new to MySQL and databases in general, so patience is welcome.
I built a database on a webserver that I currently accessing with Workbench via SSH. All of that works rather well, but I would like to create forms and reports, which I believe Workbench doesn’t do much of.
I started using Base, but every time I open a table, the programme crashes. Here are the steps I took.
- Launch Base
- In the Database Wizard, select “connect to an existing database” and choose “MySQL/MariaDB”
- Select "Connect directly (using MariaDB connector)
- Enter the name of the database (as indicated in Workbench), the IP of my VPS and 3306 as port (which is correct)
- Enter the user_name to connect to mysql (which is also used by Workbench) and check “password required”
- Click on “test connection”, enter the password, and see the message “the connection was established successfully”
- In the last wizard screen, select “yes, register the database for me” and “open the database for editing”, click on “finish”
- Give a name to the ODF database and save
- Base opens and I can successfully see all my tables
So far, so good. But then…
- Double-click on any table
- Base crashes
Base tells me the connection is successful and I do see the list of all tables. Beyond this, is there any possibility that this is not a bug from Base but a connection issue, somehow? I guess I am trying to figure out whether this is someone on my end (whether connection or anything) or an issue with the software itself.
Thanks in advance!
Mark
LibreOffice version 26.2.0.0.beta1(build: 1ff380402efe713308d6f0e5c815a6e3a1b3b67c)
macOs 14.8.4 (no update to macOS 15 possible)