Shulou(Shulou.com)06/01 Report--

Next, let's learn about the detailed steps of source code compilation and installation of mysql-5.7.23. I believe you will benefit a lot after reading it. The text is not much in essence. I hope that the detailed steps of source code compilation and installation of mysql-5.7.23 is what you want.

Mysql-5.7.23 source code compilation installation 1. Download the source code # wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.23.tar.gz# tar xf mysql-5.7.23.tar.gz2. Hide version information

Hidden version information is an abnormal requirement put forward by XX telecom operators. After testing, the version information cannot be deleted directly, otherwise the compilation error will be made and it will be temporarily modified to 100.100.100.

# cd mysql-5.7.23# vim VERSIONMYSQL_VERSION_MAJOR=100MYSQL_VERSION_MINOR=100MYSQL_VERSION_PATCH=100MYSQL_VERSION_EXTRA=

Version higher than 5.8 version of this newspaper error

# error "show_compatibility_56 is to be removed in MySQL 5.8"

Solution:

Modify the sql/mysqld.cc source code to change the following (lines 346-352)

# if MYSQL_VERSION_ID > = 50800#error "show_compatibility_56 is to be removed in MySQL 5.8" # else/* Default value TRUE for the EMBEDDED_LIBRARY, default value from Sys_show_compatibility_56 otherwise.*/my_bool show_compatibility_56= TRUE;#endif / * MYSQL_VERSION_ID > = 50800 * /

Modify to

/ / # if MYSQL_VERSION_ID > = 50800//#error "show_compatibility_56 is to be removed in MySQL 5.8" / / # else/* Default value TRUE for the EMBEDDED_LIBRARY, default value from Sys_show_compatibility_56 otherwise.*/my_bool show_compatibility_56= TRUE;//#endif / * MYSQL_VERSION_ID > = 50800 * /

Then recompile.

3. Download the software required for compilation # yum-y install gcc gcc-c++ cmake ncurses-devel bsion4. Compile mysql

Boost_1_59_0 is needed in the compilation process, because it is not installed, so add-DDOWNLOAD_BOOST=1-DWITH_BOOST=/usr/local

# cmake-DDOWNLOAD_BOOST=1\-DWITH_BOOST=/usr/local\-DCMAKE_INSTALL_PREFIX=/usr/local/mysql\-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock\-DDEFAULT_CHARSET=utf8\-DDEFAULT_COLLATION=utf8_general_ci\-DWITH_MYISAM_STORAGE_ENGINE=1\-DWITH_INNOBASE_STORAGE_ENGINE=1\-DENABLED_LOCAL_INFILE=1\-DMYSQL_DATADIR=/usr/local/mysql/data\-DMYSQL_TCP_PORT=3306# make & & make install5 Install mysql to create mysql users and groups # groupadd-g 306 mysql does not need to log in or create a home directory # useradd-u 306-g 306-s / bin/false-M mysql# chown-R mysql:mysql / usr/local/mysql initialize # cd / usr/local/mysql#. / bin/mysqld-- initialize-- user=mysql-- basedir=/usr/local/mysql-- datadir=/usr/local/mysql/data 2 > & 1 | tee data/mysql_init.log hint: an initial password will be generated at startup Remember to check Forgot to view the file data/mysql_init.log Settings boot # cp support-files/mysql.server / etc/init.d/mysql# chkconfig-- add mysql# chkconfig mysql on# service mysql start# grep "temporary password" data/mysql_init.log2018-10-13T05:25:14.146820Z 1 [Note] A temporary password is generated for root@localhost: f57d_Fp4 (Hq# configuration environment variable # cat > / etc/profile.d/mysql.sh alter user 'root@ 'localhost' identified by 'db.0easy.com' Query OK, 0 rows affected (0.00 sec) View version information mysql > select @ @ version;+-+ | @ @ version | +-+ | 100.100.100 | +-+

1 row in set (0.00 sec)

After reading this article on detailed steps for compiling and installing mysql-5.7.23 with source code, many readers will want to know more about it. For more industry information, you can follow our industry information section.

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.