install MySQL 5.7.44 on rocky9

只有一个1c2G云主机，要安装LNMP，redis，wordpress等等。mysql8时常会耗尽内存（最低4G内存），mysql5.7是个good option.

Changes in MySQL 5.7.44 (2023-10-25, General Availability)

mysql-5.7.44-linux-glibc2.12-x86_64.tar.gz

MySQL_WITH_SSL='-DWITH_SSL=/usr/local/openssl1.1.1'

tar zxf mysql-5.7.44-linux-glibc2.12-x86_64.tar.gz

cd mysql-5.7.44-linux-glibc2.12-x86_64

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DSYSCONFDIR=/etc \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_PARTITION_STORAGE_ENGINE=1 \

-DWITH_FEDERATED_STORAGE_ENGINE=1 \

-DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8mb4 \

-DDEFAULT_COLLATION=utf8mb4_general_ci \

-DWITH_EMBEDDED_SERVER=1 \

-DENABLED_LOCAL_INFILE=1 ${MySQL_WITH_SSL} ${MySQL_WITH_BOOST}

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

相关日志