This documentation is for an older version. If you're using the most current version, select the documentation for that version with the version switch in the upper right corner of the online documentation, or by downloading a newer PDF or EPUB file.

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 Windows Postinstallation Procedures
2.10.7 Upgrading MySQL on Windows
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 Initializing the Data Directory
2.18.2 Starting the Server
2.18.3 Testing the Server
2.18.4 Securing the Initial MySQL Accounts
2.18.5 Starting and Stopping MySQL Automatically
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.