[Python-modules-team] Bug#848287: python-testing.mysqld: (build-)depends on mysql-{client, server}

[Dominik George]

Hi,

I was able to identify the issue, but need help fixing it.

The problem is that the testing module uses the default root user of the
newly created database, and it uses the UNIX socket, and that has
peercred authentication by default in MariaDB.

I tried the following to disable peercred for the socket:

$ cat >init.sql
USE mysql;
UPDATE user SET plugin='' WHERE User='root';
FLUSH PRIVILEGES;

$ mysqld … --initialize-insecure --init-file=init.sql

But it still does not allow connecting a non-root user as root through
the UNIX socket.

Any help appreciated.

-nik

-- 
PGP-Fingerprint: 3C9D 54A4 7575 C026 FB17  FD26 B79A 3C16 A0C4 F296

Dominik George · Hundeshagenstr. 26 · 53225 Bonn
Mobile: +49-1520-1981389 · https://www.dominik-george.de/

Teckids e.V. · FrOSCon e.V.
Fellowship of the FSFE · Piratenpartei Deutschland
Opencaching Deutschland e.V. · Debian Maintainer

LPIC-3 Linux Enterprise Professional (Security)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 902 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/python-modules-team/attachments/20170101/42d916e5/attachment.sig>