[debian-mysql] Bug#865931: mysql-server: Does not allow me to change root password

[Antonio Ospite]

Package: mariadb-server-10.1
Followup-For: Bug #865931

Dear Maintainer,

I think this bug can be closed because MariaDB works as intended and as
documented in /usr/share/doc/mariadb-server-10.1/README.Debian.gz

The database root user is not supposed to log in with a password, but
via the unix_socket plugin with the system root user.

To the users who reported the issue: please don't change the settings of
the root user, you'll break the maintenance scripts.

Creating an additional admin user is what Debian maintainers recommend
in /usr/share/doc/mariadb-server-10.1/README.Debian.gz in the PASSWORDS
section, also here:
https://salsa.debian.org/mariadb-team/mariadb-10.1/blob/stretch/debian/mariadb-server-10.1.README.Debian#L73

Ciao,
   Antonio

-- System Information:
Debian Release: buster/sid
  APT prefers unstable-debug
  APT policy: (500, 'unstable-debug'), (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)

Kernel: Linux 4.15.0-1-amd64 (SMP w/2 CPU cores)
Locale: LANG=it_IT.UTF-8, LC_CTYPE=it_IT.UTF-8 (charmap=UTF-8), LANGUAGE=it_IT.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages mariadb-server-10.1 depends on:
ii  adduser                   3.117
ii  debconf [debconf-2.0]     1.5.66
ii  galera-3                  25.3.22-1
ii  gawk                      1:4.1.4+dfsg-1+b1
ii  iproute2                  4.15.0-2
ii  libaio1                   0.3.110-5
ii  libc6                     2.27-1
ii  libdbi-perl               1.640-1
ii  libpam0g                  1.1.8-3.7
ii  libstdc++6                8-20180218-1
ii  libsystemd0               238-1
ii  lsb-base                  9.20170808
ii  lsof                      4.89+dfsg-0.1
ii  mariadb-client-10.1       1:10.1.29-6
ii  mariadb-common            1:10.1.29-6
ii  mariadb-server-core-10.1  1:10.1.29-6
ii  passwd                    1:4.5-1
ii  perl                      5.26.1-5
ii  psmisc                    23.1-1
ii  rsync                     3.1.2-2.1
ii  socat                     1.7.3.2-2
ii  zlib1g                    1:1.2.8.dfsg-5

Versions of packages mariadb-server-10.1 recommends:
ii  libhtml-template-perl  2.97-1

Versions of packages mariadb-server-10.1 suggests:
ii  mailutils [mailx]  1:3.4-1
ii  netcat-openbsd     1.187-1
pn  tinyca             <none>

-- debconf information excluded
-- 
Antonio Ospite
https://ao2.it
https://twitter.com/ao2it

A: Because it messes up the order in which people normally read text.
   See http://en.wikipedia.org/wiki/Posting_style
Q: Why is top-posting such a bad thing?