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

[Otto Kekäläinen]

Control: severity -1 wishlist

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.

Thanks!