I would like to store data remotely in a MariaDB (Xampp) running on Ubuntu. It is running on a totally isolated LAN - no external connection.
I have been looking at various places, but seem to be more confused.
I.E. Is there a simple way to setup mariadb to accept remote data?
•
Do you mean "remotely from the Internet" or "remotely from other computers on the same isolated LAN"?
If you mean the Internet, you have to set up some kind of connection. You can use a router with port forwarding, or a server with an SSH tunnel. But there's no magic way to get the data to an isolated server.
If you mean the same LAN, you don't have to do anything special. MariaDB accepts network connections by default.
Database Administrators is a better place to ask questions about setting up and configuring database servers.
•
Barmar is correct about mariadb defaulting to allowing remote connections, but I believe the Ubuntu package for it sets bind-address to localhost, so they aren't allowed. See https://mariadb.com/docs/server/server-usage/connecting/mariadb-remote-connection-guide-1 to change that.
