Score:1

How to create a Super User Account on AWS's RDS Mysql?

br flag

The Master user has limited permissions on RDS.

I need SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privileges, and I don't know how to add them to my user.

Tried this solution from another question:

mysql> GRANT ALL PRIVILEGES ON `%`.* TO 'root'@'14.156.117.179';
ERROR 1410 (42000): You are not allowed to create a user with GRANT

Even trying to give SUPER privilege gives me an error.

ERROR 1045 (28000): Access denied for user 'masteruser'@'%' (using password: YES)
Score:2
us flag

A quote from RDS documentation:

Amazon RDS is a managed service, and it doesn't provide SYS access (SUPER privileges).

So, the answer is that you cannot get SUPER privileges there.

Wilson Hauck avatar
jp flag
AWS Customer Support may able to direct your to SALES for additional services.
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.