Shulou(Shulou.com)06/01 Report--

2.1 General installation Wizard

2.1.1 decide which version of mysql to install

2.1.2 how to get MySQL

2.1.3 install layout Layouts (layout)

2.1.4 compiling the specified feature Compiler-Specific Build Characteristics

2.2 install using Generic Binarie common binaries on the Unix/Linux platform

2.3 install Using Unbreakable Linux Network (ULN) using the linux network

2.4 Source installation

2.4.1 layout of MySQL source installation

2.4.2 install MySQL using standard source code

2.4.3 install using the development package source code

2.4.4 MySQL source configuration options

2.4.5 dealing with problems in compiling and installing MySQL

2.4.6 configuration of MySQL and introduction of third-party tools

2.5 pre-installation testing and preparation

2.5.1 initialize the data directory

2.5.2 start the service

2.5.3 testing service

2.5.4 configure initialization account security

2.5.5 automatically start and stop MySQL

2.6 upgrade and downgrade of MySQL

2.6.1 upgrade MySQL

2.6.2 downgrade MySQL

2.6.3 confirm that tables and indexes must be rebuilt

2.6.4 rebuild and repair tables and indexes

2.6.5 copy the MySQL database to another machine

This chapter describes how to obtain and install MySQL. Detailed information will be given in the next few sections. If you plan to upgrade existing MySQL services, please see the section, Section 2.11.1, "Upgrading MySQL"

If you want to migrate MySQL to another database system, please see the chapter Section A.8, "MySQL 5.7FAQ: Migration"

The steps to install MySQL are as follows:

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

Please note that not all platforms can run MySQL stably and uniformly, and not all platforms that can run MySQL services can visit the link in the list of official support for ORACLE to view the official support for see http://www.mysql.com/support/supportedplatforms/database.html.

Download the software the distribution that you want to install.

For instructions, see Section 2.1.2, "How to Get MySQL". To verify the integrity of the distribution, use the instructions in Section 2.1.3, "Verifying Package Integrity Using MD5 Checksums or GnuPG".

Install the software.

See the section for how to install MySQLSection 2.2, "Installing MySQL on Unix/Linux Using Generic Binaries" using binaries.

Check the section to see how to install Mysql in Section 2.4, "Installing MySQL from Source" in source code.

Perform any necessary postinstallation setup.

After installing the MySQL service, check the chapter Section 2.10, "Postinstallation Setup and Testing" to confirm that the MySQL service is running correctly. In chapter Section 2.10.4, "Securing the Initial MySQL Accounts". Shows you how to set root passwords securely, which will be used when you use binary and source code installations.

Installation of Msql in non-accessible platforms and environments

Unix, Linux, FreeBSD

For general-purpose binary installations on Linux and Unix platforms (similar to .tar.gz package), see section Section 2.2, "Installing MySQL on Unix/Linux Using Generic Binaries."

Use the source code installation to see the chapter Section 2.4, "Installing MySQL from Source"

For installs, configures and builds the source code of the specified platform to view the platform documentation for

For notes on Linux platform installation, please see the chapter 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 chapter of the introduction describes how to install the installation files of your choice to view Section 2.2, "Installing MySQL on Unix/Linux Using Generic Binaries" or select the platform you use to install Section 4, "Installing MySQL from Source" using source code.

2.1.1 choose which version to install

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 the platforms supported by the 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 multi-MySQL support to access see http://www.mysql.com/support/.

When preparing for install MySQL, determine which version and build method (binary or source) to use.

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. The GA version, also known as the stable version, means that the production environment is available. Our recommendation is to use the GA version.

The naming of MySQL version 5. 7 is divided into three-paragraph format, for example, mysql-5.7.1-m1. The meaning is as follows:

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

The second number (7) second minor version. Major and minor versions of constitute (constitute) the serial number of the product. The serial number describes a stable feature set.

The third number (1) is the version number of the series. The number of series changes that fix bug increases with each time. In most cases, the latest version of a series is the best.

The release name has another meaning-stability level. The final level of stability is represented by the suffix after the release series. Possible suffixes are as follows:

MN (for example, M1, m2, m3,...) Indicates that this is a milestone version number (milestone number). The MySQL development version uses the milestone pattern, and each milestone contains a complete set of testing features. From one milestone version to the next, the functional interface may be changed or even removed. It depends on the feedback from community users..

Rc indicates that this is a release and candidate Release Candidate (RC). General RC version of the function and development has been stable, has passed the internal test of MySQL. New features may still be introduced in the RC version, but the target will shift to bug fixes.

Those without a suffix will be the final version (GA) or release a production version. GA is stable and has successfully passed the previous node version and can be used in production environment.

The development version has multiple milestone releases, followed by RC releases, and finally reaches the GA release status.

The second step after determining which version to install is to choose the installation method in most cases. Using binary installation would be a good choice. The binary format is provided to various platforms in native format, such as RPM under linux or DMG package for OSX. On the windows platform, you can use the MySQL Installer to install the binary version.

In some cases (circumstances), the source code compilation installation is used:

You want to install MySQL in an explicit (non-default) location. Standard binary distributions can run at any installation location, but you may need more flexibility to configure the location of each component.

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

-DWITH_LIBWRAP=1 for TCP wrappers function. 0 disable the libwrap library (implements the function of general TCP wrapper and is used by network service daemons)

-DWITH_ZLIB= {system | bundled} for features that depend on compression (compression feature supports enabling libz library support (zib, gzib related)

-DWITH_DEBUG=1 0 disables debug (default is disabled)

See Section 2.4.4, "MySQL Source-Configuration Options" for more source configuration options.

You want to disable some of the features in the binary distribution You want to configure mysqld without some features that are included in the standard binary distributions. For example, in general, a general build supports all language sets, and if you want a minimized MySQL server, you can select only the character set you want at compile time

You want to modify the MySQL source code.

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

2.1.2 how to get MySQL

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

For RPM-based Linux platforms that use Yum as their package management system for RPM installations you can use similar YUM management tools to see the chapter Section 2.5.1, "Installing MySQL on Linux Using the MySQL Yum Repository" for details.

2.1.3 installation layout

Impassable installation methods have impassable installation layouts, which can lead to confusion when using different platforms or using impassable installation sources. The following sections show the layout and installation types for different platforms, but it should be noted that installation layouts for vendors outside ORACLE may not make sense.

Section 2.4.1, "MySQL Layout for Source Installation"

Table 2.2, "MySQL Installation Layout for Generic Unix/Linux Binary Package"

2.1.4 build feature Compiler-Specific Build Characteristics by compiling source code

In some cases, In some cases compiles features that enable MySQL. The explanations in this section apply to binary distributions provided by Oracle, or you can compile yourself from source code. .

Icc (Intel C++ Compiler) Builds

To compile and install features through ICC:

SSL is not supported.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.