Create a User for Sync - RDS
Having created a new read replica, you will now need to create a MySQL user on it. Log into the read replica from a mysql client (e.g., MySQL Workbench) with the master account. Then create a user to be used only by FlyData Sync. You can do this in MySQL like so:
mysql> CREATE USER 'sync'@'%' IDENTIFIED BY 'your_password'; mysql> GRANT REPLICATION SLAVE, SELECT, RELOAD, REPLICATION CLIENT, LOCK TABLES, EXECUTE ON *.* TO 'sync'@'%'; mysql> FLUSH PRIVILEGES;
For your_password, enter the password you want to use for this new user.