编译安装mysql

安装依赖包和开发工具包

[root@apache ~]# yum -y install libevent* libtool* autoconf* libstd* ncurse* bison* openssl* gcc gcc-c++ bzip2*
已加载插件：product-id, search-disabled-repos, subscription-manager 

[root@apache ~]# yum -y groupinstall "Development Tools"
已加载插件：product-id, search-disabled-repos, subscription-manager 

下载cmake编译工具

[root@apache ~]# cd /usr/src/
[root@apache src]# wget http://www.cmake.org/files/v2.8/cmake-2.8.12.1.tar.gz
--2019-08-17 20:35:29--  http://www.cmake.org/files/v2.8/cmake-2.8.12.1.tar.gz 

解压

[root@apache src]# tar xf cmake-2.8.12.1.tar.gz
[root@apache src]# ls
cmake-2.8.12.1  cmake-2.8.12.1.tar.gz 

编译安装cmake

[root@apache src]# cd cmake-2.8.12.1
[root@apache cmake-2.8.12.1]# ./configure && make && make install 

编译安装mysql5.7.26

[root@apache src]# cd /usr/src/
[root@apache src]#wget http://downloads.mysql.com/archives/get/file/mysql-5.7.26.tar.gz
[root@apache src]#ls
cmake-2.8.12.1  cmake-2.8.12.1.tar.gz  kernels  mysql-5.7.26.tar.gz
[root@apache src]#tar xf mysql-5.7.26.tar.gz
[root@apache src]#cd mysql-5.7.26
[root@apache src]#  cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DSYSCONFDIR=/etc \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/src/mysql-5.7.26/include/boost_1_59_0/patches/boost
[root@96 mysql-5.7.26]# make && makeinstall

创建mysql用户和组

[root@apache-5.7.26]# groupadd mysql
[root@apache-5.7.26]# useradd -M -s /sbin/nologin -g mysql mysql

设置环境变量

[root@apache-5.7.26]# cd /usr/local/mysql/
[root@apache]# echo 'export PATH=/usr/local/mysql/bin:$PATH' >/etc/profile.d/mysql.sh
[root@apache]# . /etc/profile.d/mysql.sh

初始化数据库

[root@apache]# mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
2019-08-17 21:49:43 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize

修改配置文件

[root@apache]# sed -i '11,13d' /etc/my.cnf
[root@apache]# sed -ri 's#^(datadir=).*#\1/usr/local/mysql/data#g' /etc/my.cnf
[root@apache]# sed -ri 's#^(socket=).*#\1/tmp/mysql.sock#g' /etc/my.cnf

设置服务启动脚本

[root@apache]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@apache]# sed -ri 's#^(basedir=).*#\1/usr/local/mysql#g' /etc/init.d/mysqld
[root@apache]# sed -ri 's#^(datadir=).*#\1/usr/local/mysql/data#g' /etc/init.d/mysqld

启动服务

[root@apache]#service mysqld start
State       Recv-Q Send-Q                   Local Address:Port                                  Peer Address:Port
LISTEN      0      128                                  *:22                                               *:*
LISTEN      0      100                          127.0.0.1:25                                               *:*
LISTEN      0      128                                 :::22                                              :::*
LISTEN      0      100                                ::1:25                                              :::
LISTEN      0      80                                  :::3306      

                                  :::