Remote connection Mariadb


#1

Hi

I am using MariaDB v10.1.36

I attempting to configure remote access in my.cnf file on my Centos 7 Server locates at /etc/my.cnf

All the instructions I can find say locate [mysqld] and comment out skip-networking and bind-addres.

However, when I go into this file it only has the following :

#
# This group is read both both by the client and the server
# use it for options that affect everything
# hashed out september 10 2018
[client-server]

#
# include all files from the config directory
# hashed out september 10 2018
!includedir /etc/my.cnf.d

I then just tried adding:

[mysqld]
bind-address = 0.0.0.0 
skip-networking

I created a test database, gave a user the correct remote IP access, flush privileges and restarted MariaDB.service with systemctl

However, I still can’t get remote access.

Also I am a little flummoxed that I cannot see any of he material that I am supposed to see in this file.

The objective is realltbjust to be able to access MariaDB remotely

Any suggestions would be deeply appreciated.

Thanks
Karen


#2

You probably don’t need to edit the config files. Just add a user who can connect remotely and open port 3306 on the firewall.


#3

Not working - on a Centos7.

I am having someone help me look at it, if I get an clear answer, I will post it back here.