How to create new user in phpmyadmin with privileges ?


1.Log in to phpmyadmin. on user account . on add user account

4.Enter the detail of the new user on Go .

Assigning privileges to user for a specific database

Users are assigned to databases by editing the user record (from the User accounts link on the home page). If you are creating a user specifically for a given table you will have to create the user first (with no global privileges) and then go back and edit that user to add the table and privileges for the individual table.


Was this article helpful?