Mysql5.7.25源码安装

119 阅读1分钟

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

微信图片_20220510215035.png

root@localhost: 随机密码

实现客户端和服务器端的自动加密传输

//5.7需要开启客户端加密连接,会创建一些证书相关的文件。这是5.7的新命令

[root@10-60-71-116 mysql-5.7.25]# mysql_ssl_rsa_setup

如下:

微信图片_20220510215035.png

10、启动服务

/etc/init.d/mysqld start