[Libreoffice-bugs] [Bug 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04

[bugzilla-daemon at bugs.documentfoundation.org]

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

Alex Thurgood <iplaw67 at tuta.io> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTOURBUG
             Status|NEEDINFO                    |RESOLVED

--- Comment #24 from Alex Thurgood <iplaw67 at tuta.io> ---
(In reply to Robert Großkopf from comment #22)


> And with phpmyadmin you could see in "users" the user root (root is the same
> as root of the system!) is connected to localhost?

@Robert, forget it, Linux Mint uses the DEB packages provided by Ubuntu, and
these are currently configured by default to only allow mysql/mariadb root
account access from a process that is already running as root using a unix
socket authentication plugin. This is a security "feature" of the DEB packages
provided by those distros.

https://stackoverflow.com/questions/30815971/mariadb-installed-without-password-prompt/34674254#34674254


I am closing this report as NOTOURBUG.

Both Sylvain and Duns need to learn to configure their mariadb/mysql server
with the relevant authentication plugin for each user and assign them a
corresponding password, and then try and connect from LO with a supported
password authentication mechanism before filing a report here.

This bugzilla isn't the place for general exchanges on configuring
mysql/mariab, and only muddles any real issue that might be present.

-- 
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/20200914/fca748c2/attachment.htm>