Allow Remote Access to MariaDB Database

[cyberspace]

If you want to provide remote access to MariaDB/MySQL from some specific IP then:

1. Configure MySQL/MariaDB listening the public IP address of your server or local IP address if the connection come from the local users. Look at "bind-address" it mysql/mariadb config

2. Disable or comment "skip-networking" in mysql/mariadb config

3. Open the port 3306 in CSF/firewall for specific IP address only
tcp|in|d=3306|s=put_remote_ip_here

4. Restart CSF/Firewall

5. Make the user allowed to connect to the database from the remote IP.

I recommend you to look at the docs https://mariadb.com/docs/server/mariadb-quickstart-guides/mariadb-remote-connection-guide

[Andrew C]

Hello cyberspace,

Thank you for taking the time and trouble to provide a step by step guide. I appreciate your assistance.

However if you read my second post on this subject which I published a few days ago I had already implemented remote access to Mariadb on the CWP platform and it works rather well for my purposes. In fact remote access to mariadb in works well in general.

Yes I am expert with mariadb and firewalls running on a stand alone servers and the security features they provide etc. However as mariadb is a core feature of CWP I asked the question "how to" before making an attempt as a good engineer does. There might have been some extra complexity that I was unaware off. Anyway I resolved it my self a while ago.

Thank you for your help anyway its appreciated.