Question

How do I create regular users, and administrators in phpMyAdmin? I just need to know how to create two different groups of users.

Answer 1

For creating two users group, follow the below:

1. On the phpMyAdmin default page (localhost) click on the "Privileges" link
2. Click on the "Add a new User link"
3. Assign the User a login and password
4. Where it says "Database for User" select "None"
5. Leave all checkboxes in global privileges unchecked
6. Press the "Go" button

You should see the new user in the User overview. Global privileges should say "Usage".

1. Click on the edit icon next the the User's account
2. Under "Database-specific privileges" where it says "Add privileges on the following database" chose the database(s) you wish to assign to the user
3. Assign the User whatever privileges you wish them to have for that database
4. Press the "Go" button

Hope this helps you. Please give an upvote. Thank you.