Installing and Configuring MySQL

Abstract

This chapter guides you through MySQL’s installation and configuration process. It is not intended as a replacement for MySQL’s excellent (and mammoth) user manual, but instead highlights the key procedures of immediate interest to anybody who wants to quickly and efficiently ready the database server for use. The following topics are covered:

• Downloading instructions

• Distribution variations

• Installation procedures (source, binary, RPMs)

• Setting the MySQL administrator password

• Starting and stopping MySQL

• Installing MySQL as a system service

• MySQL configuration and optimization issues

• Reconfiguring PHP to use MySQL