Also, Anandha, were you able to create any other user in your database? If so, what was the syntax and DB user you used?
Thanks Bosco From: Pradeep Agrawal <pradeep.agra...@freestoneinfotech.com> Reply-To: <user@ranger.incubator.apache.org> Date: Tuesday, January 3, 2017 at 7:27 PM To: <user@ranger.incubator.apache.org> Subject: Re: Ranger database setup in AWS Aurora database. 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"
