Separate database server and erpnext application server

Install / Update Deployment
1

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

2

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.
2 Likes
3

@MaysaaSafadi

This discussion might help you

4 Likes
4

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

5

@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;

1 Like
6

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 faced this while configuring Amazon RDS

2 Likes