N2WS AWS 4.0 - Read Only user for RDS to S3 feature

N2WS AWS 4.0 - Read Only user for RDS to S3 feature

Info
Starting at version 4.0, N2WS now support exporting RDS MySQL database to S3 for long term cost saving, this is done using two steps:
  1. Using the existing AWS RDS export to S3 feature to copy the data to the S3 bucket
  2. Exporting the schema ( as this is not exported as part of the AWS RDS export to S3 feature)
For the second step of exporting the schema, N2WS only does read operations and requires the user to provide username/password for the database when configuring the backup policy,
This means provided user can be an Admin user with full access or a Read Only user which will allow us to read the schema, for example:
  1. CREATE USER 'testuser4'@'%' IDENTIFIED BY '12345678A';
  2. GRANT SELECT, PROCESS, LOCK TABLES ON *.* TO 'testuser4'@'%';
  3. FLUSH PRIVILEGES;