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

[Otto Kekäläinen]

Hello!

> On Thu, Dec 9, 2021 at 5:00 AM Anthony Bourguignon
> <debian+bts at toniob.net> wrote:
> ...
> > 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)
>
> You granted permissions to 'testbug'@'127.0.0.1' but you are
> connecting from 'testbug'@'localhost'. Grant permissions to the
> hostname (not IP) and try again. Also report back here if that solved
> it for you, so we can close the bug report.

Did you try this? I am waiting for your comment on the above, thanks.