How To Create a New User and Grant Permissions in MySQL

How To Create a New User and Grant Permissions in MySQL ?

There are 3 steps :-

1. CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

2. GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';

3. FLUSH PRIVILEGES;


How To Grant Different User Permissions :-

Here is a short list of other common possible permissions that users can enjoy.

ALL PRIVILEGES- as we saw previously, this would allow a MySQL user all access to a designated database (or if no database is selected, across the system)
CREATE- allows them to create new tables or databases
DROP- allows them to them to delete tables or databases
DELETE- allows them to delete rows from tables
INSERT- allows them to insert rows into tables
SELECT- allows them to use the Select command to read through databases
UPDATE- allow them to update table rows

GRANT OPTION- allows them to grant or remove other users' privileges

1.  GRANT [type of permission] ON [database name].[table name] TO ‘[username]’@'localhost’;

2.  REVOKE [type of permission] ON [database name].[table name] FROM ‘[username]’@‘localhost’;

3. DROP USER ‘demo’@‘localhost’;

4.  quit 

5. mysql -u [username]-p