Database

How to setup a remote database server

  1. It is assumed you already have your second server up and running
  2. 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

  1. To make sure database has been added run following command
v-list-database-hosts

Why I can't use http://ip/phpmyadmin/

For security reasons we have decided to disable this option.

Please use https://host.domain.tld/phpmyadmin/

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

Add Firewall rule

Then edit /etc/mysql/mariadb.conf.d/50-server.cnf

nano /etc/mysql/mariadb.conf.d/50-server.cnf

And set bind-address = 0.0.0.0 or bind-address = "your.server.ip.address"