I have recently ported a mysql database to AWS RDS Aurora. I caot seem to do the simple granting privileges tasks on my database. I can access the clustered mysql file with the RDS base user. Once in I execute the following.
USE mysql;
CREATE USER 'myUser'@'%' IDENTIFIED BY 'mypass'; // This works
GRANT SELECT ON 'mytable'.* TO 'myUser'@'%'; // Retus 0 rows.
I have verified table, etc. Thanks in advance.