Amazon RDS - MySQL
I tried creating an instance on amazon RDS (MySQL) and I am able to enter sessions, but not edit them.
Also import doesn't even let me select any of the menu options (all grayed out).
Are there some default settings that I need to change on amazon RDS to make it work right?
All Comments (1)
The issue is due to the user not having any rights in the RDM database.
One could normally use the RDM app to grant such privileges, but you must be “admin” to accomplish that. Chicken an egg problem. You have to two choices; configure the data source to use a MySQL user that has “SUPER” privilege, then use RDM to add the non-admin users via the Administration-Users screen, or running the following sql statement to make that user an admin of RDM (replace for USERNAME & FULLNAME)
see script attached
edited by stefane on 1/12/2013
Stéfane Lavergne
MySQLUser.sql