I am able to reproduce this and it looks indeed like a bug (but not related to Debian packaging IMO, so it should be reported upstream, see below).
Here is a snippet to reproduce. | #!/bin/bash | | # clean | systemctl stop mariadb | rm -rf /var/lib/mysql | mysql_install_db | systemctl start mariadb | | # create user and db | typeset -r VAR_PWD=$(pwgen 128 1) | mariadb -e "create database testbug;" | mariadb -e "grant all privileges on testbug.* to 'testbug'@'127.0.0.1' identified by '$VAR_PWD';" | mariadb -h 127.0.0.1 -u testbug -p"$VAR_PWD" -e "show databases;" See the following: | root@a77afbebd41d:# bash -x t.sh | + systemctl stop mariadb | + rm -rf /var/lib/mysql | + mysql_install_db | Installing MariaDB/MySQL system tables in '/var/lib/mysql' ... | OK | ... | + systemctl start mariadb | ++ pwgen 128 1 | + typeset -r VAR_PWD=niovooChie7oomefoohat0fah8Foo8muDaethee4iakeithu9ahM4eeveib4goa6deixo6joo6ofedies6Taa2ua3looziek5caixohPhai8OhGeemieweesei8Veiy0 | + mariadb -e 'create database testbug;' | + mariadb -e 'grant all privileges on testbug.* to '\''testbug'\''@'\''127.0.0.1'\'' identified by '\''niovooChie7oomefoohat0fah8Foo8muDaethee4iakeithu9ahM4eeveib4goa6deixo6joo6ofedies6Taa2ua3looziek5caixohPhai8OhGeemieweesei8Veiy0'\'';' | + mariadb -h 127.0.0.1 -u testbug -pniovooChie7oomefoohat0fah8Foo8muDaethee4iakeithu9ahM4eeveib4goa6deixo6joo6ofedies6Taa2ua3looziek5caixohPhai8OhGeemieweesei8Veiy0 -e 'show databases;' | +--------------------+ | | Database | | +--------------------+ | | information_schema | | | test | | | testbug | | +--------------------+ This works as expected: | root@a77afbebd41d:# mariadb -h 127.0.0.1 -u testbug -pniovooChie7oomefoohat0fah8Foo8muDaethee4iakeithu9ahM4eeveib4goa6deixo6joo6ofedies6Taa2ua3looziek5caixohPhai8OhGeemieweesei8Veiy0 -e 'show databases;' | +--------------------+ | | Database | | +--------------------+ | | information_schema | | | test | | | testbug | | +--------------------+ This not (tty ask the password): | root@a77afbebd41d:# mysql -h 127.0.0.1 -u testbug -p | Enter password: | ERROR 1045 (28000): Access denied for user 'testbug'@'localhost' (using password: YES) I can't reproduce this with smaller password (with 'pwgen 64 1' for instance). Can I ask you to: - verify if there is a similar issue upstream (jira.mariadb.org) and report it in case you do not find something similar; - forward this bug report to the upstream issue. Thanks! -- Faustin
signature.asc
Description: PGP signature
