Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I have a working MariaDB 10.2 running on my CentOS 6 server. I can connect to the DB from another machine on the LAN.
Out of curiosity, I wanted to revisit how this was made possible. Everything I read mentions using bind-address in the my.cnf file, but when I examine this file, there is no such directive. Neither is there anything in the files /etc/my.cnf.d/*.cnf.
Is network access a default in this case, or is there some other mysterious directive?
https://mariadb.com/kb/en/configuring-mariadb-for-remote-client-access/ says :
MariaDB only supports one bind-address, but binds to 0.0.0.0, or :: (every IP) if the bind-address directive is left out).
I understand that in this case mariadb listens on every IP address of the machine. However even in this case you can filter on hostname at user account level with the user@host syntax.
