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 ----------------------------------------------------------------------- ------------------------------------------------------------------------
signature.asc
Description: Message signed with OpenPGP using GPGMail