1.源码下载
最好是下载包含boost库的版本
mkdir /data/base
cd /data/base
wget https://cdn.mysql.com/archives/mysql-5.7/mysql-boost-5.7.42.tar.gz
2.安装编译工具和依赖
yum -y install make bison-devel ncures-devel libaio perl-Data-Dumper net-tools bison bison-devel gcc gcc-c++ cmake ncurses ncurses-developenssl openssl-devel cyrus-sasl cyrus-sasl-devel cyrus-sasl-lib dtrace systemtap-sdt-devel openssl-devel openldap-devel
3.添加mysql用户组和用户
[root@master base]# groupadd mysql
[root@master base]# useradd -g mysql mysql
4.解压源码,编译和安装
首先将源码移动到/data/base/mysql-5.7.42-src目录,安装到/data/base/mysql-5.7.42目录
tar -zxvf mysql-boost-5.7.42.tar.gz
mv mysql-5.7.42 mysql-5.7.42-src
cd /data/base/mysql-5.7.42-src
cmake -DCMAKE_INSTALL_PREFIX=/data/base/mysql-5.7.42 -DMYSQL_UNIX_ADDR=/data/base/mysql-5.7.42/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DWITH_BOOST=/data/base/mysql-5.7.42-src/boost -DMYSQL_DATADIR=/data/base/mysql-5.7.42/data -DMYSQL_USER=mysql
make -j 2 && make install
5.初始化mysql
mkdir -p /data/base/mysql-5.7.42/log
/data/base/mysql-5.7.42/bin/mysqld --initialize-insecure --basedir=/data/base/mysql-5.7.42 --datadir=/data/base/mysql-5.7.42/data
6.配置mysql启动服务
# 生成服务启动脚本
echo 'export PATH=/data/base/mysql-5.7.42/bin:$PATH' >> /etc/profile
source /etc/profile
# 生成启动脚本
cp /opt/base/mysql-5.7.42/support-files/mysql.server /etc/init.d/mysqld
# 启动服务和设置开机自启
/etc/init.d/mysqld start
chkconfig --add mysqld
chkconfig mysqld on
7.配置密码
#登录MySQL(没有密码登录)
mysql -uroot -p
select version();
update mysql.user set authentication_string=password('root') where user='root';
flush privileges;