Chapter 15: Installing MySQL

Overview

Perhaps you're a beginner and need to install your own copy of MySQL to have something on which to practice. Or perhaps you're lucky enough to have had systems administrators performing this task for you until now, and you're just curious. Whatever the reason, if you use MySQL extensively, you're likely to need to install MySQL yourself at some stage. And if you're approaching the task with trepidation, this chapter aims to ease you through the process and make you wonder afterward what all the fuss was about.

Featured in this chapter:

• Deciding between a source and a binary distribution

• Installing on Windows

• Installing on Unix

• Installing source and binary distributions

• Compiling MySQL optimally

• Installing multiple servers on the same machine

• Using mysqld_multi to manage multiple servers

• Upgrading from MySQL version 3.23 to version 4