实验环境:rhel6.5
实验主机:server1 172.25.70.1
一、mysql源码安装
1.安装编译mysql的cmake工具
所需软件包:cmake-2.8.12.2-4.el6.x86_64.rpm
[root@server1 ~]# yum install cmake-2.8.12.2-4.el6.x86_64.rpm -y
2.安装mysql源码包
所需软件包:mysql-boost-5.7.11.tar.gz
[root@server1 ~]# tar -zxf mysql-boost-5.7.11.tar.gz
检查编译环境
[root@server1 ~]# cd mysql-5.7.11/
[root@server1 mysql-5.7.11]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/lnmp/mysql -DMYSQL_DATADIR=/usr/local/lnmp/mysql/data -DMYSQL_UNIX_ADDR=/usr/local/lnmp/mysql/data/mysql.sock -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_BOOST=/root/mysql-5.7.11/boost/boost_1_59_0/
出现下面报错,需要删除CMakeCache.txt缓存
执行
[root@server1 mysql-5.7.11]# rm -rf remove CMakeCache.txt
在检查过程中,需要安装下面依赖包
[root@server1 mysql-5.7.11]# yum install -y gcc gcc-c++ make ncurses-devel bison openssl-devel zlib-devel
再次检查,直至通过,如下图
编译和安装
[root@server1 mysql-5.7.11]# make && make install
3.mysql的配置
[root@server1 ~]# vim /etc/my.cnf #更改mysql的data路径和sock路径
datadir=/usr/local/lnmp/mysql/data
socket=/usr/local/lnmp/mysql/data/mysql.sock
[root@server1 ~]# vim ~/.bash_profile #指定位置到全局变量中
PATH=$PATH:$HOME/bin:/usr/local/lnmp/mysql/bin
[root@server1 ~]# source ~/.bash_profile #重新生效
创建mysql用户
[root@server1 ~]# groupadd -g 27 mysql
[root@server1 ~]# useradd -u 27 -g 27 -s /sbin/nologin -M -d /usr/local/lnmp/mysql/ mysql
[root@server1 ~]# id mysql
uid=27(mysql) gid=27(mysql) groups=27(mysql)
初始化之前更改/usr/local/lnmp/mysql/下所有文件的所属用户和所属组为mysql
[root@server1 mysql]# cd /usr/local/lnmp/mysql/
[root@server1 mysql]# chown mysql:mysql . -R
[root@server1 mysql]# ll #更改至如下
total 56
drwxr-xr-x 2 mysql mysql 4096 Feb 23 16:20 bin
-rw-r--r-- 1 mysql mysql 17987 Feb 2 2016 COPYING
drwxr-xr-x 2 mysql mysql 4096 Feb 23 16:19 docs
drwxr-xr-x 3 mysql mysql 4096 Feb 23 16:19 include
drwxr-xr-x 4 mysql mysql 4096 Feb 23 16:20 lib
drwxr-xr-x 4 mysql mysql 4096 Feb 23 16:19 man
drwxr-xr-x 10 mysql mysql 4096 Feb 23 16:21 mysql-tes