Chat about MySQL's basic installation and startup

Since MySQL's production environment is usually deployed on Linux, this is just about installing and booting on Linux.

First, version identification

MySQL Version description: for example, MYSQL-5.7.1-M1

The first number 5 represents the major version number and the description file format. All MySQL 5 release versions have the same file format.

The second number 7 represents the release level. The major version number 5 is combined with the publication registration to form the release sequence number.

The third number 1 represents the number of releases. Each time there is a new release, the number of posts is increased by 1.

The m+ number represents a milestone, and MySQL development uses a milestone model to manage.

RC represents a release candidate. Release candidate versions are usually stable. Internal tests and known critical run-time errors were passed. However, this release does not have a wide range of uses, so there is no guarantee that all bugs will be fixed.

If there is no suffix such as m+ number or RC, this version is the official version, which is the version running in the production environment.

Second, get MySQL

Here http://dev.mysql.com/downloads/mysql/get MySQL server.

Third, verify the MD5, ensure the security of the download package, such as

Shell > md5sum mysql-5.6.22-linux-glibc2.5-i686.tar.gz, the results will be compared to the MD5 on the download page, if the consistent representative download package has not been tampered with.

Iv. install MySQL server.

1, set up and run users

shell> Groupadd MySQL

shell> useradd-r-g MySQL MySQL

2. Decompression

shell>&NBSP; < Span style= "Background-color:inherit;" >tar zxvf&NBSP; /path/to/mysql-version-os . tar.gz

shell> ln-s full-path-to-mysql-version-os MySQL

3, modify the directory belongs to the group and users
shell> CD MySQL

Shell> chown-r MySQL.

Shell> chgrp-r MySQL.

4, the Installation system table and the establishment of the CNF default profile, the MySQL configuration file can actually not need, the default configuration file is basically nothing has been set up the configuration items, when starting the MySQL server, most of the settings can be done by command line parameters. However, if you need to start a multi-instance, you still need configuration file support. Creating a profile is a good habit to prevent many hidden errors from occurring.

Shell> bin/mysql_install_db--user=mysql

Shell> chown-r Root.

shell> chown-r MySQL Data

5, start MySQL server,mysqld_safe has a lot of command line parameters can be configured, of course, these command line parameters can also be written in the configuration file. The simplest of the following:

bin/mysqld_safe--user=mysql &

This article is from the architect's path blog, so be sure to keep this source http://wangweiak47.blog.51cto.com/2337362/1586263

Chat about MySQL's basic installation and startup