Separate database server and erpnext application server

[revant_one]

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

Deploying instance with MySQL on Amazon RDS?

Try using the same name for database and user, like in frappe. Steps followed: (under the guidance of @revant_one) Log on to EC2. $ ssh -i key_file.pem user@instance_name Log on to RDS via EC2. $ mysql -h abc.rds.amazonaws.com -u username -P 3306 -p Create a new database. mysql [(none)]> create database frappedb; Add a user. (Username must be identical to database name) mysql [(none)]> create user frappedb; Set privileges for user. mysql [(none)]> GRANT ALL ON frappedb.* TO 'fr…