<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN Base Cannot connect to mysql"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134982#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN Base Cannot connect to mysql"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134982">bug 134982</a>
from <span class="vcard"><a class="email" href="mailto:silvain-dupertuis@bluewin.ch" title="Silvain Dupertuis <silvain-dupertuis@bluewin.ch>"> <span class="fn">Silvain Dupertuis</span></a>
</span></b>
<pre>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@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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>