MySQL Server Administration with phpMyAdmin - Mastering phpMyAdmin 2.8 for Effective MySQL Management - page 250

User and Privileges Management
The Privileges sub-page in the Server view contains dialogs to manage MySQL
user accounts, and their privileges on global, database, and table levels. This
sub-page is centered on the user and is hierarchical: for example, when editing a
user's privileges, we can see the global privileges as well as the database-specific
privileges. Then we can go deeper to see the table-specific privileges for this
database-user combination.

The User Overview
The first page displayed when we enter the Privileges sub-page is called User
overview . This shows all user accounts and a summary of their global privileges:

From this page we can:

•
•
•
•

Edit a user's privileges with the Edit link on a user's line.
Use the checkboxes to remove users with the Remove selected users dialog.
Access the page where the Add a new user dialog is available.
Reload the privileges. The effective privileges (the ones against which the
server bases its access decisions) are the privileges that are located in the