ERPNext local Server with MariaDB Cloud

[hamedansari]

Hey, has anyone tried to install ERPNext on a local server with a cloud hosted MariaDB Server?

I’m planning to host ERPNext on a local server and host MariaDB on a digitalocean for redundancy reasons. Is it a good idea? Has anyone done this before? If yes, does setting the “host” as the server’s ip enough to point the db host to the ubuntu server?

[Suresh_Thakor]

Please look into this thread.

Remote Database Setup

Steps to setup Remote Database Setup the remote DB to accept remote connections, In /etc/mysql/my.cnf or /etc/my.cnf comment out 1.1 # bind-address=0.0.0.0 1.2 # skip-networking (on later versions of mariadb this is not present) On the remote DB in mysql enter: Grant Privilegies to root as GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '[ROOT-SQL-PASSWORD]' WITH GRANT OPTION; Restart remote MySQL sudo service mysql restart Add remote IP or Address to the local instance …