扩展
mysql8源码安装
安装 MySQL8 编译依赖
dnf install -y \
gcc \
gcc-c++ \
cmake \
ncurses \
ncurses-devel \
openssl \
openssl-devel \
bison \
make \
perl \
wget \
rpcgen \
git \
libtirpc \
libtirpc-devel命令作用：
- 使用
dnf包管理器执行install操作，对软件包进行安装、更新、删除或查询。
执行结果：
- 成功后软件包会按指定动作完成安装、更新、删除或查询；失败时检查仓库、网络和权限。
关键参数：
注意事项：
关键参数：
注意事项：
--------------内容如下-------------------
--------------保存退出-------------------
**注意事项：**
--datadir=/usr/local/mysql/data[client] socket=/usr/local/mysql/mysql.sock [mysqld] user=mysql basedir=/usr/local/mysql datadir=/usr/local/mysql/data socket=/usr/local/mysql/mysql.sock port=3306 character-set-server=utf8mb4 #default_authentication_plugin=mysql_native_password log-error=/usr/local/mysql/data/mysql.err pid-file=/usr/local/mysql/data/mysql.pid max_connections=200 innodb_buffer_pool_size=512M [mysql] default-character-set=utf8mb4
**注意事项：**
[Unit]
After=network.target
[Service]
Type=forking
User=mysql
Group=mysql
PIDFile=/usr/local/mysql/data/mysql.pid
TimeoutSec=600
#LimitNOFILE=65535
Restart=on-failure
RestartSec=5
[Install]
WantedBy=multi-user.target注意事项：
**注意事项：**
注意事项：
解决：
**注意事项：**
#!/bin/bash
cpu_num=$(nproc)
sestatus=$(getenforce)
[client]
user=root
password=Aa123456.
[mysql]
socket=/tmp/mysql.sock
[mysqld]
user=mysql
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
character_set_server=utf8mb4
max_connections=300
thread_cache_size=4
wait_timeout=200
interactive_timeout=28800
#default_storage_engine=myisam
default_storage_engine=innodb
innodb_file_per_table=1
innodb_data_file_path=ibdata1:12M;ibdata2:100M:autoextend
#innodb_log_file_size=50M
#innodb_log_files_in_group=2
#innodb_log_group_home_dir=/usr/local/mysql/data
slow_query_log=1
long_query_time=0.1
slow_query_log_file=/usr/local/mysql/data/mysql-slow.log
#log_queries_not_using_indexes=1
#general_log=1
#general_log_file=/opt/3306/data/general.log
#binlog_format=statement
server-id=1
[Unit]
After=network.target
[Service]
Type=forking
User=mysql
Group=mysql
PIDFile=/usr/local/mysql/data/mysqld.pid
TimeoutSec=600
Restart=on-failure
RestartSec=5
StandardOutput=journal
StandardError=journal
SyslogIdentifier=mysqld
[Install]
WantedBy=multi-user.target
注意事项：
#!/bin/bash
cpu_num=$(nproc)
sestatus=$(getenforce)
[Unit] After=network.target After=syslog.target
[Service] Type=forking User=mysql Group=mysql PIDFile=/usr/local/mysql/data/mysqld.pid
TimeoutStartSec=300 Restart=on-failure RestartSec=10 LimitNOFILE=65535 PrivateTmp=true
WorkingDirectory=/usr/local/mysql
StandardOutput=journal StandardError=journal SyslogIdentifier=mysqld
[Install] WantedBy=multi-user.target
[mysqld] basedir=/usr/local/mysql datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
pid-file=/usr/local/mysql/mysqld.pid port=3306
#log-error=/usr/local/mysql/error.log
[client] socket=/tmp/mysql.sock user=root password=Aa123456.
[mysql] socket=/tmp/mysql.sock
**注意事项：**
#!/bin/bash
connName=${connName:-"ens160"}
注意事项：
[baseos] baseurl=https://mirrors.aliyun.com/centos-stream/\$stream/BaseOS/\$basearch/os/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h countme=1 enabled=1
[baseos-debug] baseurl=https://mirrors.aliyun.com/centos-stream/\$stream/BaseOS/\$basearch/debug/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0
[baseos-source] baseurl=https://mirrors.aliyun.com/centos-stream/\$stream/BaseOS/source/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0
[appstream] baseurl=https://mirrors.aliyun.com/centos-stream/\$stream/AppStream/\$basearch/os/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h countme=1 enabled=1
[appstream-debug] baseurl=https://mirrors.aliyun.com/centos-stream/\$stream/AppStream/\$basearch/debug/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0
[appstream-source] baseurl=https://mirrors.aliyun.com/centos-stream/\$stream/AppStream/\$basearch/debug/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0
[crb] baseurl=https://mirrors.aliyun.com/centos-stream/\$stream/CRB/\$basearch/os/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h countme=1 enabled=0
[crb-debug] baseurl=https://mirrors.aliyun.com/centos-stream/\$stream/CRB/\$basearch/debug/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0
[crb-source] baseurl=https://mirrors.aliyun.com/centos-stream/\$stream/CRB/source/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0
[highavailability] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/HighAvailability/\$basearch/os/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h countme=1 enabled=0
[highavailability-debug] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/HighAvailability/\$basearch/debug/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0
[highavailability-source] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/HighAvailability/source/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0
[nfv] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/NFV/\$basearch/os/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h countme=1 enabled=0
[nfv-debug] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/NFV/\$basearch/debug/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0
[nfv-source] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/NFV/source/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0
[rt] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/RT/\$basearch/os/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h countme=1 enabled=0
[rt-debug] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/RT/\$basearch/debug/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0
[rt-source] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/RT/source/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0
[resilientstorage] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/ResilientStorage/\$basearch/os/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h countme=1 enabled=0
[resilientstorage-debug] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/ResilientStorage/\$basearch/debug/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0
[resilientstorage-source] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/ResilientStorage/source/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0
[extras-common] baseurl=http://mirrors.aliyun.com/centos-stream/SIGs/\$stream/extras/\$basearch/extras-common/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-SIG-Extras-SHA512 gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h countme=1 enabled=1
[extras-common-source] baseurl=http://mirrors.aliyun.com/centos-stream/SIGs/\$stream/extras/source/extras-common/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-SIG-Extras-SHA512 gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0
**注意事项：**
注意事项：
**注意事项：**
注意事项：
**命令拆解：**
| 命令部分 | 重要程度 | 详细解释 |
|---|---|---|
| `/etc/security/limits.conf` | 【普通】 | 配置文件路径，命令会读取这个文件里的配置。 |
**注意事项：**
本文由飞书云文档同步生成。涉及命令、SQL、配置示例时，请以飞书源文档和实际环境执行结果为准。