Chapter 19. 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, ...

Get Mastering phpMyAdmin 3.4 for Effective MySQL Management now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.