[libreoffice-users] Re: Connecting libreoffice to MySQL/MariaDB via JDBC

Le 27/07/2020 à 09:06, Michael Manning a écrit :

Hi Michael,

> Issues arise when attempting to create a new database within Libreoffice.
> When I test connecting to a database, I get the following error message:
> SQL Status: 08S01
> Communications link failure
> The last packet sent successfully to the server was 0 milliseconds ago. The
> driver has not received any packets from the server.

As Robert has indicated, could you be clearer on what you mean by
"creating a new database within LibreOffice ?"

Are you:
(1) trying to create a new database schema from within a running LO
instance ? As Robert has mentioned, you can't actually do this, the DB
schema needs to be created from the msyql command line or an alternative
GUI tool (such as e.g. phpmyadmin) ;

(2) trying to connect to an existing mysql DB schema, and receiving the
error message you have indicated ?


The error message itself might be slightly misleading, as this is
usually displayed when you can not even connect to the mariadb/mysql
instance.

What does your /etc/mysql/my.cnf or /etc/my.cnf contain next to :

bind-address
and
skip-networking




Alex


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy