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"
