Rocky-Linux-9-源码包安装Mysql5.7各人好，我是星哥，本日继承来盘盘Rocky Linux 9体系。 对于那些寻求在 Rocky Linux 9 上从源码编译安装 MySQL 5.7 的开辟者和体系管理员来说，固然 MySQL 5.7 已经不再是最新的版本，但在某些特定场景下，比方兼容性需求或深度定制，源码安装仍旧是不可或缺的选项。 为什么选择源码安装？通过源码包安装 MySQL 5.7 具有以下上风： 最大水平的定制化： 你可以根据本身的需求，在编译时启用或禁用特定功能，优化性能。 办理依靠题目： 对于一些特定情况，预编译包大概存在依靠辩论，源码安装可以更机动地处置惩罚这些题目。 学习和调试： 编译过程有助于深入明白 MySQL 的构建和运行机制，方便举行故障清除和性能调优。 快速安装# 利用：
# gitee:
# wget https:
# sh Rocky_Linux_9_Install_MySQL5_7.sh
# github:
# wget https:
# sh Rocky_Linux_9_Install_MySQL5_7.sh
功能先容功能：Rocky Linux 9体系中源码包安装 mysql5.7 mysql安装的目次：/data/app/mysql5.7/install mysql数据库目次:/data/app/mysql5.7/data mysql数据库设置目次:/data/app/mysql5.7/etc mysql数据库Binlog设置目次： /data/app/mysql5.7/binlog mysql端口为： 61570 mysql root暗码为： CQ1234567 0.界说变量
MYSQL_USER="mysql"
MYSQL_GROUP="mysql"
DOWNLOAD_URL="http://js.funet8.com/rocky-linux/mysql/mysql-boost-5.7.44.tar.gz"
MYSQL_DIR="/data/software/"
Mysql_path='/data/app/mysql5.7'
Mysql_app='/data/app/mysql5.7/install'
Mysql_data='/data/app/mysql5.7/data'
Mysql_etc='/data/app/mysql5.7/etc'
Mysql_binlog='/data/app/mysql5.7/binlog'
MYSQL_PORT="61570"
Server_Id='1'
MYSQL_PassWord="CQ1234567"
1.创建用户groupadd mysql
useradd -M -g mysql -s /sbin/nologin mysql
2.安装依靠包dnf install -y make gcc-c++ cmake bison perl autoconf ncurses-devel openssl-devel libtirpc
mkdir /data/software/
cd /data/software/
wget http://js.funet8.com/rocky-linux/mysql/libtirpc-devel-1.3.3-9.el9.x86_64.rpm
wget http://js.funet8.com/rocky-linux/mysql/rpcgen-1.4-9.el9.x86_64.rpm
rpm -ivh libtirpc-devel-1.3.3-9.el9.x86_64.rpm
rpm -ivh rpcgen-1.4-9.el9.x86_64.rpm
3.安装mysql新建mysql目次 mkdir -p /data/app/mysql5.7 /data/app/mysql5.7/install /data/app/mysql5.7/data /data/app/mysql5.7/etc /data/app/mysql5.7/binlog
下载mysql，而且安装 cd /data/software/
wget http://js.funet8.com/rocky-linux/mysql/mysql-boost-8.0.39.tar.gz
tar -zxvf mysql-boost-5.7.44.tar.gz
cd mysql-5.7.44/
cmake -DCMAKE_INSTALL_PREFIX=/data/app/mysql5.7/install -DMYSQL_DATADIR=/data/app/mysql5.7/data -DMYSQL_UNIX_ADDR=/data/app/mysql5.7/etc/mysql.sock -DSYSCONFDIR=/data/app/mysql5.7/install -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DMYSQL_TCP_PORT=61570 -DENABLED_LOCAL_INFILE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_general_ci -DWITH_BOOST=boost/boost_1_59_0/
make && make install
4.创建设置文件vi /data/app/mysql5.7/etc/my.cnf
填写如下设置 [client]
default-character-set = utf8mb4
[mysqld]
port = 61570
datadir=/data/app/mysql5.7/data
socket=/data/app/mysql5.7/etc/mysql.sock
skip-name-resolve
default-storage-engine = InnoDB
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
server_id = 1
binlog_format = row
gtid_mode = on
enforce-gtid-consistency = true
log_bin = /data/app/mysql5.7/binlog/mysql-bin
log-slave-updates = on
slow_query_log = 1
long_query_time = 2
log_queries_not_using_indexes = 1
slow_query_log_file = /data/app/mysql5.7/etc/slow-61570.log
relay_log_info_repository = TABLE
master_info_repository = TABLE
relay_log_recovery = on
relay_log_purge = 1
log_bin_trust_function_creators = off
sync_binlog = 1
explicit_defaults_for_timestamp=true
ft_min_word_len = 1
lower_case_table_names = 1
max_allowed_packet = 256M
max_connections = 3000
max_connect_errors = 20
back_log = 500
open_files_limit = 65535
interactive_timeout = 3600
wait_timeout = 3600
table_open_cache = 1024
binlog_cache_size = 2M
tmp_table_size = 128M
max_heap_table_size = 16M
read_buffer_size = 1M
read_rnd_buffer_size = 8M
sort_buffer_size = 1M
query_cache_size = 64M
query_cache_limit = 1M
join_buffer_size = 16M
thread_cache_size = 64
innodb_buffer_pool_size=2G
innodb_log_file_size = 256M
innodb_log_buffer_size = 4M
innodb_flush_log_at_trx_commit = 1
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_files_in_group = 3
innodb_open_files = 800
innodb_file_per_table = 1
innodb_write_io_threads = 8
innodb_read_io_threads = 8
innodb_purge_threads = 1
innodb_lock_wait_timeout = 120
innodb_strict_mode=1
innodb_large_prefix = on
[mysqldump]
quick
default-character-set = utf8mb4
max_allowed_packet = 256M
[mysql]
auto-rehash
default-character-set = utf8mb4
5.mysql初始化chown mysql.mysql -R /data/app/mysql5.7
/data/app/mysql5.7/install/bin/mysqld
mysql_passwd_init=`cat ${Mysql_etc}/mysql_install.log | grep password |awk '{print $NF}'`
/data/app/mysql5.7/install/support-files/mysql.server start
修改暗码：
/data/app/mysql5.7/install/bin/mysqladmin -u root -hlocalhost -P61570 -p password CQ1234567
/data/app/mysql5.7/install/support-files/mysql.server stop
再次实行：
chown mysql.mysql -R /data/app/mysql5.7
6.开机启动利用 rc.local 作为启动文件。 echo "添加Mysql5.7开机自启动脚本" >> /etc/rc.local
echo "nohup ${Mysql_app}/bin/mysqld_safe --defaults-file=${Mysql_etc}/my.cnf --user=${MYSQL_USER} > /dev/null 2>&1 &">> /etc/rc.local
systemctl enable rc-local
systemctl start rc-local
chmod +x /etc/rc.d/rc.local
7.添加情况变量echo '#mysql5.7' >> /etc/profile
echo "export PATH=$PATH:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/data/app/mysql5.7/install/bin" >> /etc/profile
source /etc/profile
mysql -V
8.开启防火墙firewall-cmd --zone=public --add-port=61570/tcp --permanent
firewall-cmd --reload
# 检察全部端口
firewall-cmd --zone=public --list-ports
9.新建一个管理员账号创建一个名字star账号，暗码为 PASs5566a ，管理员权限的账号 # /data/app/mysql5.7/install/bin/mysql -u root -h localhost -P61570 -p'CQ1234567'
# CREATE USER 'star'@'%' IDENTIFIED BY 'PASs5566a';
# GRANT all privileges ON * . * TO 'star'@'%' IDENTIFIED BY 'PASs5566a';
# GRANT ALL PRIVILEGES ON * . * TO 'star'@'%' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
# flush privileges;
总结以上就是通过源码包安装 MySQL 5.7 固然的步调，让你对 MySQL 的设置和运行有更深入的明白，并能满意特定的定制化需求。 在生产情况中，请务必关注安全性，定期备份数据，并根据现实负载对 MySQL 举行性能优化。 假如你在安装过程中碰到任何题目，接待在批评区留言交换！ 写文不易，假如你都看到了这里，请点个赞和在看，分享给更多的朋侪；也别忘了关注星哥玩云！这里有满满的干货分享，另有轻松风趣的技能交换～点个赞、分享给身边的小同伴，一起发展，一起玩转技能天下吧！ | 
