I have been using revive ads server for over 2 years now and I use a MySQL database within the same server I host the revive application. Now the database is overloaded and I have successfully migrated the huge data to a more scalable database server which is different from where I host the files. I have tried to input all the details of the new database server on my '/var/domain.conf.php' file but I keep getting error connecting page once I reload the page.
How best can one edit the below with new database details.
New database details (Database name: db-XXXXXXXXXXXX.a.db.ondigitalocean.com, Port: 25060, SSLmode: Required. I have a CA Certificate for the server as well)
[database]
type=mysqli
host=localhost
socket=
port=3306
username=****
password=*******
name=*****
persistent=
mysql4_compatibility=1
protocol=tcp
compress=
ssl=
capath=
ca=