Prev | Current Page 245 | Next

Marc Delisle

"Mastering phpMyAdmin 2.11 for Effective MySQL Management"

22 does not have this feature, although it is
present since 5.0.37. However, for administrators who are confident about compiling
their own MySQL server, Jeremy Cole, this feature's author, maintains patches
applicable to a 5.1 server on http://jcole.us/patches/mysql/5.1.
Summary
MySQL 5.0's new features helped the product become more standard-compliant.
Even though phpMyAdmin has limited support for these features, especially lacking
a syntax-oriented editor, it has a basic set of features to work with views, routines,
triggers and information_schema, and to display profiling information.
MySQL Server Administration
This chapter will look at 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.
Entering the Server View
The Server view can be accessed from the Home page by choosing one of the
following links:
Show MySQL runtime information
Show MySQL system variables
Processes
Character sets and collations
Storage Engines
Privileges
Databases
Binary log
Import
Export
The Privileges link is visible only if we are logged in as a privileged user. When in
the Server view, we see a menu to go to the other server-related sub-pages.


Pages:
233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257