The server appears to be running on port 3306 according to this command and result:
$ mysql -u michael -p --port=3306 Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 28 Server version: 10.4.6-MariaDB Source distribution Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. cheers Mike email: michaelgmann...@gmail.com | facebook.com/MikeLouise On Mon, 27 Jul 2020 at 22:33, Michael Manning <michaelgmann...@gmail.com> wrote: > Thank you for your responses. > I am testing using a database with a single table created with the mysql > command line client. This table has 3 fields, an auto-incrementing primary > key, and two fields each defined as varchar(50). The table was defined > using the mysql command line client, and then 3 records were inserted into > the table. I also used the mysql command line client to ensure that I > could retrieve all 3 records using the command: > select * from test1; > > I do not have a /etc/my.cnf file. > > The only line that is not a comment in my /etc/mysql/my.cnf file is: > !includedir /etc/mysql/conf.d/ > > I should also mention that I am using XAMPP for the installation of MySQL > and that this has also installed an apache web server and PHPMyAdmin which > are all working correctly. Should this make any difference to the way that > LibreOffice connects via the JDBC connector? > > PHPMyAdmin reports the server as: > > - Server: Localhost via UNIX socket > - Server type: MariaDB > - Server connection: SSL is not being used [image: Documentation] > <http://localhost/phpmyadmin/doc/html/setup.html#ssl> > - Server version: 10.4.6-MariaDB - Source distribution > - Protocol version: 10 > - User: michael@localhost > - Server charset: cp1252 West European (latin1) > > Is this a hint that sockets are being used and not port 3306 that > LibreOffice is expecting? If so, how should I fix this? > cheers > Mike > email: michaelgmann...@gmail.com > > > > On Mon, 27 Jul 2020 at 18:22, Alexander Thurgood <alex.thurg...@gmail.com> > wrote: > >> 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+unsubscr...@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
