Chapter 10: Basic Administration

Overview

Although MySQL is easy to maintain and administer, it does not look after itself. This chapter covers the basic administrative tasks, some of which are covered in more detail in the following chapters. Specifically, you'll learn how to start and stop the server, both manually and automatically. You'll also get to know some of the indispensable tools for a MySQL administrator, learn how to use logs, and how to configure MySQL.

Featured in this chapter:

• The MySQL utilities

• Starting and shutting down MySQL

• Starting mysqld automatically upon booting up

• Configuring MySQL

• Logging

• Rotating logs

• Optimizing, checking, analyzing, and repairing tables