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

The following is about the detailed steps of compiling and installing mysql 5.7.22 in CentOS7.5. The secret of the text is that it is close to the topic. So, no gossip, let's go straight to the following, I believe you will benefit from reading this article on the detailed steps of compiling and installing mysql 5.7.22 in CentOS7.5.

1 mysql installation configuration

Operate on db01

1.1 Uninstall the mariadb-related software packages that come with it

# rpm-qa | grep mariadb

Mariadb-libs-5.5.56-2.el7.x86_64

# rpm-e mariadb-libs-5.5.56-2.el7.x86_64-- nodeps

# yum install libaio-devel ncurses-devel cmake gcc gcc-c++ bison-y

1.2 create related directories

Mkdir-p / usr/local/mysql/tmp-p

Mkdir-p / usr/local/mysql/log-p

Mkdir / usr/local/mysql/mysql_log-bin/-p # specify the path where binlog logs are stored

Useradd-s / sbin/nologin-M mysql

Cd / server/tools/

Extract the mysql-boost-5.7.22.tar.gz package, which contains the boost package and the mysql package. The Boost library is required from MySQL 5.7.5.

# tar xf mysql-boost-5.7.22.tar.gz

1.3 compilation and installation

# cd mysql-5.7.22/

Cmake. -DCMAKE_INSTALL_PREFIX=/usr/local/mysql/\

-DMYSQL_DATADIR=/usr/local/mysql/data\

-DDOWNLOAD_BOOST=1\

-DWITH_BOOST=boost\

-DSYSCONFDIR=/etc\

-DWITH_INNOBASE_STORAGE_ENGINE=1\

-DWITH_PARTITION_STORAGE_ENGINE=1\

-DWITH_FEDERATED_STORAGE_ENGINE=1\

-DWITH_BLACKHOLE_STORAGE_ENGINE=1\

-DWITH_MYISAM_STORAGE_ENGINE=1\

-DENABLED_LOCAL_INFILE=1\

-DENABLE_DTRACE=0\

-DDEFAULT_CHARSET=utf8\

-DWITH_EMBEDDED_SERVER=1

# make

# make install

# echo "export PATH=$PATH:/usr/local/mysql/bin/" > > / etc/profile

# source / etc/profile

1.4 copy the startup script and set it to boot

# cp / usr/local/mysql/support-files/mysql.server / etc/init.d/mysqld

# chmod + x / etc/init.d/mysqld

# chkconfig-add mysqld

# chkconfig mysqld on

1.5 create a mysql profile

Cat > / etc/my.cnf flush privileges

Is there anything you don't understand about the detailed steps of compiling and installing mysql 5.7.22 in CentOS7.5 above? Or if you want to know more about it, you can continue to 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.