Chapter 2 Installing and Upgrading MySQL

Source: Internet
Author: User
Tags mysql in mysql version account security


2.1 General Installation Wizard
2.1.1 decided to install that version of MySQL
2.1.2 How to get MySQL
2.1.3 Installation layout Layouts (layout)
2.1.4 Compile the specified attribute compiler-specific build characteristics
2.2 Installation of generic Binarie common binaries on the Unix/linux platform
2.3 Installing using unbreakable Linux Network with Linux networks (ULN)
2.4 Source Installation
2.4.1 MySQL Source installation layout
2.4.2 installing MySQL using standard source code
2.4.3 using the development package source code installation
2.4.4 MySQL Source configuration options
2.4.5 handling problems when compiling and installing MySQL
2.4.6 MySQL Configuration and introduction of third-party tools
2.5 Pre-installation testing and preparation
2.5.1 Initializing Data Directory
2.5.2 Start Service
2.5.3 Testing Services
2.5.4 Configure initialization of account security
2.5.5 automatically start and stop MySQL
2.6 MySQL Upgrade and downgrade
2.6.1 Upgrading MySQL
2.6.2 downgrade MySQL
2.6.3 confirm that the tables and indexes must be rebuilt
2.6.4 Rebuilding and repairing tables and indexes
2.6.5 Copy MySQL database to another machine
This chapter describes how to obtain and install MySQL. Detailed information is given in the following sections. If you plan to upgrade an existing MySQL service please see section 2.11.1, "Upgrading MySQL",





If you wish to migrate MySQL to a different database system please see section a.8, "MySQL 5.7 faq:migration",



The steps to install MySQL are basically as follows:



Confirm that MySQL can be supported or run on your platform.



Please note that not all platforms will be able to run MySQL uniformly and consistently, and not all platforms that can run the MySQL service will be able to access the link in the official Oracle supported list see the official support http://www.mysql.com/support/ Supportedplatforms/database.html



Download the software The distribution that is want to install.



For instructions, see sections 2.1.2, "How to Get MySQL". To verify the integrity of the distribution, use the instructions in sections 2.1.3, "Verifying package integrity Using MD5 checksums or GnuPG ".



Install the software.



View Chapter get how to install mysqlsection 2.2 using binary files, "Installing MySQL on Unix/linux using Generic Binaries".



View the section to see how to flush the source to install MySQL in section 2.4, "Installing MySQL from source".



Perform any necessary postinstallation setup.



After installing the MySQL Service, review section 2.10, "Postinstallation Setup and testing" to verify that the MySQL service is running correctly. In section 2.10.4, "Securing the Initial MySQL Accounts". Describes how to safely set the root password, which is used when you use binary and source installation.



Installation in mSQL platform and Environment



Unix, Linux, FreeBSD



For Linux and Unix platforms using a generic binary installation (similar to the. tar.gz package), see section 2.2, "Installing MySQL on Unix/linux using Generic Binaries".



Use source Installation View section 2.4, "Installing MySQL from Source"



For the installation, configuration and build of the specified platform source view the platform documentation for



Linux platform installation includes considerations please see Section 2.5, "Installing MySQL on Linux".



2.1 General Installation Wizard



The following sections describe how to select, download, and confirm your installation files. The last section of the introduction describes how to install your selected installation files to view the Introduction section 2.2, "Installing MySQL on Unix/linux Using Generic Binaries" Or choose the platform you are using to install the source Code Section 4., "Installing MySQL from Source".



2.1.1 Choose to install that version



MySQL now supports a range of operating systems and platforms. Check the official website to confirm http://www.mysql.com/support/supportedplatforms/database.html.



MySQL now supports a range of operating systems and platforms. View supported platforms for GA version, see http://www.mysql.com/support/supportedplatforms/database.html. View the platform http://dev.mysql.com/downloads/mysql/5.7.html supported by the development version. Get access to the see http://www.mysql.com/support/with multiple MySQL support.



When you are ready to install MySQL, be sure to use that version and build method (binary or source).



First, confirm whether to install the development version or the GA version of general Availability (GA). The development version has many new features but is not recommended for production use, and the GA version, also known as stable, means that the production environment is available, and our recommendation is to use the GA version.



The MySQL 5.7 version is named in three sections of format, for example, Mysql-5.7.1-m1. The meanings are as follows:



The first number (5) is the major version and can also be a large version.



The second number (7) is a two-level iteration. Large and small version constitute (composed) the serial number of the product. The serial number describes the stable feature set



The third number (1) is the version number of the series. The number of revisions to each bug fix will increase. Most of the time, the latest version in a series is the best.



The publication name has another meaning-the stability level. The suffix behind the release series represents a stable final level. The possible suffixes are as follows:



MN (for example, M1, M2, M3, ...) indicates that this is a milestone version (milestone number). The MySQL development version uses the milestone model, each of which contains a complete set of test features. Evolving from one milestone version to the next, the feature interface may change or even be removed. This depends on the feedback that the community user uses.



RC indicates that this is a release and candidate Release Candidate (RC). General RC version functionality and development has been stable and has passed the internal testing of MySQL. New features may still be introduced in the RC version, but the target will be moved to the main bug fix.



No suffix will be the final version (GA) or release of the applicable production version. GA is stable and has been successfully passed the previous versions of each node and can be used in production environments.



The development version has multiple milestone release versions, with the RC release version, which eventually arrives at the GA release version status.



The second step after determining the installation of that version is to choose the installation method in most cases. Using a binary installation will be a good choice. Binary formats are available in native format to various platforms, such as RPM or OSX's DMG packages under Linux. Windows platform you can use the MySQL installer to install binary versions.



In some cases (circumstances), the source code will be used to compile the installation:



You want to install MySQL into an explicit (non-default) place. The standard binary release can run at any installation location, but you may need to configure the location of individual components more flexibly.



You may want to configure some features that are not in the standard binary release, such as the following common options:



-dwith_libwrap=1 for TCP wrappers feature. 0 Disable the LibWrap library (Universal TCP wrapper functionality for use with the Network Service daemon)



-dwith_zlib={system|bundled} for features this depend on compression (compression feature supports enable LIBZ library support (Zib, Gzib correlation))



-dwith_debug=1 0 Disable DEBUG (default is disabled)



More source configuration options to view, section 2.4.4, "MySQL source-configuration Options".



You want to disable some features in the binary release you want to configure mysqld without some features that is included in the standard binary distributions. For example, general builds support all language sets, and if you want a minimal MySQL server, you can choose just the character set you want to compile at compile time.



You want to modify the MySQL source code.



The source code release version has more test cases than the binary release version.



2.1.2 How to get MySQL



From this page http://dev.mysql.com/downloads/the current MySQL version and download information. Download the full range of downloads from this webpage http://dev.mysql.com/downloads/mirrors.html. .



For rpm-based Linux platforms, that using Yum as their package management system you can use similar Yum management tools to get View section sections 2.5.1 for installing with RPM , "Installing MySQL on Linux Using the MySQL Yum Repository" for details.



2.1.3 Installation Layout



There is no way to install the installation layout, when the different platforms or the use of the installation source can cause confusion. The following sections give the layout and installation types for different platforms, but it is important to note that the installation layout of vendors outside of Oracle may not



Section 2.4.1, "MySQL Layout for Source Installation"



Table 2.2, "MySQL installation Layout for Generic Unix/linux Binary Package"



2.1.4 Source compilation build feature compiler-specific build characteristics



In some cases in some cases, compiling applies to some of the features that turn on MySQL. The interpretation in this section applies to the binary release provided by Oracle, or you can compile yourself from source code.





SSL is not supported.



Chapter 2 Installing and Upgrading MySQL


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.