I want to separate database server and application server, what is the best suggestion to do that?
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.
This discussion might help you
Hi Mr @saidsl
I tried your solution in the session but I have the following error
ERROR 1045 (28000): Access denied for user ‘ffe5c07507’@‘220.127.116.11’ (using password: YES)
any help plz
It seems that bench is accessing the mysql with its own user.
Try adding user:
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.
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