I'm running MariaDB 10.5 Columnstore on Docker as described here. This works fine when I connect to the database starting a command line in the container itself.
But when I try to connect with an SQL Client (such as DBeaver) from localhost on port 3306, I get the following error:
Host '_gateway' is not allowed to connect to this MariaDB server
I tried to fix that changing the
/etc/my.sql.d/server.cnf file setting:
[mysqld] bind-address = 0.0.0.0
but the container always fails after restart.
How to make a MariaDB Columnstore container accept connections from localhost and/or other IP addresses?