一、安装编译依赖包

mysql8编译cmake >= 3.15，gcc >= 5.3

yum -y install gcc-c++ cmake bison ncurses ncurses-devel openssl-devel rpcgen libquadmath-devel libgcrypt libtirpc*

wget "https://dl.rockylinux.org/pub/rocky/10/devel/x86_64/os/Packages/l/libtirpc-devel-1.3.5-1.el10.x86_64.rpm"
rpm -ivh libtirpc-devel-1.3.5-1.el10.x86_64.rpm

二、下载MySQL

下载地址：https://downloads.mysql.com/archives/community/

wget "https://downloads.mysql.com/archives/get/p/23/file/mysql-8.4.6.tar.gz"

三、编译安装MySQL

useradd -r -s /sbin/nologin mysql

tar -zxf mysql-8.4.6.tar.gz
cd mysql-8.4.6
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DWITH_EXTRA_CHARSETS=complex -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DENABLED_PROFILING=on -DWITH_ZLIB=bundled -DENABLED_THREAD_SAFE_CLIENT=on -DWITH_EMBEDDED_SERVER=on -DMYSQL_DATADIR=/var/lib/mysql -DMYSQL_USER=mysql -DSYSCONFDIR=/usr/local/mysql/etc -DMYSQL_UNIX_ADDR=/dev/shm/mysql.sock -DWITH_BOOST=boost -DFORCE_INSOURCE_BUILD=1 -WITH_SSL=system
make -j$(nproc) && make install

1.创建基本目录

mkdir /usr/local/mysql/etc
chmod +w /usr/local/mysql
chown -R mysql:mysql /usr/local/mysql

mkdir /var/log/mysql
chown -R mysql:mysql /var/log/mysql

2.创建mysql.conf配置文件

vim /usr/local/mysql/etc/mysql.conf

3.建立数据表

/usr/local/mysql/bin/mysqld --initialize --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mysql # "–initialize"会生成一个随机密码(密码见/var/log/mysql/error.log文件)
chmod +w /usr/local/mysql
chown -R mysql:mysql /usr/local/mysql

4.启动MySQL

/usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/etc/mysql.conf --daemonize

5.通过命令行登录管理MySQL服务器(提示输入密码时直接回车)

/usr/local/mysql/bin/mysql -uroot -p

6.输入以下SQL语句，设置root用户的密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY '123456';
mysql> FLUSH PRIVILEGES;
mysql> exit;

四、设置开机启动

编辑/usr/lib/systemd/system/mysqld.service文件

[Unit]
Description=MySQL
After=network.target

[Service]
Type=forking
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/etc/mysql.conf --daemonize
ExecReload=/bin/kill -HUP $MAINPID
Restart=on-failure
RestartSec=3

[Install]
WantedBy=multi-user.target

启动MySQL

systemctl start mysqld.service

在开机时启用

systemctl enable mysqld.service

重新加载systemd配置

systemctl daemon-reload

附：

编译过程中出现的问题

编译提示：Could not find rpcgen

解决办法：安装rpcgen，安装步骤如下：

wget https://github.com/thkukuk/rpcsvc-proto/releases/download/v1.4/rpcsvc-proto-1.4.tar.gz
tar -zxf rpcsvc-proto-1.4.tar.gz
cd rpcsvc-proto-1.4
./configure
make && make install