Amazon RDS – MySQL – Creating new user Error #1045

On Amazon RDS MySQL creating a new database user with all priviledges results in an error of #1045 – Access denied for user ‘mastername’@’%’ (using password: YES)

Error #1045 - Access denied for user 'mastername'@'%' (using password: YES)

Error #1045 – Access denied for user ‘mastername’@’%’ (using password: YES)

Using:

GRANT ALL PRIVILEGES ON *.* TO 'testuser'@'localhost' REQUIRE NONE WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
Grant all privileges to a MySQL user in PhpMyAdmin

Grant all privileges to a MySQL user in PhpMyAdmin

This is because there are certain priviledges that are not permitted on AWS RDS – MySQL.
You can not assign: FILE, SUPER, RELOAD, SHUTDOWN, REPLICATION CLIENT or REPLICATION SLAVE

Instead, grant all the other permissions.

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, EVENT, TRIGGER, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EXECUTE ON *.* TO 'testuser'@'localhost' REQUIRE NONE WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
AWS RDS suitable permissions for database user

You can not assign: FILE, SUPER, RELOAD, SHUTDOWN, REPLICATION CLIENT or REPLICATION SLAVE

Codemonkey of Node.js, Django, PHP and all things HTML5 Solving tech challenges, one bit at a time.

Posted in Database, servers Tagged with: , , , , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

*