Centos-8源码安装MySQL-5.7.31

安装流程

1.VMware最小化安装Centos-Stream-8

*设置静态IP根据实际情况修改

TYPE=Ethernet
PROXY_METHOD=none
BROWSER_ONLY=no
BOOTPROTO=static
DEFROUTE=yes
IPV4_FAILURE_FATAL=no
IPV6INIT=no
NAME=eth0
UUID=1206e39b-46ff-4ccc-a09a-dadbe55e0b34
DEVICE=eth0
ONBOOT=yes
HWADDR=00:0C:29:34:F8:82
IPADDR=10.0.0.2
PREFIX=8
GATEWAY=10.255.255.254
DNS1=114.114.114.114
DOMAIN=detachment.fun
IPV6_DISABLED=yes

2.安装依赖

假如使用Centos-Stream-8只勾选了最小化安装可能需要下面的包
gcc gcc-c++ cmake ncurses-devel bison openssl-devel make libtirpc-devel rpcsvc-proto

yum install -y  gcc gcc-c++ cmake ncurses ncurses-devel bison openssl-devel make libtirpc-devel

#安装rpcsvc-proto

xz -d rpcsvc-proto-1.4.2.tar.xz
tar -xvf rpcsvc-proto-1.4.2.tar
cd rpcsvc-proto-1.4.2
./configure
make && make install

3.远程连接上传源码包解压到指定目录并创建用户

下载带有boost版本mysql-boost-5.7.31.tar.gz
上传至目录/usr/local/下

cd /usr/local
mkdir -p /usr/local/mysql
tar -zxvf /usr/local/mysql-boost-5.7.31.tar.gz -C /usr/local/mysql

useradd -s /sbin/nologin mysql
mkdir -p /data/mysql/data
chown -R mysql:mysql /data/mysql

4.编译安装

cd /usr/local/mysql/mysql-5.7.31/
cmake -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_BOOST=boost
make -4j && make install

5.配置my.cnf

强烈建议编译安装完成后给虚拟机创建快照
编辑/etc/my.cnf 文件可能没有自行创建

[client]
port  = 3306
socket = /tmp/mysql.sock

[mysqld]
port = 3306
socket = /tmp/mysql.sock
user = mysql

basedir = /usr/local/mysql
datadir = /data/mysql/data
pid-file = /data/mysql/mysql.pid
log_error = /data/mysql/mysql-error.log

6.初始化

cd /usr/local/
chown -R mysql:mysql mysql
cd /usr/local/mysql
./mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data

7.开机自启

cd /usr/local/mysql/support-files
cp mysql.server /etc/init.d/mysqld
service mysqld start
#环境变量
export PATH=.:/usr/local/mysql/bin:$PATH
source /etc/profile
#开机自启
/usr/lib/systemd/systemd-sysv-install enable mysqld

8.重启登录验证

[root@localhost ~]# mysql  -uroot -p
Enter password:空
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.31 Source distribution

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

总结

萌新一枚
学习使我快乐