AWS RDS Aurora Query Editor : Access denied for user 'admin'@'#.#.#.#' (using password: YES)

Question

I am trying out the query editor and running the default query :

select * from information_schema.tables; # Press run and see the current database tables below

gives me this error : Access denied for user 'admin'@'#.#.#.#' (using password: YES)

user_7708102 · Answer

GRANT ALL PRIVILEGES ON `%`.* TO 'admin'@#.#.#.#;

The above command solved it. Referenced from here.