How do I create another master user for my RDS DB instance running MySQL?

How do I create another master user for my RDS DB instance running MySQL?

1. Begin by getting a list of the permissions currently available to the master user by running the SHOW GRANTS command:

mysql> SHOW GRANTS FOR 'master_user';

The command provides output similar to the following (note: "master_user" is the master user's username):

+----------------------------+
| Grants for master_user@%
+----------------------------+

| 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'@'%' IDENTIFIED BY PASSWORD '' WITH GRANT OPTION |

Copy this list of permissions to use later.

2. Create a new user by using the CREATE USER command (note: replace "new_master_user" and "password" with your preferred username and password):

mysql> CREATE USER 'new_master_user'@'%' IDENTIFIED BY 'password';

3. Grant the list of permissions you got in step 1 to the new user by using the GRANT command:

mysql> 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 'new_master_user'@'%' WITH GRANT OPTION;

The new user will now have the same permissions as the master user.

    • Related Articles

    • What & How : MySQL User

      Run below commands to create MySQL user. 1. For local MySQL 1.CREATE USER 'username'@'%' IDENTIFIED BY 'password'; 2.GRANT ALL ON *.* TO 'username'@'%'; 2. For AWS RDS 1. CREATE USER 'username'@'%' IDENTIFIED BY 'password'; 2. GRANT SELECT, INSERT, ...

    • RDS : What & How it is helpful

      What Is Amazon Relational Database Service (Amazon RDS)?                   Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud. It provides ...

    • Connecting to development database

      Overview: Database Admin UI URL PHPMyAdmin https://pma.openxcell.dev Adminer https://adminer.openxcell.dev MySQL Databases: For all the application using mysql database https://pma.openxcell.dev serves the PHPMyAdmin Frontend. To access the ...

    • Difference between phpMyAdmin and MySQL

      MySQL is a database server (which comes with a command line client for it) PHPMyAdmin is a (web application) client for MySQL. MySql is server where your commands get executed and returns you data, It manages all about data while PhpMyAdmin is a web ...

    • Jail User

      #reference :  https://askubuntu.com/questions/93411/simple-easy-way-to-jail-users Jailkit is a set of utilities that can limit user accounts to a specific directory tree and to specific commands. Setting up a jail is much easier using the Jailkit ...