Hi, For that, you need to refer Aurora DB docs provided by amazon.
For MySQL please refer below text. MySQL/MariaDB Prerequisite : Server variable log_bin_trust_function_creators should be set to 1. MySQL Server variable in RDS can be changed by Parameter group feature provided in RDS Dashboard at the left side of the page. For details please refer - https://www.stratalux.com/blog/always-use-custom-db-parameter-group-creating-rds-instance/ - http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.html - https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html On Wed, Jan 4, 2017 at 8:07 AM, Anandha L Ranganathan <analog.s...@gmail.com > wrote: > I am using "Aurora" database in AWS. Aurora is MySQL compatible RDBMS > database. > > I am unable to grant privileges to the user "rangeradmindb". > > > 1. CREATE USER 'rangeradmindb'@'localhost' IDENTIFIED BY 'xxxxx'; > 2. GRANT ALL PRIVILEGES ON *.* TO 'rangeradmindb'@'localhost'; > 3. Error Code: 1045. Access denied for user 'dbm'@'%' (using password: > YES) 0.034 sec > 4. > > Whereas superuser has these privileges. > > > 1. show grants > 2. GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, > REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK > TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW > VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER > > How do I grant all privileges to the the user "rangeradmindb" > >
