openEuler24.03-SP3编译安装Mysql8

安装依赖项

dnf install -y tar unzip xz wget curl curl-devel openssl openssl-devel cmake make gcc gcc-c++ perl perl-devel libxml2 libxml2-devel freetype bison bison-devel glibc glibc-devel zlib zlib-devel gmp gmp-devel mpfr mpfr-devel libtirpc libtirpc-devel rpcgen boost boost-devel lz4-devel libevent-devel rapidjson-devel openldap-devel lib

下载源代码

1	wget https://dev.mysql.com/get/Downloads/MySQL-8.4/mysql-8.4.8.tar.gz

建立相关目录

1
2
3

mkdir -p /data/mysql/{data,log,tmp}
chown -R mysql:mysql /data/mysql
chmod -R 750 /data/mysql

解压源代码

1	tar zxvf mysql-8.4.8.tar.gz

创建账户群组与账户

1 2	groupadd mysql useradd mysql -s /sbin/nologin -M -g mysql

开始编译安装

1
2
3

mkdir build
cd build
cmake .. -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql/data -DSYSCONFDIR=/etc -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DENABLE_DTRACE=0 -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_general_ci -DWITH_EMBEDDED_SERVER=1 -DWITH_SSL=system -DWITH_BOOST=system

开始安装

1 2	gmake -j $(nproc) gmake install -j $(nproc)