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

[Leon Klingele]

Package: mariadb-server-10.1
Version: 1:10.1.29-6
Followup-For: Bug #865931

Dear Maintainer,

I stumbled across the exact same issue: `mysql_secure_installation` was
asking for a new password which — when specified — wasn't set. `mysql -u root`
would still not ask for a password, rendering the password prompt inside
`mysql_secure_installation` useless.

Steps to reproduce:

Create new testing environment:
$ lxc launch images:debian/stretch test-865931-mysql
$ lxc exec test-865931-mysql -- bash

Reproduce issue:
$ # Add 'testing' repo to your sources.list file
$ apt update
$ apt install --no-install-recommends -y mariadb-server
$ mysql_secure_installation # Make sure to specify a password when asked for
$ mysql -u root # Opens the mysql root prompt without asking for the password

I was able to set a root password as follows.

$ mysql -u root
MariaDB [(none)]> use mysql;
MariaDB [mysql]> update user set authentication_string=password('toor'), plugin='mysql_native_password' where user='root';
MariaDB [mysql]> flush privileges;


-- System Information:
Debian Release: 9.3
 APT prefers testing
 APT policy: (500, 'testing'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 4.9.0-5-amd64 (SMP w/6 CPU cores)
Locale: LANG=C.UTF-8, LC_CTYPE=C.UTF-8 (charmap=UTF-8), LANGUAGE=C.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages mariadb-server-10.1 depends on:
ii  adduser                   3.115
ii  debconf [debconf-2.0]     1.5.61
ii  galera-3                  25.3.22-1
ii  gawk                      1:4.1.4+dfsg-1
ii  iproute2                  4.9.0-1+deb9u1
ii  libaio1                   0.3.110-5
ii  libc6                     2.26-2
ii  libdbi-perl               1.639-1
ii  libpam0g                  1.1.8-3.6
ii  libstdc++6                6.3.0-18
ii  libsystemd0               232-25+deb9u1
ii  lsb-base                  9.20161125
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.4-4.1
ii  perl                      5.26.1-4
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:
pn  libhtml-template-perl  <none>

Versions of packages mariadb-server-10.1 suggests:
pn  mailx           <none>
pn  netcat-openbsd  <none>
pn  tinyca          <none>

-- debconf information excluded
-----------------------------------------------------------------------
------------------------------------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20180126/6e4ca7f2/attachment.sig>