• Home
  • MySQL
  • PHP
  • Apache
  • About
  • Contact Us
 
 
 
  • MySQL 5.5 Reference Manual
  • MySQL 5.1 Reference Manual
  • MySQL 3.23/4.0/4.1 Manual
  • MySQL 4.0 Russian Manual


MySQL 5.5 Reference Manual :: 2 Installing and Upgrading MySQL
« 1.9.5 Supporters of MySQL

2.1 General Installation Guidance »
Section Navigation      [Toggle]
  • Preface, Notes, Licenses
  • 1 General Information
  • 2 Installing and Upgrading MySQL
    • 2.1 General Installation Guidance
    • 2.2 Standard MySQL Installation Using a Binary Distribution
    • 2.3 Installing MySQL on Windows
    • 2.4 Installing MySQL from RPM Packages on Linux
    • 2.5 Installing MySQL on Mac OS X
    • 2.6 Installing MySQL on Solaris
    • 2.7 Installing MySQL on i5/OS
    • 2.8 Installing MySQL on NetWare
    • 2.9 Installing MySQL from tar.gz Packages on Other Unix-Like Systems
    • 2.10 MySQL Installation Using a Source Distribution
    • 2.11 Post-Installation Setup and Testing
    • 2.12 Upgrading or Downgrading MySQL
    • 2.13 Operating System-Specific Notes
    • 2.14 Environment Variables
    • 2.15 Perl Installation Notes
  • 3 Tutorial
  • 4 MySQL Programs
  • 5 MySQL Server Administration
  • 6 Backup and Recovery
  • 7 Optimization
  • 8 Language Structure
  • 9 Internationalization and Localization
  • 10 Data Types
  • 11 Functions and Operators
  • 12 SQL Statement Syntax
  • 13 Storage Engines
  • 14 High Availability and Scalability
  • 15 MySQL Enterprise Monitor
  • 16 Replication
  • 17 Partitioning
  • 18 Stored Programs and Views
  • 19 INFORMATION_SCHEMA Tables
  • 20 MySQL Performance Schema
  • 21 Connectors and APIs
  • 22 Extending MySQL
  • A MySQL 5.5 Frequently Asked Questions
  • B Errors, Error Codes, and Common Problems
  • C MySQL Change History
  • D Restrictions and Limits
  • Index
  • Standard Index
  • C Function Index
  • Command Index
  • Function Index
  • INFORMATION_SCHEMA Index
  • Transaction Isolation Level Index
  • JOIN Types Index
  • Operator Index
  • Option Index
  • Privileges Index
  • SQL Modes Index
  • Status Variable Index
  • Statement/Syntax Index
  • System Variable Index

Chapter 2. Installing and Upgrading MySQL

Table of Contents     [+/-]

2.1. General Installation Guidance     [+/-]
2.1.1. Operating Systems Supported by MySQL Community Server
2.1.2. Choosing Which MySQL Distribution to Install
2.1.3. How to Get MySQL
2.1.4. Verifying Package Integrity Using MD5 Checksums or GnuPG
2.1.5. Installation Layouts
2.1.6. Compiler-Specific Build Characteristics
2.2. Standard MySQL Installation Using a Binary Distribution
2.3. Installing MySQL on Windows     [+/-]
2.3.1. Choosing An Installation Package
2.3.2. Installing MySQL with the Automated Installer
2.3.3. Using the MySQL Installation Wizard
2.3.4. MySQL Server Instance Configuration Wizard
2.3.5. Installing MySQL from a Noinstall Zip Archive
2.3.6. Extracting the Install Archive
2.3.7. Creating an Option File
2.3.8. Selecting a MySQL Server Type
2.3.9. Starting the Server for the First Time
2.3.10. Starting MySQL from the Windows Command Line
2.3.11. Starting MySQL as a Windows Service
2.3.12. Testing The MySQL Installation
2.3.13. Troubleshooting a MySQL Installation Under Windows
2.3.14. Upgrading MySQL on Windows
2.3.15. MySQL on Windows Compared to MySQL on Unix
2.4. Installing MySQL from RPM Packages on Linux
2.5. Installing MySQL on Mac OS X
2.6. Installing MySQL on Solaris
2.7. Installing MySQL on i5/OS
2.8. Installing MySQL on NetWare
2.9. Installing MySQL from tar.gz Packages on Other Unix-Like Systems
2.10. MySQL Installation Using a Source Distribution     [+/-]
2.10.1. Source Installation Overview
2.10.2. Typical configure Options
2.10.3. Installing from the Development Source Tree
2.10.4. Dealing with Problems Compiling MySQL
2.10.5. MIT-pthreads Notes
2.10.6. Installing MySQL from Source on Windows
2.10.7. Compiling MySQL Clients on Windows
2.11. Post-Installation Setup and Testing     [+/-]
2.11.1. Windows Post-Installation Procedures
2.11.2. Unix Post-Installation Procedures
2.11.3. Securing the Initial MySQL Accounts
2.12. Upgrading or Downgrading MySQL     [+/-]
2.12.1. Upgrading MySQL
2.12.2. Downgrading MySQL
2.12.3. Checking Whether Tables or Indexes Must Be Rebuilt
2.12.4. Rebuilding or Repairing Tables or Indexes
2.12.5. Copying MySQL Databases to Another Machine
2.13. Operating System-Specific Notes     [+/-]
2.13.1. Linux Notes
2.13.2. Mac OS X Notes
2.13.3. Solaris Notes
2.13.4. BSD Notes
2.13.5. Other Unix Notes
2.14. Environment Variables
2.15. Perl Installation Notes     [+/-]
2.15.1. Installing Perl on Unix
2.15.2. Installing ActiveState Perl on Windows
2.15.3. Problems Using the Perl DBI/DBD Interface

This chapter describes how to obtain and install MySQL. A summary of the procedure follows and later sections provide the details. If you plan to upgrade an existing version of MySQL to a newer version rather than install MySQL for the first time, see Section 2.12.1, “Upgrading MySQL”, for information about upgrade procedures and about issues that you should consider before upgrading.

If you are interested in migrating to MySQL from another database system, you may wish to read Section A.8, “MySQL 5.5 FAQ: Migration”, which contains answers to some common questions concerning migration issues.

  1. Determine whether MySQL runs and is supported on your platform. Please note that not all platforms are equally suitable for running MySQL, and that not all platforms on which MySQL is known to run are officially supported by Oracle Corporation:

    • For MySQL Enterprise Server, the officially supported platforms are listed at http://www.mysql.com/support/supportedplatforms.php.

    • MySQL Community Server runs on the platforms listed at Section 2.1.1, “Operating Systems Supported by MySQL Community Server”.

  2. Choose which distribution to install. Several versions of MySQL are available, and most are available in several distribution formats. You can choose from pre-packaged distributions containing binary (precompiled) programs or source code. When in doubt, use a binary distribution. We also provide public access to our current source tree for those who want to see our most recent developments and help us test new code. To determine which version and type of distribution you should use, see Section 2.1.2, “Choosing Which MySQL Distribution to Install”.

  3. Download the distribution that you want to install. For instructions, see Section 2.1.3, “How to Get MySQL”. To verify the integrity of the distribution, use the instructions in Section 2.1.4, “Verifying Package Integrity Using MD5 Checksums or GnuPG”.

  4. Install the distribution. To install MySQL from a binary distribution, use the instructions in Section 2.2, “Standard MySQL Installation Using a Binary Distribution”. To install MySQL from a source distribution or from the current development source tree, use the instructions in Section 2.10, “MySQL Installation Using a Source Distribution”.

    If you encounter installation difficulties, see Section 2.13, “Operating System-Specific Notes”, for information on solving problems for particular platforms.

  5. Perform any necessary post-installation setup. After installing MySQL, read Section 2.11, “Post-Installation Setup and Testing”. This section contains important information about making sure the MySQL server is working properly. It also describes how to secure the initial MySQL user accounts, which have no passwords until you assign passwords. The section applies whether you install MySQL using a binary or source distribution.

  6. If you want to run the MySQL benchmark scripts, Perl support for MySQL must be available. See Section 2.15, “Perl Installation Notes”.

Copyright © 1997, 2010, Oracle and/or its affiliates. All rights reserved. Legal Notices
Previous / Next / Up / Table of Contents

User Comments

Posted by Martin Petrov on October 26 2009 3:49pm  

if you are mysql user from Bulgaria read this tutorial "Howto configure,compile and install mysql server 5.1.40"- http://mpetrov.net/konfigurirane-kompilirane-i-instalirane-na-mysql-5-1-40. For more info check my tech blog: http://www.mpetrov.net . Freedom of Mysql

Top / Previous / Next / Up / Table of Contents
Copyright © 2011, doc0.ru
All rights reserved