Deploying instance with MySQL on Amazon RDS?

Install / Update Deployment
16

Try using the same name for database and user, like in frappe.

Steps followed: (under the guidance of @revant_one)

  1. Log on to EC2.
$ ssh -i key_file.pem user@instance_name
  1. Log on to RDS via EC2.
$ mysql -h abc.rds.amazonaws.com -u username -P 3306 -p
  1. Create a new database.
mysql [(none)]> create database frappedb;
  1. Add a user. (Username must be identical to database name)
mysql [(none)]> create user frappedb;
  1. Set privileges for user.
mysql [(none)]> GRANT ALL ON frappedb.* TO 'frappedb'@'%';
mysql [(none)]> FLUSH PRIVILEGES;
  1. Exit mysql prompt and restore RDS database to frappedb.
mysql -h abc.rds.amazonaws.com -u username -P 3306 -p frappedb < frappe_backup.sql
  1. Update mariadb host.
$ bench set-mariadb-host abc.rds.amazonaws.com
  1. Bench update to confirm setup. Should run smoothly.
$ bench update
8 Likes