Chapter 2 Installing and Upgrading MySQL

Table of Contents

2.1 MySQL Installation Overview
2.2 Determining Your Current MySQL Version
2.3 Notes for MySQL Enterprise Server
2.3.1 Enterprise Server Distribution Types
2.3.2 Upgrading MySQL Enterprise Server
2.4 Notes for MySQL Community Server
2.4.1 Overview of MySQL Community Server Installation
2.4.2 Choosing Which MySQL Distribution to Install
2.5 How to Get MySQL
2.6 Verifying Package Integrity Using MD5 Checksums or GnuPG
2.6.1 Verifying the MD5 Checksum
2.6.2 Signature Checking Using GnuPG
2.6.3 Signature Checking Using Gpg4win for Windows
2.6.4 Signature Checking Using RPM
2.7 Installation Layouts
2.8 Compiler-Specific Build Characteristics
2.9 Standard MySQL Installation from a Binary Distribution
2.10 Installing MySQL on Microsoft Windows
2.10.1 Choosing An Installation Package
2.10.2 Installing MySQL on Microsoft Windows Using an MSI Package
2.10.3 MySQL Server Instance Configuration Wizard
2.10.4 Installing MySQL on Microsoft Windows Using a noinstall Zip Archive
2.10.5 Troubleshooting a MySQL Installation Under Windows
2.10.6 Upgrading MySQL on Windows
2.10.7 Windows Postinstallation Procedures
2.10.8 Installing MySQL from Source on Windows
2.11 Installing MySQL on OS X
2.12 Installing MySQL on Linux Using RPM Packages
2.13 Installing MySQL on Solaris
2.14 Installing MySQL on i5/OS
2.15 Installing MySQL on NetWare
2.16 Installing MySQL on Unix/Linux Using Generic Binaries
2.17 Installing MySQL from Source
2.17.1 Installing MySQL Using a Standard Source Distribution
2.17.2 Installing MySQL Using a Development Source Tree
2.17.3 MySQL Source-Configuration Options
2.17.4 Dealing with Problems Compiling MySQL
2.17.5 Compiling and Linking an Optimized mysqld Server
2.18 Postinstallation Setup and Testing
2.18.1 Unix Postinstallation Procedures
2.18.2 Securing the Initial MySQL Accounts
2.19 Upgrading or Downgrading MySQL
2.19.1 Upgrading MySQL
2.19.2 Downgrading MySQL
2.19.3 Checking Whether Tables or Indexes Must Be Rebuilt
2.19.4 Rebuilding or Repairing Tables or Indexes
2.19.5 Copying MySQL Databases to Another Machine
2.20 Operating System-Specific Notes
2.20.1 Linux Notes
2.20.2 OS X Notes
2.20.3 Solaris Notes
2.20.4 BSD Notes
2.20.5 Other Unix Notes
2.20.6 OS/2 Notes
2.21 Environment Variables
2.22 Perl Installation Notes
2.22.1 Installing Perl on Unix
2.22.2 Installing ActiveState Perl on Windows
2.22.3 Problems Using the Perl DBI/DBD Interface

End of Product Lifecycle. Active development for MySQL Database Server version 5.0 has ended. Oracle offers various support offerings which may be of interest. For details and more information, see the MySQL section of the Lifetime Support Policy for Oracle Technology Products ( Please consider upgrading to a recent version.