Database Reference
In-Depth Information
CHAPTER 22
Server Administration
22.0. Introduction
This chapter covers how to perform operations involved in administering a MySQL
server:
•
General server configuration
• The plug-in interface
• Controlling server logging
• Server monitoring
• Backup and recovery
The chapter doesn't cover managing MySQL user accounts. That is an administrative
task, but is covered in
Chapter 23
.
Many of the techniques shown here require administrative access,
such as the ability to modify tables in the
mysql
system database or
use statements that require the
SUPER
privilege. For this reason, to
carry out the operations described here, you'll likely need to con‐
nect to the server as
root
rather than as
cbuser
.
22.1. Configuring the Server
Problem
You want to change the server settings, and also verify that your changes took effect.