Administrating the MySQL Server - Mastering phpMyAdmin 3.4 for Effective MySQL Management - page 319

Administrating the
MySQL Server
This chapter discusses how a system administrator can use the phpMyAdmin server-
management features for day-to-day user account maintenance, server verification,
and server protection. The subject of how non-administrators can obtain server
information from phpMyAdmin is also covered.
Server administration is mostly done via the Server view, which is accessed via the
menu tabs available on phpMyAdmin's home page.
Managing users and their privileges
The Privileges page (visible only if we are logged in as a privileged user) contains
dialogs to manage MySQL user accounts. It also contains dialogs to manage privileges
on global, database, and table levels. This page is hierarchical. When editing a user's
privileges, we can see the global privileges as well as the database-specific privileges.
Then, when viewing database-specific privileges for a user, we can view and edit this
user's privileges for any table within this database.