Chapter 24. Starting, Stopping, and Configuring MySQL

This chapter discusses the issues involved in setting up and configuring MySQL. It covers the following exam topics:

• Types of MySQL distributions available

• Starting and stopping MySQL Server on Windows

• Starting and stopping MySQL Server on Unix and Unix-like systems such as Linux

• Specifying options for server runtime configuration

• Log and status files

• Loading the time zone tables for named time zone support

• Security-related configuration options

• Setting the default SQL mode

• Upgrading an older installation to a newer version of MySQL

This chapter covers general methods for starting and stopping MySQL Server. The material here assumes that MySQL has been installed already and does not go into detail about installation procedures. Those details can be found in the installation chapter of the MySQL Reference Manual. If you need to install MySQL, you can get any distribution files you need from the MySQL AB Web site (http://dev.mysql.com).