[인프라] 아마존 RDS root 권한 획득

Open the RDS web console.
Open the “Parameter Groups” tab.
Create a new Parameter Group. On the dialog, select the MySQL family compatible to your MySQL database version, give it a name and confirm.
Select the just created Parameter Group and issue “Edit Parameters”.
Look for the parameter ‘log_bin_trust_function_creators’ and set its value to ’1′.
Save the changes.
Open the “Instances” tab. Expand your MySQL instance and issue the “Instance Action” named “Modify”.
Select the just created Parameter Group and enable “Apply Immediately”.
Click on “Continue” and confirm the changes.
Again, open the “Instances” tab. Expand your MySQL instance and issue the “Instance Action” named “Modify”.
Dont forget: Open the “Instances” tab. Expand your MySQL instance and issue the “Instance Action” named “Reboot”.

더 중요한 것은 위의 과정을 해야 권한 획득이 됨. DB 리부팅 필수

별표(*) 대신 (`%`)로 변경 `는 ‘과 다름 
resolving MySQL ‘Access denied for user’ error for root on AWS RDS
by Jackson Murtha    in aws
Sometimes, I need another admin-level user for my MySQL databases. In fact, I usually like to replace the ‘root’ user with another full-permissions user, for slightly improved security.
Usually, I’d start this off like so:
GRANT ALL PRIVILEGES ON *.* TO newuser@'%' IDENTIFIED BY 'somethingsecure' WITH GRANT OPTION;
I was surprised to find that running this command with the root user on Amazon’s RDS instance of MySQL fails with the following message:
ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)
I was pretty miffed about this. As `root`, I should be able to grant

whatever I want! After banging on the keyboard in frustration for a while, I tried this slight variation, out of sheer blind desperation:
GRANT ALL PRIVILEGES ON `%`.* TO newuser@'%' IDENTIFIED BY 'somethingsecure' WITH GRANT OPTION;
(note the substitution of the mysql `%` wildcard for the globbing star ‘*’.

한참 헤맸던 DB 슈퍼유저 권한 획득 관련입니다.