How to enable remote access for MariaDb on CentOS 7.1

January 28, 2016 | By | Reply More

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

Tags: , ,

Category: CentOS, Database, Server

Leave a Reply