[Libreoffice-bugs] [Bug 134982] FILEOPEN Base Cannot connect to mysql

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134982

--- Comment #3 from Silvain Dupertuis <silvain-dupertuis at bluewin.ch> ---
Thanks for answering!
I hope you can help me find out why I can't connect.

Here are the details on my situation:

I am trying to access the local mysql instance on my local computer, not on a
LAN nor a remote server on the internet.
Using 127.0.0.1 in Base returns the same error (111) as using localhost.
Using mysql socket (/opt/lampp/var/mysql/mysql.sock) instead of server/port
returns the same error (111)

I do not understand what to configure in my.cfg file, as I can access my mysql
server
- using my  browser (using url localhost or 127.0.0.1)
- using mysql from the command line

I mentionned MariaDB because I am usig a XAMPP server, and it uses mariadb
On the command line, I just call it "mysql"

phpmyadmin indicates the following:
- Server : Localhost via UNIX socket
- Type of server :  MariaDB
- Version of server : 10.1.37-MariaDB
- Utilisateur : root at localhost

Also, I do not understad why it stopped working at a certain point
As far as I remember, I have been using xampp for a number of years.

As for the my.cfg file, the [mysqld] part indicates :
# The MySQL server
[mysqld]
user = mysql
port=3306
socket = /opt/lampp/var/mysql/mysql.sock
skip-external-locking

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200721/6886e2cf/attachment.htm>