After MySQL / MariaDB successfully installed, may be you want to give remote access to the server. Lets say the database server’s IP is 192.168.10.105, and you have web server at 192.168.10.100
so what you must to do is, open the terminal and:
vi /etc/my.cnf.d/server.cnf
uncomment #bind-address and fill it with your MySQL server’s IP
bind-address=192.168.10.105
save the file, and restart mysql / mariadb services using:
systemctl restart mariadb
Then, you must login to mysql console:
and do something like this:
grant all privileges on monitoring . * to ‘user’@’192.168.10.1’ identified by ‘password’;
dont forget to run flush privileges;
That’s it, now you can test the database connection from other server