Separate database server and erpnext application server

[saidsl]

@MaysaaSafadi

This discussion might help you

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 …