Compile MySQL 5.7 source installation FAQ

CMake version

5.7 Compile CMake requires a minimum version of 2.8 and is currently 2.6, so you need to upgrade the CMake version. Information is as follows

Shell> CMake. -dcmake_install_prefix=/db/mysql/mysql_57-dmysql_datadir=/db/mysql/mysql_57/datacmake Error at CMakeLists.txt:21 (  cmake_minimum_required): CMAKE 2.8.2 or higher is REQUIRED. You are running version 2.6.4--configuring incomplete, Errors occurred!shell> cmake--version//view CMake release CMake Versi On 2.6-patch 4 (if Yum is installed, only yum update is required)

CMake official website

Shell> tar zxvf cmake-3.2.2.tar.gz shell> cd cmake-3.2.2/shell> ./bootstrapshell> make && make instal lshell> cmake--versioncmake version 3.2.2

Boost Library

5.7 Compile requires the BOOST class library, you can use the-ddownload_boost=1-dwith_boost= parameter will be found in the specified path, if no find will specify the download and extract to the specified path

The problem description shell> CMake. -dcmake_install_prefix=/db/mysql/mysql_57-dmysql_datadir=/db/mysql/mysql_57/data CMake Suite maintained and Supported by Kitware (Kitware.com/cmake).--Could not find (the correct version of) boost.--MySQL currently requires boos T_1_59_0cmake Error at cmake/boost.cmake:81 (MESSAGE): Can download it with-ddownload_boost=1-dwith_boost= solution One ：

Shell>cmake. -dcmake_install_prefix=/db/mysql/mysql_57-dmysql_datadir=/db/mysql/mysql_57/data-ddownload_boost=1-dwith_boost =/home/develepment/

Workaround Two:

Installing the Boost library

shell> wget http://nbtelecom.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gzshell> Tar JXVF boost_1_57_0.tar.bz2shell> cd boost_1_57_0/shell> ./bootstrap.shshell>./B2 Install post installation directory shell> LS/ Usr/local/include/boostshell> CMake. -dcmake_install_prefix=/db/mysql/mysql_57-dmysql_datadir=/db/mysql/mysql_57/data

mysql_install_db

Shell> cd /db/mysql/mysql_57shell> bin/mysql_install_db --basedir=. --datadir= data --user=mysql[warning] mysql_install_db is deprecated. please consider  switching to mysqld --initializeshell> bin/mysqld --initialize2016-04-1t18 : 17:53.169216z 0 [warning] timestamp with implicit default value is  deprecated. Please use --explicit_defaults_for_timestamp server option  ( See documentation for more details) .2016-04-1t18:17:58.702510z 0 [warning]  innodb: new log files created, lsn=457902016-04-1t18:17:59.538811z 0 [ warning] innodb: creating foreign key constraint system tables.2016-04-1t18 : 17:59.646010z 0 [warning] failed to setup ssl2016-04-1t18:17:59.646105z 0  [Warning] SSL Error: ssl context is not usable without certificate and private  key2016-04-1T18:17:59.663795Z 1 [Warning] A temporary password is  Generated for [email protected]: rq/oh8vws1yh

Initialize password

mysql5.7 generates an initial password, and the previous version does not need to be logged on for the first login.

Shell> Cat/root/.mysql_secret # Password set for user ' [e-mail protected] ' at 2015-04-22 22:13:23? g5w&tz1z.cn Modify the default password shell> bin/mysqladmin-h localhost-u root password ' [email protected] '-P '? g5w&tz1z.cn ' mysqladmin: [Warning] Using a password on the command line interface can be insecure. Warning:since password is sent to server in plain text, use SSL connection to ensure password safety.

In addition mysql5.7 's Mysql.user table structure was modified

Modify Mysql.user mode Change Password mysql> update mysql.user set Authentication_string=password (' 123qwe ') where user= ' svoid ' and Host = ' localhost '; Query OK, 1 row affected (0.01 sec) Rows matched:1 changed:1 warnings:0mysql> flush privileges; Query OK, 0 rows Affected (0.00 sec)

Compile MySQL 5.7 source installation FAQ