Amazon RDS master user permissions

Its easy!

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”.

Via - http://techtavern.wordpress.com/2013/06/17/mysql-triggers-and-amazon-rds/

Your best bet is probably to connect to the database with a mysql command line client and call the SQL commands to create a new user and assign him privileges.

For instance, you might run something like this:

mysql -u [your_master_username] -p -h YOURRDSENDPOINT.rds.amazonaws.com

CREATE USER 'jeffrey'@'%' IDENTIFIED BY 'somepassword';
GRANT SELECT ON [your_database].[some_table] TO 'jeffrey'@'%';

On windows you could use the mysql.exe client, wherever that is.

Useful Docs

AWS RDS security groups documentation (a common area of confusion): http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithSecurityGroups.html

User creation documentation: http://dev.mysql.com/doc/refman/5.5/en/create-user.html

Privilege granting documentation: http://dev.mysql.com/doc/refman/5.5/en/grant.html