How to setup a remote database server¶
- It is assumed you already have your second server up and running
- On your Hestia Server run the following command
v-add-database-host mysql new-server.com root password
MySQL may be replaced by the PostgreSQL
- To make sure database has been added run following command
Why I can't use
For security reasons we have decided to disable this option.
How can I connect from a remote location to the database¶
By default connections are disabled open port 3306 in the firewall. Open port 3306 in the firewall
Then edit /etc/mysql/mariadb.conf.d/50-server.cnf
And set bind-address = 0.0.0.0 or bind-address = "your.server.ip.address"