Database Reference
In-Depth Information
MySQL Server Administration
This chapter will discuss how a system administrator can use the phpMyAdmin
server management features for day-to-day user account maintenance, server
verification, and server protection. Non-administrators can also obtain server
information from phpMyAdmin.
Server administration is mostly done via the Server view, which is accessed via the
menu tabs available on phpMyAdmin's homepage.
User and privileges management
The Privileges subpage (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 subpage is hierarchical. For
example, when editing a user's privileges, we can see the global privileges as well
as the database-specific privileges. We can then 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 subpage is called User
overview . This shows all user accounts and a summary of their global privileges,
as shown in the next screenshot:
Search WWH ::




Custom Search