Hihi ^^ I’ve a little question about MariaDB on a Virtualmin server.
I want to make a Discord bot and use a MariaDB databse hosted on my Virtualmin server. It’s the same as with Wordpress but from node.js instead of php…
The thing here is, where can I access a MariaDB database from the outside of the network?
For example, my domain in xurxomf.xyz and I want to log on the database using that domain…
Wordpress uses localhost as host so idk if there is any config needed.
Also, I’ll need an user and a password to connect, which one can I use? The same as the Virtual doman users right?
If there is any guide about this topic please, let me know, I couldn’t find any.
Yes, but you probably should make a new one just for this purpose for security. Remote database connections are very high risk.
You’ll also want to enable and test TLS in MariaDB, so everything is encrypted. None of this is different in a Virtualmin system. MariaDB docs are authoritative for enabling remote access. The only thing to know is that the firewall in a Virtualmin system is firewalld, by default, so you’ll want to open the MariaDB port using firewall-cmd (or the Webmin FirewallD module.
No need for that just create a new user from the webmin mysql module give that user access to the required database and required permissons not forgetting to set the correct gost also