1、安装依赖
yum -y install cmake
yum -y install ncurses-devel
yum install -y libtirpc-devel
yum -y install openssl openssl-devel
wget https://github.com/thkukuk/rpcsvc-proto/releases/download/v1.4/rpcsvc-proto-1.4.tar.gz
tar xf rpcsvc-proto-1.4.tar.gz
cd rpcsvc-proto-1.4/
./configure
make
make install
2、下载源文件
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.25.tar.gz
wget http://sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz
3、文件解压缩
tar xf mysql-5.7.25.tar.gz
tar xf boost_1_59_0.tar.gz
4、用户及目录权限
cd mysql-5.7.25/
rm -f CMakeCache.txt
useradd -M -s /sbin/nologin mysql
mkdir -p /mysql/data
mkdir /usr/local/mysql
chown -R mysql:mysql /usr/local/mysql
chown -R mysql.mysql /mysql/data
chmod 750 /mysql/data
5、编译安装
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/mysql/data -DWITH_BOOST=../boost_1_59_0 -DSYSCONFDIR=/etc -DENABLED_LOCAL_INFILE=1 -DENABLE_DTRACE=0 -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_general_ci -DWITH_EMBEDDED_SERVER=1
6、编译
make -j $(grep processor /proc/cpuinfo | wc -l) && make install
7、添加环境变量
echo -e '\n\nexport PATH=/usr/local/mysql/bin:$PATH\n' >> /etc/profile && source /etc/profile
8、添加MySQL服务到systemd中
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
#授予可执行的权限
chmod +x /etc/init.d/mysqld
9、初始化数据库
mysqld --initialize --user=mysql
root@localhost: 随机密码
实现客户端和服务器端的自动加密传输
//5.7需要开启客户端加密连接,会创建一些证书相关的文件。这是5.7的新命令
[root@10-60-71-116 mysql-5.7.25]# mysql_ssl_rsa_setup
如下:
10、启动服务
/etc/init.d/mysqld start