On my previous tutorial, I have shown how to install the latest MariaDb 10.1 on CentOS 7.1. By default, MariaDb or MySQL server is accessible only from localhost. We need to change some settings to enable the remote administration or remote access for MariaDb.
First, login to CentOS via Terminal and cd to /etc/my.cnf.d
cd /etc/my.cnf.d
You will see some .cnf files inside the directory. We want to edit only for server.cnf. Use your favorite text editor.
nano server.cnf
Now find the line that tells.
bind-address=0.0.0.0
Make sure you have the line above uncommented to make MariaDb accessible from any IP address. Please be careful when doing this because you will make the MariaDb server accessible from any IP addresses.
Restart MariaDb service
service mysql restart
Done.
One more tips