Control: severity -1 wishlist On Thu, Dec 9, 2021 at 5:00 AM Anthony Bourguignon <debian+...@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!