Hi all, I want to separate database server and application server, what is the best suggestion to do that? Thanks

@MaysaaSafadi This discussion might help you [image] Remote Database Setup Frappe Framework 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-networ…

There is a command in bench for setting mariadb host. bench set-mariadb-host --help Usage: bench set-mariadb-host [OPTIONS] HOST Set MariaDB host for bench Options: --help Show this message and exit.

Hi Mr @saidsl I tried your solution in the session but I have the following error bench mysql ERROR 1045 (28000): Access denied for user ‘ffe5c07507’@‘46.101.237.84’ (using password: YES) any help plz Thanks

@MaysaaSafadi It seems that bench is accessing the mysql with its own user. Try adding user: ffe5c07507 Using this command: Grant Privilegies to root as GRANT ALL PRIVILEGES ON *.* TO 'ffe5c07507'@'%' IDENTIFIED BY '[ROOT-SQL-PASSWORD]' WITH GRANT OPTION;

Frappe database and database user have same name. so if ffe5c07507 is database name then there should be a user named ffe5c07507 with access to this database. Also no need to give privileges to this user to access other databases. Only accessing ffe5c07507 is fine, *.* not necessary. Recently fac…

Frappe.io Frappe Cloud Documentation Partners Frappe School Marketplace GitHub

Frappe Forum

Separate database server and erpnext application server

Install / Update Deployment

saidsl April 23, 2017, 1:45pm 3

@MaysaaSafadi

This discussion might help you