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.