There are two methods to connect to a MySQL/MariaDB database using JDBC. One method works perfectly. The other method appears to work, in that you can edit your tables, but it does not allow editing relationships, and furthermore linked sub-forms don’t work as expected.
So when setting up your connected database do not choose JDBC directly, rather first choose MySQL, then in the next screen choose JDBC and proceed from there.
I have a more complete answer to document this here.
ODBC is broken with a known bug and has to my knowledge not yet been fixed.
Also I noticed that after upgrading to LO 22.214.171.124, the native MySQL connector option is gone.
And unlike MS Access the relationship editor when used w/ MySQL/MariaDB only appears to work with InnoDB database engine databases (i.e. it won’t work with ISAM databases.) In other words it does not allow table-to-table relationships to be set up unless there is underlying relationship support in the database engine. The reason one might want to connect to and use ISAM is because it is much faster than InnoDB, like for example if you are using it under a web site, and trying to use LO as a development front end.