What & How : MySQL User

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, 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 'username'@'%' WITH GRANT OPTION ;


NOTE
1. AWS doesn't provide super admin access that.
2. These users will have full access to the database, make changes accordingly to create a read-only user   


    • Related Articles

    • 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 ...

    • 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 ...

    • 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 ...

    • 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 ...

    • Installing phpMyAdmin and MySQL via Docker In local

      Prerequisite: 1. Basic Understanding of Docker and Container :  If you haven't attend any Docker 101 webinars and seminars, ask your TL to arrange one.  2. Docker is installed :  Ref : ...