Is it possible / advisable to create users who have access only to the RDS MySQL Read Replica, and not to the main database server? I have several experienced users whom I would like to grant access so that they can run slow queries, but do not want to give them access to the main main database. Trying to do this directly on the server, I get it ERROR 1290 (HY000): The MySQL server is running with the --read-only option so it cannot execute this statement, so I guess that I should do it in the db parameter group or something like that. Anyway, ideas?
source
share