[debian-mysql] Bug#1001385: mariadb-client-10.5: authentification fails while the credentials are ok

[Anthony Bourguignon]

Package: mariadb-client-10.5
Version: 1:10.5.12-0+deb11u1
Severity: grave
Justification: renders package unusable

Dear Maintainer,

I’m having an issue with the mariadb-client in bullseye. I can’t connect
to a local server using the mariadb client.

To reproduce the bug :
  - Install bullseye
  - Install mariadb-server and mariadb-client
  - connect as root and create a database and a user :
    create database testbug;
    grant all privileges on testbug.* to 'testbug'@'127.0.0.1'
    identified by 's3cr3t';
  - exit the client
  - try to connect with those credentials :
    mariadb -h 127.0.0.1 -u testbug -p testbug

You can’t connect and get an error :
  ERROR 1045 (28000): Access denied for user 'testbug'@'localhost' (using password: YES)

I’ve tested with a small php script on the same server and the
connection works, so the credentials are ok. I’ve also tested with
dbeaver using a ssh tunnel connection and it works too. It seems broken
only with mariadb client.

For what I’ve tested, I’ve got the issue with a clean install but also
with a buster upgraded to bullseye. The mariadb connection worked
before, but not anymore with mariadb 10.5 (10.3 on buster).

Thanks

-- System Information:
Debian Release: bullseys
Architecture: amd64 (x86_64)