1. Install dependent packages
Yum-y Install gcc-c++ ncurses-devel cmake make perl gcc autoconf automake zlib libxml libgcrypt libtool Bison
2. Install the Boost library:
First, check whether the boost has been installed
Rpm-qa boost*
Uninstall old boost-* and other libraries:
Yum-y Remove boost-*
Download the BOOST library, copy it to the/usr/local/boost directory after decompression, and then re-cmake and add options to the following options-dwith_boost=/usr/local/boost
(Download: http://sourceforge.net/projects/boost/files/boost/)
Note: mysql5.7.10 requires a boost version of 1.59.0 cannot be another version
: http://liquidtelecom.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz
3. Download MySQL source code
Official website: http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.10.tar.gz
Unzip after download
4. Installation process
(1) Create user, group
# Groupadd MySQL
# Mkdir/home/mysql #自定义位置
# Mkdir/home/mysql/data #自定义位置
# useradd-g mysql-d/home/mysql MySQL
(2) Compiling MySQL
Cmake-dcmake_install_prefix=/home/mysql-dmysql_datadir=/home/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 -ddownload_boost=1-dwith_boost=/usr/local/boost
(3) Installation
The second step is not an error.
Make && make install
(4) Initializing the database
Enter the bin directory under the installation record to perform
./mysqld--initialize--user=mysql--basedir=/home/mysql--datadir=/home/mysql/data
Note: The default password is generated after initialization, please log it down
(5) Adjust configuration file and environment variable parameters
MY.CNF backup that will be generated by default
# Mv/etc/my.cnf/etc/my.cnf.bak
Access to MySQL installation directory support file directory
# Cd/mysql/support-files
Copy the profile template to the new MySQL configuration file,
# CP MY-DEFAULT.CNF/ETC/MY.CNF
You can modify the new profile options as needed, without modifying the configuration options, and MySQL runs on the default configuration parameters.
as follows, I modify the configuration file/etc/my.cnf, which is used to set the encoding to UTF8 to prevent garbled
[Mysqld]
Character_set_server=utf8
init_connect= ' SET NAMES UTF8 '
[Client]
Default-character-set=utf8
Copy the startup script to Init.d
Cp/mysql/support-files/mysql.server/etc/init.d/mysqld
Increase execution permissions
chmod 755/etc/init.d/mysqld
Create a MySQL command file
Ln-s/mysql/bin/mysql/usr/bin/
Note: There is no MySQL command without this file and you cannot access the database in any location using MySQL
(6) Start MySQL
Service mysqld Start
(7) Accessing the database
Mysql-uroot-p
Password is the password you just generated
(8) Modify the default password
Alter user ' root ' @ ' localhost ' identified by ' 123456 ';
Note: Without modifying the default password, SQL will not work properly and must be modified
Here, mysql5.7.10 installation is complete.
Error Record:
CMake compile, you may encounter the Boost library error, cause analysis: May be downloaded boost version inconsistent with the MySQL requirements version, the boost version must be MySQL specified version, below or above the specified version is not available.
Mysql Linux Installation Documentation