Shulou(Shulou.com)05/31 Report--

Editor to share with you how to install mysql5.6 source code in centos, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

The method of installing mysql5.6 in centos source code: 1. Download the source code package; 2. Through "[root@localhost ~] # tar zxvf mysql-5.6.41.tar.gz [root@localhost..." Compile and install mysql and other commands.

This article operating environment: Centos6.9 system, mysql5.6 version, Dell G3 computer.

The method of installing mysql5.6 in centos source code

Introduction to Mysql version

When you are ready to install MySQL, decide which version and distribution format (binary or source) to use.

First, decide whether to install the development version or the general availability (GA) version. The development version has the latest features, but is not recommended for production. Ga release, also known as production or stable release, is meant to be used for production purposes. We recommend using the latest version of GA.

The naming scheme in MySQL 5.6uses a distribution name consisting of three numbers and an optional suffix; for example, mysql-5.6.1-m1. The numbers in the publication name are explained as follows:

The first number (5) is the major version number.

The second number (6) is the minor version number. Taken together, primary and secondary numbers make up the issue series number. The serial number describes a stable feature set.

The third number (1) is the version number in the release series. This value increases with each new bug fix. In most cases, the latest version of a series is the best choice.

The version name can also include a suffix to indicate the stability level of the release. Publish a series of progress through a set of suffixes to indicate how the level of stability can be improved. The possible suffixes are:

MN (for example, M1, M2recoery M3) represents a milestone number. MySQL development uses a milestone model in which each milestone introduces a small number of thoroughly tested features. After the release of a milestone, the developer will continue with another small version, focusing on the next set of features. Functional interfaces may change or even be deleted from one milestone to the next, based on feedback from community members who have tried these earlier versions. Features in milestone releases may be considered pre-production quality features.

Rc indicates the release candidate (RC). Release candidates are considered stable and have passed all internal tests of MySQL. New features may still be introduced in the RC version, but the focus shifts to fixing bug to stabilize the features introduced earlier in this series.

No suffix indicates general availability (GA) or production version. The GA version is stable, successfully passed the early release phase, and is considered reliable, free from serious errors, and suitable for use in production systems.

The development in the series starts with the milestone version, then the RC version, and finally the GA status version.

Download the source package

Download address on the official website: https://dev.mysql.com/downloads/

Pre-installation preparation

1. Close selinux and iptables

[root@localhost ~] # / etc/init.d/iptables stopiptables: set chain to policy ACCEPT:filter [OK] iptables: clear firewall rules: [OK] iptables: uninstalling module: [OK] [root@localhost ~] # setenforce 0setenforce: SELinux is disabled

Uninstall mysql-server and mysql in 2.rpm mode

[root@localhost ~] # rpm-qa | grep mysqlmysql-libs-5.1.73-8.el6_8.x86_64 if mysql-server is installed, use the rpm-e command to uninstall it

3. Install the mysql dependency package

[root@localhost ~] # yum install-y cmake gcc gcc-c++ ncurses-devel bison zlib openssl

4. Create mysql users and related folders

[root@localhost ~] # groupadd msyql [root@localhost ~] # useradd-g mysql- s / sbin/nologin mysql [root@localhost ~] # mkdir-p / public/mysql/data compile and install MySQL [root @ localhost ~] # tar zxvf mysql-5.6.41.tar.gz [root@localhost mysql-5.6.41] # cd mysql-5.6.41 [root@localhost mysql-5.6.41] # cmake\-DCMAKE_INSTALL_PREFIX=/public/mysql\-DINSTALL_DATADIR=/ Public/mysql/data\-DDEFAULT_CHARSET=utf8\-DDEFAULT_COLLATION=utf8_general_ci\-DEXTRA_CHARSETS=all\-DWITH_EMBEDDED_SERVER=1\-DENABLED_LOCAL_INFILE=1\-DWITH_MYISAM_STORAGE_ENGINE=1\-DWITH_INNOBASE_STORAGE_ENGINE=1\-DWITH_ARCHIVE_STORAGE_ENGINE=1\-DWITH_BLACKHOLE_STORAGE_ENGINE=1\-DWITH_FEDERATED_STORAGE_ENGINE=1\-DWITH_PARTITION_STORAGE_ENGINE=1\-DMYSQL_UNIX_ADDR=/tmp/mysql.sock\-DMYSQL_TCP_PORT=3306\-DENABLED_LOCAL_INFILE=1 \-DSYSCONFDIR=/public/mysql [root@localhost mysql-5.6.41] # make & & make install

Description

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql\ # installation path-DMYSQL_DATADIR=/usr/local/mysql/data\ # data file location-DSYSCONFDIR=/etc\ # my.cnf path-DWITH_MYISAM_STORAGE_ENGINE=1\ # support MyIASM engine-DWITH_INNOBASE_STORAGE_ENGINE=1 \ # support InnoDB engine-DWITH_MEMORY_STORAGE_ENGINE=1\ # support Memory engine-DWITH_READLINE=1\ # Shortcut key function (I haven't used it)-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock\ # connection database socket path-DMYSQL_TCP_PORT=3306 \ # Port-DENABLED_LOCAL_INFILE=1\ # allows data to be imported locally-DWITH_PARTITION_STORAGE_ENGINE=1\ # installation supports database partitioning-DEXTRA_CHARSETS=all\ # install all character sets-DDEFAULT_CHARSET=utf8 \ # default character-optimized operation after DDEFAULT_COLLATION=utf8_general_ci installation [root@localhost mysql-5.6.41] # chown-R mysql:mysql / public/mysql\ # modify the owner and group of the msyql installation directory [root@localhost mysql-5.6.41] # cp support-files/mysql.server / etc/init.d/mysqld [root@localhost ~] # echo "PATH=$PATH:/public/mysql/bin" > / etc/profile.d/mysql .sh [root@localhost ~] # source / etc/profile.d/mysql.sh [root@localhost ~] # chkconfig mysqld on\ # Boot [root@localhost ~] # vim / public/mysql/ my.cnf [mysqld] basedir = / public/mysqldatadir = / public/mysql/dataport = 3306server_id = 11socket = / tmp/mysql.socksql_mode=NO_ENGINE_SUBSTITUTION STRICT_TRANS_TABLES

My.cnf is temporarily configured to start the database, so you have time to organize an my.cnf article.

# my.cnf file priority [root@localhost ~] # mysql-- help | grep my.cnf order of preference, my.cnf, $MYSQL_TCP_PORT / etc/my.cnf / etc/mysql/my.cnf / public/mysql/my.cnf ~ / .my.cnf initialize the database and set the password [root@localhost ~] # / public/mysql/scripts/mysql_install_db-- user=mysql-- basedir=/public/mysql-- datadir=/public/mysql/data\ # initialize the database [root@localhost] # mysqladmin-u root password 'Aa123456'\ # set the root password (you need to start mysql first) Mysql operation # start, stop, Restart, status [root@localhost ~] # / etc/init.d/mysqld start [root@localhost ~] # / etc/init.d/mysqld stop [root@localhost ~] # / etc/init.d/mysqld restart [root@localhost ~] # / etc/init.d/mysqld status [root@localhost ~] # netstat-utpln | the password after grep mysqld# login mysql [root@localhost ~] # mysql-u root-pAa123456\ #-p does not have a space

Netstat-utpln | the password after grep mysqld# login mysql [root@localhost ~] # mysql-u root-pAa123456\ #-p does not have a space.

The above is all the contents of the article "how to install mysql5.6 in the source code in centos". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.