mysql5.7.11 Source compilation installation (Red hat Linux 6.5)

mysql5.7.11 Source compilation installation (Red hat Linux 6.5)
First, the preparatory work
1.1 Uninstalling the system comes with MySQL

Check to see if the system comes with MySQL, uninstall it if any, there are two kinds of yum, RPM, here to uninstall via Yum

Rpm-qa | grep mysql//view system comes with MySQL
Yum-y Remove mysql-*//uninstall MySQL
Rpm-e–nodeps mysql-5.1.73-3.el6_5.x86_64//uninstall MySQL
1.2 Uninstalling the system comes with boost and installs Boost_1_59_0

MySQL 5.7 relies on boost_1_59_0 or later to see if the system is self-contained, and if so, uninstalls it.

Rpm-qa | grep boost//View system comes with boost
Yum-y Remove boost-*//Offload boost
Rpm-e–nodeps boost-filesystem-1.41.0-11.el6_1.2.x86_64//Offload boost

Install BOOST_1_59_0, CMake compile-time plus-dwith_boost=/usr/local/boost

TAR-ZXVF boost_1_59_0.tar.gz
MV Boost_1_59_0/usr/local/boost

1.3 Installing dependent Packages

Yum install gcc gcc-c++ ncurses ncurses-devel Bison libgcrypt Perl

1.4 Installing CMake

TAR-ZXVF cmake-3.4.1.tar.gz
./configure
Make && make install
1.5 download MySQL source package mysql-5.7.11.tar.gz

Download via wget

wget http://cdn.mysql.com/Downloads/MySQL-5.7.11/mysql-5.7.11.tar.gz

Download the required source package in Windows and upload it via the File Transfer tool Rzsz

Yum Install Lrzsz//installation Rzsz
RZ//Upload

1.6 Creating user groups MySQL and user MySQL

Check if the system already has a MySQL user and if not, create

Cat/etc/group | grep MySQL//See if there is a MySQL user group
cat/etc/passwd | grep MySQL//See if a MySQL user exists
Groupadd MySQL//create user groups
Useradd-r-G MySQL MySQL//create user

1.7 Create MySQL directory and database directory, and give users MySQL permissions

Create MySQL directory and database directory

Mkdir/usr/local/mysql//Create MySQL Directory
Mkdir/usr/local/mysql/data//Create a database directory
Chown-r mysql:mysql/usr/local/mysql//give permission
Second, compile, install, configure MySQL
2.1 Compiling, installing MySQL

Compile with some parameters such as installation root, database directory, encoding, port number, default storage engine, etc.
When compiling, remember to bring-dwith_boost=/usr/local/boost.

TAR-ZXVF mysql-5.7.11.tar.gz
CD mysql-5.7.11
CMake. -dcmake_install_prefix=/usr/local/mysql-dmysql_datadir=/usr/local/mysql/data-ddefault_charset=utf8-ddefault_ Collation=utf8_general_ci-dmysql_tcp_port=3306-dmysql_user=mysql-dwith_myisam_storage_engine=1-dwith_innobase_ Storage_engine=1-dwith_archive_storage_engine=1-dwith_blackhole_storage_engine=1-dwith_memory_storage_engine=1 -denable_downloads=1-ddownload_boost=1-dwith_boost=/usr/local/boost
Make && make install
Configuration options reference Address, [http://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html][1]
2.2 compilation error, before recompiling to delete the compilation failed file

When recompiling, you need to clear the old object file and cache information

Make clean
Rm-f CMakeCache.txt

2.3 Configuring MY.CNF

MY.CNF files can be based on their own needs to choose the right configuration, there are many online, you can refer to, here is not detailed description. Remember to put the MY.CNF in/etc directory

MV MY.CNF/ETC/MY.CNF

2.4 Initializing the system data sheet

Starting with mysql5.7, initializing the system table no longer uses the mysql_install_db tool, but instead uses Mysqld–initialize-insecure–user=mysql, where –initialize indicates that a secure password is generated by default. –initialize-insecure means no password is generated and the password is empty

Cd/usr/local/mysql
Bin/mysqld–initialize-insecure–user=mysql–basedir=/usr/local/mysql–datadir=/usr/local/mysql/data

2.5 Adding environment variables, registering as System services

Add an environment variable and add parameters to PATH:/usr/local/mysql/bin:/usr/local/mysql/lib

Vim/root/.bash_profile
Path=< Span>p a t h : Home/bin:/usr/local/mysql/bin:/usr/local/mysql/lib
Source/root/.bash_profile

Registering as a system service

CP Support-files/mysql.server/etc/init.d/mysqld
Chkconfig mysqld on
Service Mysqld Start/stop/restart/status

First Login setting password

Mysqladmin-uroot-p password 123456//Login time
SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' 123456 '); After login
View process

NETSTAT-LNTP | grep 3306
Pkill mysqld

This article from the "Struggle for the Dream" blog, reprint please contact the author!

mysql5.7.11 Source compilation installation (Red hat Linux 6.5)