Skip to content

Instantly share code, notes, and snippets.

@caffeinetiger
Last active April 29, 2022 05:23
Show Gist options
  • Save caffeinetiger/6cce8da42dc668b6ca57810314dbc3eb to your computer and use it in GitHub Desktop.
Save caffeinetiger/6cce8da42dc668b6ca57810314dbc3eb to your computer and use it in GitHub Desktop.
Related AWS Premium Knowledge Center Document: - [How do I create another master user for my Amazon RDS DB instance that is running MySQL?](https://aws.amazon.com/premiumsupport/knowledge-center/duplicate-master-user-mysql/)
CREATE USER 'master_user'@'%' IDENTIFIED BY 'password';
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 ON *.* TO 'master_user'@'%' WITH GRANT OPTION;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment