phpMyAdmin - User Accounts


phpMyAdmin provides an intuitive user interface for user management. We can view users, edit their previleges etc.

User Accounts

Let's create a user using phpMyAdmin say testuser. Click on the Add User Account link under New Section.

Create user with a strong password.

Add User

Grant Privileges.

Grant Privileges

Now click on go button and phpMyAdmin will create the user and shows the SQL used to create the user.

User added success

Now click on User accounts and verify the user with required privileges.

Verify User