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

[Anthony Bourguignon]

Le dimanche 12 décembre 2021 à 20:54 -0800, Otto Kekäläinen a écrit :
> 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.

Hi. I’ve already replied to this, this is not the issue at all. There is an upstream bug, which has been confirmed :
  https://jira.mariadb.org/browse/MDEV-27215

So I think we should wait for the upstream patch to close this bug.

Thanks