PV（Page View）：页面访问量，即页面浏览量或点击量，用户每次刷新一次即被计算一次
UV（Unique Visitor）：独立访客，统计1天内访问某站点的用户数
DAU(Daily Active User)，日活跃用户数量。常用于反映网站、互联网应用或网络游戏的运营情况
吞吐量：应用系统每秒钟最大能接受的用户访问量或者每秒钟最大能处理的请求数

QPS（Query Per Second）：每秒钟处理完请求的次数，注意这里是处理完。具体是指发出请求到服务器处理完成功返回结果。可以理解在Server中有个Counter，每处理一个请求加1，1秒后Counter=QPS
TPS（Transactions Per Second）：每秒钟处理完的事务次数，一般TPS是对整个系统来讲的。一个应用系统1s能完成多少事务处理，一个事务在分布式处理中，可能会对应多个请求，对于衡量单个接口服务的处理能力，用QPS比较多
并发量：系统能同时处理的请求数
RT（Response Time）：响应时间，处理一次请求所需要的平均处理时间

计算公式：
    QPS = 并发量 / 平均响应时间   并发量：同一时刻到达服务器的请求数
    并发量 = QPS * 平均响应时间
    
100w * 100 = 10亿 /8w6秒 = 1300 QPS

hostnamectl set-hostname lnmp.itcast.cn && bash

[root@lnmp ~]# ls /etc/NetworkManager/system-connections/
ens160.nmconnection
[root@lnmp ~]# vim /etc/NetworkManager/system-connections/ens160.nmconnection
------------------------------------------------------  设置开始 -------------------------------------------------------------
[ipv4]
method=manual
addresses=192.168.88.101/24
gateway=192.168.88.2
dns=192.168.88.2;114.114.114.114;

[ipv6]
#method=ignore
method=disabled
------------------------------------------------------  设置结束 -------------------------------------------------------------

[root@lnmp ~]# cat /etc/NetworkManager/system-connections/ens160.nmconnection
[connection]
id=ens160
#uuid=39fc68b0-865c-3bd3-a42d-3e1998f8e2cd
type=ethernet
autoconnect-priority=-999
interface-name=ens160
timestamp=1752853607

[ethernet]

[ipv4]
#method=auto
method=manual
addresses=192.168.88.101/24
gateway=192.168.88.2
dns=192.168.88.2;114.114.114.114;

[ipv6]
#addr-gen-mode=eui64
#method=auto
method=disabled

[proxy]
[root@lnmp ~]#

[root@lnmp ~]# systemctl restart NetworkManager

或者

[root@lnmp ~]# nmcli connection reload

[root@lnmp ~]# nmcli connection down ens33 && nmcli connection up ens33

[root@lnmp ~]# nmcli c up ens160

[root@lnmp ~]# nmcli device show ens160

nmcli connection down <连接名称>
nmcli connection up <连接名称>

nmcli connection down ens33 && nmcli connection up ens33

nmcli networking off
nmcli networking on

# hostnamectl set-hostname lnmp.itcast.cn

vim /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.88.101   lnmp lnmp.itcast.cn

systemctl start/stop/restart/status 服务名称

systemctl enable  服务名称        =>  开机启动
systemctl disable 服务名称        =>  开机不启动  千万不要忘记

iptables -F
systemctl stop firewalld
systemctl disable firewalld
setenforce 0
sed -i '/SELINUX=enforcing/cSELINUX=disabled' /etc/selinux/config

cat >/etc/yum.repos.d/aliyun.repo<<EOF
[baseos]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - 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]
name=CentOS Stream \$releasever - Extras packages
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]
name=CentOS Stream \$releasever - Extras packages - 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
EOF

#!/usr/bin/perl

use strict;
use warnings;
use autodie;

my $mirrors = 'https://mirrors.tuna.tsinghua.edu.cn/centos-stream';

if (@ARGV < 1) {
    die "Usage: $0 <filename1> <filename2> ...\n";
}

while (my $filename = shift @ARGV) {
    my $backup_filename = $filename . '.bak';
    rename $filename, $backup_filename;

    open my $input, "<", $backup_filename;
    open my $output, ">", $filename;

    while (<$input>) {
        s/^metalink/# metalink/;

        if (m/^name/) {
            my (undef, $repo, $arch) = split /-/;
            $repo =~ s/^\s+|\s+$//g;
            ($arch = defined $arch ? lc($arch) : '') =~ s/^\s+|\s+$//g;

            if ($repo =~ /^Extras/) {
                $_ .= "baseurl=${mirrors}/SIGs/\$releasever-stream/extras" . ($arch eq 'source' ? "/${arch}/" : "/\$basearch/") . "extras-common\n";
            } else {
                $_ .= "baseurl=${mirrors}/\$releasever-stream/$repo" . ($arch eq 'source' ? "/" : "/\$basearch/") . ($arch ne '' ? "${arch}/tree/" : "os") . "\n";
            }
        }

        print $output $_;
    }
}

dnf install perl-autodie -y
perl ./update_mirror.pl /etc/yum.repos.d/centos*.repo

# 使用 dnf
dnf clean all && dnf makecache

dnf install epel-release -y
dnf install ntpsec -y
ntpdate cn.ntp.org.cn

-----------------------------------------

yum install chrony -y
systemctl enable chronyd --now
systemctl status chronyd

自行配置chrony时间同步

[root@lnmp ~] # dnf -y install pcre-devel zlib-devel openssl-devel

[root@lnmp ~] # useradd -r -s /sbin/nologin www

安装gcc
yum install -y gcc 

GCC 是 Linux 世界的“基础设施级工具”
它不仅是编译器，更是优化、调试、跨平台的核心工具

下载Nginx源码包
wget https://nginx.org/download/nginx-1.28.0.tar.gz

解压Nginx源码包
tar xvf nginx-1.28.0.tar.gz

预编译（环境检测 + 生成编译配置）
cd nginx-1.28.0
./configure --prefix=/usr/local/nginx --user=www --group=www --with-http_ssl_module --with-http_stub_status_module --with-http_realip_module 

源码编译及安装Nginx
make -j$(nproc) && make install

-j$(nproc) 多进程并行编译

-j 允许 make 同时执行多个任务
echo $(nproc) 返回 CPU 核心数

配置Nginx环境变量
echo 'PATH=$PATH:/usr/local/nginx/sbin/' >> /etc/profile && source /etc/profile

更改/usr/local/nginx目录权限
chown -Rf www:www /usr/local/nginx

查看Nginx版本信息
nginx -v

# 需要下载库
dnf install -y pcre-devel

启动nginx
[root@lnmp ~] # nginx

停止nginx
[root@lnmp ~] # nginx -s quit

# 注意：一定要提前把Nginx停止掉  ----省略操作
nginx -s stop

# Nginx服务配置到该文件中   ----省略操作
cat >/usr/lib/systemd/system/nginx.service <<EOF
[Unit]
Description=Nginx Web Server
After=network.target
  
[Service]
Type=forking

ExecStartPre=/usr/bin/rm -f /run/nginx.pid
ExecStart=/usr/local/nginx/sbin/nginx -c /usr/local/nginx/conf/nginx.conf
ExecReload=/usr/local/nginx/sbin/nginx -s reload
ExecStop=/usr/local/nginx/sbin/nginx -s quit
PrivateTmp=true
  
[Install]
WantedBy=multi-user.target
EOF

[root@nginx ~]# systemctl daemon-reload
[root@nginx ~]# systemctl start nginx
[root@nginx ~]# systemctl status nginx

[root@nginx ~]# systemctl enable nginx

# 1 清空系统中的原有mariadb的配置文件(/etc/my.cnf)
rpm -qa | grep mariadb
rm -rf /etc/my.cnf


# 2 检查当前系统中，是否安装有 MySQL，避免软件冲突
dnf list installed | grep mysql
# 如果有，卸载
dnf remove -y mysql mysql-server


# 3 安装依赖
yum install libaio -y

useradd -r -s /sbin/nologin mysql
id mysql

参数说明：
-r ：系统参数
-s ：shell缩写，用于指定shell解析器，需要登录系统账号，用/bin/bash；不需要登录系统的账号（系统账号），用/sbin/nologin

# 1 解压软件包
tar xvf mysql-8.0.43-linux-glibc2.28-x86_64.tar.xz
ll mysql-8.0.43-linux-glibc2.28-x86_64

xvf：可以解压任何tar类型的压缩包，如.tar.gz或.tar.xz格式压缩包
提示：使用tab键进行自动补全操作。

# 2 把mysql解压后的压缩包（GBLIC版本）移动到 /usr/local/ 下，然后更名为mysql
mv mysql-8.0.43-linux-glibc2.28-x86_64 /usr/local/mysql

或者 

cp -r mysql-8.0.43-linux-glibc2.28-x86_64 /usr/local/mysql

# 切换到mysql工作目录 /usr/local/mysql
cd /usr/local/mysql
./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql &> /tmp/mysqld.log

等价于绝对路径
/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql &>/tmp/mysqld.log

注意：
    这些是等价的，只选择一个就可以，不能一股脑全部执行，哈哈。
    '&>' 会把内容重定向到文件。使用 cat /tmp/mysqld.log 可以查看里面初始化的信息。

选项说明：
--initialize   初始化（真正开始干活）
--user=mysql   以mysql用户的身份初始化数据库，产生文件都是mysql作为拥有者
--basedir=xxx  mysql其安装目录，非常重要

A temporary password is generated for root@localhost: synNE*skt4ts
经验之谈：想查看mysql软件有没有初始化成功，主要看mysql目录下有没有产生data文件夹且文件夹中至少要有一个mysql的文件夹。

延伸一下：有一个文件/tmp/mysqld.log，里面保存了数据库密码信息，如何提取出这个密码？
答：grep password /tmp/mysqld.log | awk '{print $NF}'

注：NF表示 Number of Fields，字段总数。因此，$NF就表示最后一列了。

chown -R mysql.mysql /usr/local/mysql

cd /usr/local/mysql
bin/mysql_ssl_rsa_setup --datadir=/usr/local/mysql/data

# rm -f /etc/my.cnf

# 创建my.cnf
cat >/etc/my.cnf<<EOF
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data

socket=/tmp/mysql.sock
port=3306

log-error=/usr/local/mysql/data/mysql.err
log-bin=/usr/local/mysql/data/binlog

server-id=10
character_set_server=utf8mb4

gtid-mode=on
log-slave-updates=1
enforce-gtid-consistency
sql_mode=NO_ENGINE_SUBSTITUTION
EOF

cat >/usr/lib/systemd/system/mysqld.service<<EOF
[Unit]
Description=MySQL Server
After=network.target

[Service]
User=mysql
Group=mysql
Type=forking

# MySQL 执行命令及路径
ExecStart=/usr/local/mysql/bin/mysqld --daemonize --pid-file=/usr/local/mysql/data/mysqld.pid
ExecStop=/usr/local/mysql/bin/mysqladmin --defaults-file=/etc/my.cnf shutdown

# Ensure MySQL has sufficient time to start up
TimeoutSec=600

# PID 文件路径
PIDFile=/usr/local/mysql/data/mysqld.pid

# Enable these options to auto-restart the service if it crashes
Restart=on-failure
RestartSec=5

[Install]
WantedBy=multi-user.target
EOF

# 重载
systemctl daemon-reload

# 开机自启
systemctl enable mysqld

# 启动
systemctl start mysqld

# 查看状态
systemctl status mysqld

# 停止
systemctl stop mysqld

# 开机不自启
systemctl disable mysqld

# 查看状态
systemctl status mysqld

echo 'export PATH=$PATH:/usr/local/mysql/bin' >> /etc/profile
source /etc/profile

mysql -uroot -p
Enter password: xxxxxxx # 初始默认密码

或者

mysql -uroot -p'初始默认密码'

mysql> set password='MySQL@666';
mysql> flush privileges;
[root@lnmp ~]# which mysql
/usr/bin/which: no mysql in (/root/.local/bin:/root/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/usr/local/nginx/sbin/)
[root@lnmp ~]# echo 'export PATH=$PATH:/usr/local/mysql/bin' >> /etc/profile
source /etc/profile
[root@lnmp ~]# which mysql
/usr/local/mysql/bin/mysql
[root@lnmp ~]# mysql -uroot -p
Enter password:初始默认密码
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.43

Copyright (c) 2000, 2025, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> set password='MySQL@666';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> ^DBye
[root@lnmp ~]# mysql -uroot -pMySQL@666
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.43 MySQL Community Server - GPL

Copyright (c) 2000, 2025, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

mysql>

sed  -i -r 's/SELINUX=[ep].*/SELINUX=disabled/g' /etc/selinux/config
# sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config &> /dev/null
setenforce 0
systemctl stop firewalld &> /dev/null
systemctl disable firewalld &> /dev/null
iptables -F
iptables -t nat -F
iptables -P INPUT ACCEPT
iptables -P FORWARD ACCEPT

#!/bin/bash

if rpm -q libaio &> /dev/null; then
    echo "libaio已安装，跳过安装"
else
    echo "开始安装依赖"
    dnf -y install libaio &> /dev/null
    if [ $? -ne 0 ];then
        echo "libaio安装失败"
        exit 1
    fi
fi

echo "进行解压操作"
if ls -l mysql-8.0.43-linux-glibc2.28-x86_64 &> /dev/null; then
    echo "已解压，跳过"
else
    if [ -f mysql-8.0.43-linux-glibc2.28-x86_64.tar.xz ]; then
        tar -xf mysql-8.0.43-linux-glibc2.28-x86_64.tar.xz
        ls -l mysql-8.0.43-linux-glibc2.28-x86_64
    fi
fi

echo "判断是否安装过MariaDB，进行清理"
rpm -qa | grep mariadb | xargs -r dnf remove -y
if [ -f /etc/my.cnf ]; then
        rm -rf /etc/my.cnf
fi

id mysql &> /dev/null
[ $? -ne 0 ] && useradd -r -s /sbin/nologin mysql

rm -rf /export/server
mkdir -p /export/server
cp -r mysql-8.0.43-linux-glibc2.28-x86_64 /export/server/mysql
chown -R mysql:mysql /export/server/mysql

echo "正在进入mysql目录，对其进行初始化操作..."
cd /export/server/mysql
bin/mysqld --initialize --user=mysql --basedir=/export/server/mysql --datadir=/export/server/mysql/data 2>&1 | tee /tmp/mysqld.log | grep password | awk '{print $NF}' > /tmp/mysql_temp_password.txt

bin/mysql_ssl_rsa_setup --datadir=/export/server/mysql/data &> /dev/null

cat >/etc/my.cnf<<EOF
[mysqld]
port=3306
basedir=/export/server/mysql
datadir=/export/server/mysql/data
socket=/tmp/mysql.sock
character_set_server=utf8
collation-server=utf8_unicode_ci
EOF

cat >/etc/systemd/system/mysqld.service<<EOF
[Unit]
Description=MySQL Server
After=network.target

[Service]
User=mysql
Group=mysql
Type=forking

# MySQL 执行命令及路径
ExecStart=/export/server/mysql/bin/mysqld --daemonize --pid-file=/export/server/mysql/data/mysqld.pid
ExecStop=/export/server/mysql/bin/mysqladmin --defaults-file=/export/server/mysql/my.cnf shutdown

# Ensure MySQL has sufficient time to start up
TimeoutSec=600

# PID 文件路径
PIDFile=/export/server/mysql/data/mysqld.pid

# Enable these options to auto-restart the service if it crashes
Restart=on-failure
RestartSec=5

[Install]
WantedBy=multi-user.target
EOF

echo "正在刷新后台服务，然后启动mysqld..."
systemctl daemon-reload
systemctl start mysqld
systemctl enable mysqld

#10.重置mysql管理员密码为MySQL@666
echo "正在重置mysql管理员密码..."
cd /export/server/mysql
temp_password=`cat /tmp/mysql_temp_password.txt`
bin/mysqladmin -uroot password 'MySQL@666' -p"$temp_password"

echo 'export PATH=$PATH:/export/server/mysql/bin' >> /etc/profile
source /etc/profile

echo "MySQL8安装成功，安装路径：/export/server/mysql，数据库初始密码：MySQL@666"

chmod +x mysql8_install.sh
source mysql8_install.sh
[root@jaking ~]# mysql -uroot -pMySQL@666
mysql: [Warning] Using a password on the command line interface can be insecure                                                  .
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.43 MySQL Community Server - GPL

Copyright (c) 2000, 2025, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

mysql> ^DBye
[root@jaking ~]# cat /etc/redhat-release
CentOS Stream release 9
[root@jaking ~]# dmidecode -s system-manufacturer
Alibaba Cloud
[root@jaking ~]# dmidecode -s system-product-name
Alibaba Cloud ECS
[root@jaking ~]#

[root@lnmp ~]# dnf -y install libxml2-devel libjpeg-devel libpng-devel libwebp-devel freetype-devel curl-devel openssl-devel sqlite sqlite-devel libtool pcre-devel gd-devel

cd /usr/local/src

wget https://github.com/kkos/oniguruma/releases/download/v6.9.8/onig-6.9.8.tar.gz

或者

curl -LO https://github.com/kkos/oniguruma/releases/download/v6.9.8/onig-6.9.8.tar.gz

tar xvf onig-6.9.8.tar.gz
cd onig-6.9.8
./configure 
make
make install

cat >>/etc/profile<<EOF
export ONIG_CFLAGS="-I/usr/include"
export ONIG_LIBS="-L/usr/lib -lonig"
EOF

source /etc/profile

# 下载 libsodium 源码
cd /usr/local/src
dnf install wget -y
wget https://download.libsodium.org/libsodium/releases/libsodium-1.0.20.tar.gz

tar xvf libsodium-1.0.20.tar.gz
cd libsodium-1.0.20

# 编译并安装
./configure && make -j$(nproc) && make install

# 更新库缓存
ldconfig

cat >>/etc/profile<<'EOF'
export LIBSODIUM_CFLAGS="-I/usr/local/include"
export LIBSODIUM_LIBS="-L/usr/local/lib -lsodium"
export LD_LIBRARY_PATH=/usr/local/lib:$LD_LIBRARY_PATH
EOF

source /etc/profile

[root@lnmp ~]# wget https://www.php.net/distributions/php-8.1.30.tar.gz
[root@lnmp ~]# tar xvf php-8.1.30.tar.gz -C /usr/local/src
[root@lnmp ~]# ls /usr/local/src
libsodium-1.0.20         onig-6.9.8         php-8.1.30
libsodium-1.0.20.tar.gz  onig-6.9.8.tar.gz
[root@lnmp ~]# cd /usr/local/src/php-8.1.30/
[root@lnmp php-8.1.30]# ls
build                docs        php.ini-development  tests
buildconf            ext         php.ini-production   travis
buildconf.bat        EXTENSIONS  README.md            TSRM
CODING_STANDARDS.md  LICENSE     README.REDIST.BINS   UPGRADING
configure            main        run-tests.php        UPGRADING.INTERNALS
configure.ac         NEWS        sapi                 win32
CONTRIBUTING.md      pear        scripts              Zend
[root@lnmp php-8.1.30]#

[root@lnmp php-8.1.30]# pwd
/usr/local/src/php-8.1.30
[root@lnmp php-8.1.30]# ./configure --prefix=/usr/local/php --with-config-file-path=/usr/local/php/etc --enable-fpm --with-fpm-user=www --with-fpm-group=www --with-mysqli=mysqlnd --with-pdo-mysql=mysqlnd --with-iconv --with-freetype --with-jpeg --with-zlib --enable-gd --with-external-gd --with-xpm --with-webp --enable-xml --disable-rpath --enable-bcmath --enable-shmop --enable-sysvsem --with-curl --enable-mbregex --enable-mbstring --enable-ftp --with-openssl --with-mhash --enable-sockets --enable-soap --without-pear --with-gettext  --enable-pcntl --with-sodium --enable-fileinfo

或者

[root@lnmp php-8.1.30]# ./configure \
  --prefix=/usr/local/php \
  --with-config-file-path=/usr/local/php/etc \
  --enable-fpm \
  --with-fpm-user=www \
  --with-fpm-group=www \
  \
  # 数据库相关
  --with-mysqli=mysqlnd \
  --with-pdo-mysql=mysqlnd \
  \
  # 字符与压缩
  --with-iconv \
  --with-zlib \
  \
  # 图像处理
  --with-freetype \
  --with-jpeg \
  --enable-gd \
  --with-external-gd \
  --with-xpm \
  --with-webp \
  \
  # 基础功能
  --enable-xml \
  --disable-rpath \
  --enable-bcmath \
  --enable-shmop \
  --enable-sysvsem \
  \
  # 网络与协议
  --with-curl \
  --enable-ftp \
  --with-openssl \
  --with-mhash \
  --enable-sockets \
  --enable-soap \
  \
  # 其他功能
  --without-pear \
  --with-gettext \
  --enable-pcntl \
  --with-sodium \
  --enable-fileinfo

make默认单核编译，可以通过make -j数字（核心数）
$(nproc) 会自动返回当前系统的 CPU 核心数，从而加速编译过程。
[root@lnmp php-8.1.30]# make -j$(nproc) && make install

cp /usr/local/src/php-8.1.30/php.ini-development /usr/local/php/etc/php.ini
cp /usr/local/php/etc/php-fpm.conf.default /usr/local/php/etc/php-fpm.conf
cp /usr/local/php/etc/php-fpm.d/www.conf.default /usr/local/php/etc/php-fpm.d/www.conf

vim /usr/local/php/etc/php-fpm.conf

------------- 修改如下 -------------
13 [global]
14 ; Pid file
15 ; Note: the default prefix is /usr/local/php/var
16 ; Default Value: none

17 pid = run/php-fpm.pid
...
99 daemonize = yes
注意事项：17、99行前面都有一个分号；必须要去除，因为在php-fpm.conf文件中，分号；代表注释！


vim /usr/local/php/etc/php-fpm.d/www.conf

------------- 修改如下 -------------
111 pm = dynamic 使用动态方式启动 # pm = static 使用静态方式启动
122 pm.max_children = 50 并发处理 50 个请求
127 pm.start_servers = 2 最开始启动的进程数量
132 pm.min_spare_servers = 1 备用的进程
137 pm.max_spare_servers = 3 最大可以启动的进程数量

---------------------------------------

配置 systemd 服务

cat >/usr/lib/systemd/system/php-fpm.service<<'EOF'
[Unit]
Description=PHP FastCGI Process Manager
After=network.target

[Service]
Type=forking
PIDFile=/usr/local/php/var/run/php-fpm.pid
ExecStart=/usr/local/php/sbin/php-fpm --fpm-config /usr/local/php/etc/php-fpm.conf
ExecReload=/bin/kill -USR2 $MAINPID
ExecStop=/bin/kill -QUIT $MAINPID
TimeoutStartSec=180
LimitNOFILE=65535
LimitNPROC=500
PrivateTmp=true
User=www
Group=www

[Install]
WantedBy=multi-user.target
EOF

chown -Rf www:www /usr/local/php/var

systemctl daemon-reload
systemctl start php-fpm
systemctl status php-fpm
systemctl enable php-fpm

注意：php-fpm在计算机中默认会运行9000端口！
[root@lnmp php-8.1.30]# systemctl status php-fpm
● php-fpm.service - PHP FastCGI Process Manager
     Loaded: loaded (/usr/lib/systemd/system/php-fpm.service; disabled; preset>
     Active: active (running) since Tue 2026-03-24 17:36:44 CST; 6s ago
    Process: 240618 ExecStart=/usr/local/php/sbin/php-fpm --fpm-config /usr/lo>
   Main PID: 240626 (php-fpm)
      Tasks: 3 (limit: 22927)
     Memory: 23.6M
        CPU: 47ms
     CGroup: /system.slice/php-fpm.service
             ├─240626 "php-fpm: master process (/usr/local/php/etc/php-fpm.con>
             ├─240627 "php-fpm: pool www"
             └─240628 "php-fpm: pool www"

Mar 24 17:36:44 lnmp.itcast.cn systemd[1]: Starting PHP FastCGI Process Manage>
Mar 24 17:36:44 lnmp.itcast.cn php-fpm[240626]: [24-Mar-2026 17:36:44] NOTICE:>
Mar 24 17:36:44 lnmp.itcast.cn php-fpm[240626]: [24-Mar-2026 17:36:44] NOTICE:>
Mar 24 17:36:44 lnmp.itcast.cn systemd[1]: Started PHP FastCGI Process Manager.
[root@lnmp php-8.1.30]# systemctl enable php-fpm
Created symlink /etc/systemd/system/multi-user.target.wants/php-fpm.service → /usr/lib/systemd/system/php-fpm.service.
[root@lnmp php-8.1.30]# netstat -pantul|grep php
tcp        0      0 127.0.0.1:9000          0.0.0.0:*               LISTEN      240626/php-fpm: mas
[root@lnmp php-8.1.30]#

echo 'export PATH=$PATH:/usr/local/php/bin' >> /etc/profile
source /etc/profile

[root@lnmp ~]# cat >/usr/lib/systemd/system/php-fpm.service<<'EOF'
[Unit]
Description=PHP FastCGI Process Manager
After=network.target

[Service]
Type=forking
PIDFile=/usr/local/php/var/run/php-fpm.pid
ExecStart=/usr/local/php/sbin/php-fpm --fpm-config /usr/local/php/etc/php-fpm.conf
ExecReload=/bin/kill -USR2 $MAINPID
ExecStop=/bin/kill -QUIT $MAINPID
TimeoutStartSec=180
LimitNOFILE=65535
LimitNPROC=500
PrivateTmp=true
User=www
Group=www

[Install]
WantedBy=multi-user.target
EOF
[root@lnmp ~]# cat /usr/lib/systemd/system/php-fpm.service
[Unit]
Description=PHP FastCGI Process Manager
After=network.target

[Service]
Type=forking
PIDFile=/usr/local/php/var/run/php-fpm.pid
ExecStart=/usr/local/php/sbin/php-fpm --fpm-config /usr/local/php/etc/php-fpm.conf
ExecReload=/bin/kill -USR2 $MAINPID
ExecStop=/bin/kill -QUIT $MAINPID
TimeoutStartSec=180
LimitNOFILE=65535
LimitNPROC=500
PrivateTmp=true
User=www
Group=www

[Install]
WantedBy=multi-user.target
[root@lnmp ~]# chown -Rf www:www /usr/local/php/var
[root@lnmp ~]# systemctl daemon-reload
[root@lnmp ~]# systemctl start php-fpm
[root@lnmp ~]# systemctl status php-fpm
● php-fpm.service - PHP FastCGI Process Manager
     Loaded: loaded (/usr/lib/systemd/system/php-fpm.service; disabled; preset>
     Active: active (running) since Sun 2025-12-14 11:45:07 CST; 3s ago
    Process: 205833 ExecStart=/usr/local/php/sbin/php-fpm --fpm-config /usr/lo>
   Main PID: 205836 (php-fpm)
      Tasks: 3 (limit: 48692)
     Memory: 23.6M
        CPU: 48ms
     CGroup: /system.slice/php-fpm.service
             ├─205836 "php-fpm: master process (/usr/local/php/etc/php-fpm.con>
             ├─205837 "php-fpm: pool www"
             └─205838 "php-fpm: pool www"

Dec 14 11:45:07 lnmp.itcast.cn systemd[1]: Starting PHP FastCGI Process Manage>
Dec 14 11:45:07 lnmp.itcast.cn php-fpm[205836]: [14-Dec-2025 11:45:07] NOTICE:>
Dec 14 11:45:07 lnmp.itcast.cn php-fpm[205836]: [14-Dec-2025 11:45:07] NOTICE:>
Dec 14 11:45:07 lnmp.itcast.cn systemd[1]: Started PHP FastCGI Process Manager.
[root@lnmp ~]# systemctl enable php-fpm
Created symlink /etc/systemd/system/multi-user.target.wants/php-fpm.service → /usr/lib/systemd/system/php-fpm.service.
[root@lnmp ~]# ss -ant|grep 9000
LISTEN 0      511         127.0.0.1:9000       0.0.0.0:*
[root@lnmp ~]# which php
/usr/bin/which: no php in (/root/.local/bin:/root/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/usr/local/nginx/sbin/:/usr/local/nginx/sbin/:/usr/local/mysql/bin:/usr/local/nginx/sbin/:/usr/local/mysql/bin:/usr/local/nginx/sbin/:/usr/local/mysql/bin)
[root@lnmp ~]# php -v
bash: php: command not found
[root@lnmp ~]# echo 'export PATH=$PATH:/usr/local/php/bin' >> /etc/profile
[root@lnmp ~]# source /etc/profile
[root@lnmp ~]# which php
/usr/local/php/bin/php
[root@lnmp ~]# php -v
PHP 8.1.30 (cli) (built: Dec 14 2025 11:22:59) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.1.30, Copyright (c) Zend Technologies
[root@lnmp ~]#

journalctl -u php-fpm -n 100 #-u 后面接着要排查的服务名称 -n 显示最后多少行的最新日志

<?php
      phpinfo();
?>

vim /usr/local/nginx/conf/nginx.conf
server {
        listen       80;
        server_name  localhost;
        root html;   # 整个server只保留一个root选项
        
        location / {
            index  index.html index.htm;
        }
        
        error_page   500 502 503 504  /50x.html;
        location = /50x.html {
        }

# pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
          #
          location ~ \.php$ {
             fastcgi_pass   127.0.0.1:9000;
             fastcgi_index  index.php;
             fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
             include        fastcgi_params;
         }

cd /usr/local/nginx
cp conf/nginx.conf conf/nginx.conf.bak

[root@lnmp nginx]# grep -Ev '#|^$' conf/nginx.conf
worker_processes  1;
events {
    worker_connections  1024;
}
http {
    include       mime.types;
    default_type  application/octet-stream;
    sendfile        on;
    keepalive_timeout  65;
    server {
        listen       80;
        server_name  localhost;
        location / {
            root   html;
            index  index.html index.htm;
        }
        error_page   500 502 503 504  /50x.html;
        location = /50x.html {
            root   html;
        }
    }
}
[root@lnmp nginx]#

[root@lnmp nginx]# grep -Ev '#|^$' conf/nginx.conf.bak > conf/nginx.conf
[root@lnmp nginx]# vim conf/nginx.conf
worker_processes  auto;
events {
    worker_connections  65535;
}
http {
    include       mime.types;
    default_type  application/octet-stream;
    sendfile        on;
    keepalive_timeout  65;
    server {
        listen       80;
        server_name  localhost;
        root html;   # 整个server只保留一个root选项
        
        location / {
            index  index.html index.htm;
        }
        
        error_page   500 502 503 504  /50x.html;
        location = /50x.html {
        }
    }
}

[root@lnmp nginx]# vim conf/nginx.conf
worker_processes  auto;
events {
    worker_connections  65535;
}
http {
    include       mime.types;
    default_type  application/octet-stream;
    sendfile        on;
    keepalive_timeout  65;
    server {
        listen       80;
        server_name  localhost;
        root html;   # 整个server只保留一个root选项
        
        location / {
            index  index.html index.htm;
        }
        
        ------------------ 分割线 --------------------
        location ~ \.php$ {
                fastcgi_pass   127.0.0.1:9000;
                fastcgi_index  index.php;
                fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
                include        fastcgi_params;
        }
        ------------------ 分割线 --------------------
        
        error_page   500 502 503 504  /50x.html;
        location = /50x.html {
        }
    }
}


注意：
    $document_root：指代我们的项目目录，这里就是root html指定html文件夹！
    $fastcgi_script_name：指代url地址中请求的.php文件

[root@lnmp nginx]# nginx -t
nginx: the configuration file /usr/local/nginx/conf/nginx.conf syntax is ok
nginx: configuration file /usr/local/nginx/conf/nginx.conf test is successful
[root@lnmp nginx]# nginx -s reload

[root@lnmp nginx]# vim /usr/local/nginx/html/demo.php
<?php
     phpinfo();
?>

[root@lnmp ~]# ss -ant
State   Recv-Q  Send-Q    Local Address:Port      Peer Address:Port   Process
LISTEN  0       511           127.0.0.1:9000           0.0.0.0:*
LISTEN  0       128             0.0.0.0:22             0.0.0.0:*
LISTEN  0       511             0.0.0.0:80             0.0.0.0:*
ESTAB   0       0        192.168.88.101:22        192.168.88.1:11621
ESTAB   0       48       192.168.88.101:22        192.168.88.1:3840
LISTEN  0       70                    *:33060                *:*
LISTEN  0       128                [::]:22                [::]:*
LISTEN  0       151                   *:3306                 *:*
[root@lnmp ~]# netstat -pantul
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 127.0.0.1:9000          0.0.0.0:*               LISTEN      205836/php-fpm: mas
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      975/sshd: /usr/sbin
tcp        0      0 0.0.0.0:80              0.0.0.0:*               LISTEN      38472/nginx: master
tcp        0      0 192.168.88.101:22       192.168.88.1:11621      ESTABLISHED 205946/sshd: root [
tcp        0    208 192.168.88.101:22       192.168.88.1:3840       ESTABLISHED 1726/sshd: root [pr
tcp6       0      0 :::33060                :::*                    LISTEN      38676/mysqld
tcp6       0      0 :::22                   :::*                    LISTEN      975/sshd: /usr/sbin
tcp6       0      0 :::3306                 :::*                    LISTEN      38676/mysqld
udp        0      0 127.0.0.1:323           0.0.0.0:*                           895/chronyd
udp6       0      0 ::1:323                 :::*                                895/chronyd
[root@lnmp ~]# ss -pantul
Netid  State    Recv-Q   Send-Q     Local Address:Port      Peer Address:Port  Process
udp    UNCONN   0        0              127.0.0.1:323            0.0.0.0:*      users:(("chronyd",pid=895,fd=5))
udp    UNCONN   0        0                  [::1]:323               [::]:*      users:(("chronyd",pid=895,fd=6))
tcp    LISTEN   0        511            127.0.0.1:9000           0.0.0.0:*      users:(("php-fpm",pid=205838,fd=5),("php-fpm",pid=205837,fd=5),("php-fpm",pid=205836,fd=7))
tcp    LISTEN   0        128              0.0.0.0:22             0.0.0.0:*      users:(("sshd",pid=975,fd=3))
tcp    LISTEN   0        511              0.0.0.0:80             0.0.0.0:*      users:(("nginx",pid=205929,fd=6),("nginx",pid=205928,fd=6),("nginx",pid=205927,fd=6),("nginx",pid=205926,fd=6),("nginx",pid=38472,fd=6))
tcp    LISTEN   0        70                     *:33060                *:*      users:(("mysqld",pid=38676,fd=21))
tcp    LISTEN   0        128                 [::]:22                [::]:*      users:(("sshd",pid=975,fd=4))
tcp    LISTEN   0        151                    *:3306                 *:*      users:(("mysqld",pid=38676,fd=24))
[root@lnmp ~]#

[root@lnmp ~]# systemctl stop php-fpm
[root@lnmp ~]# cd /usr/local/src/php-8.1.30/
[root@lnmp php-8.1.30]# make distclean
find . -name \*.gcno -o -name \*.gcda | xargs rm -f
find . -name \*.lo -o -name \*.o -o -name \*.dep | xargs rm -f
find . -name \*.la -o -name \*.a | xargs rm -f
find . -name \*.so | xargs rm -f
find . -name .libs -a -type d|xargs rm -rf
rm -f libphp.la sapi/cli/php sapi/cgi/php-cgi  sapi/fpm/php-fpm  modules/* libs/*
rm -f ext/opcache/jit/zend_jit_x86.c
rm -f ext/opcache/jit/zend_jit_arm64.c
rm -f ext/opcache/minilua
rm -f Makefile config.cache config.log config.status Makefile.objects Makefile.fragments libtool main/php_config.h main/internal_functions_cli.c main/internal_functions.c Zend/zend_dtrace_gen.h Zend/zend_dtrace_gen.h.bak Zend/zend_config.h
rm -f main/build-defs.h scripts/phpize
rm -f ext/date/lib/timelib_config.h ext/mbstring/libmbfl/config.h ext/oci8/oci8_dtrace_gen.h ext/oci8/oci8_dtrace_gen.h.bak
rm -f scripts/man1/phpize.1 scripts/php-config scripts/man1/php-config.1 sapi/cli/php.1 sapi/cgi/php-cgi.1 sapi/phpdbg/phpdbg.1 ext/phar/phar.1 ext/phar/phar.phar.1
rm -f sapi/fpm/php-fpm.conf sapi/fpm/init.d.php-fpm sapi/fpm/php-fpm.service sapi/fpm/php-fpm.8 sapi/fpm/status.html
rm -f ext/phar/phar.phar ext/phar/phar.php
if test "/usr/local/src/php-8.1.30" != "/usr/local/src/php-8.1.30"; then \
  rm -f ext/phar/phar/phar.inc; \
fi
/usr/bin/grep -E define'.*include/php' /usr/local/src/php-8.1.30/configure | /usr/bin/sed 's/.*>//'|xargs rm -f
[root@lnmp php-8.1.30]# cd ..
[root@lnmp src]# rm -rf php-8.1.30/
[root@lnmp src]# sed -i '/php/d' /etc/profile
[root@lnmp src]# rm -rf /usr/local/php/

[root@lnmp ~]# dnf remove -y php*

[root@lnmp ~]# dnf install git -y  # 先安装git工具

[root@lnmp ~]# mkdir /data && cd /data # 创建一个/data目录，准备存放CRMEB源代码

[root@lnmp data]# git clone https://gitee.com/ZhongBangKeJi/CRMEB.git # 克隆CRMEB源代码

# 如果是 dnf 安装的 nginx，用户权限改成 nginx:nginx
# 如果是 编译 安装的 nginx，用户权限改成 www:www
[root@lnmp ~]# chown -Rf www:www /data/CRMEB/crmeb
[root@lnmp ~]# chmod 755 -Rf /data/CRMEB/crmeb

dnf install epel-release -y

dnf install -y https://rpms.remirepo.net/enterprise/remi-release-9.rpm

dnf module enable php:remi-7.4 -y

dnf install php -y

dnf install php-cli php-fpm php-mysqlnd php-xml php-mbstring php-json php-common php-opcache php-bcmath php-gd -y

php -v

hash -r          # 让 bash 忘掉已缓存的路径
php -v           # 现在就会用 /usr/bin/php

[root@lnmp ~]# vim /etc/php-fpm.d/www.conf
 20 ; Unix user/group of processes
 21 ; Note: The user is mandatory. If the group is not set, the default user's group
 22 ;       will be used.
 23 ; RPM: apache user chosen to provide access to the same directories as httpd
 24 user = www        # 如果你是编译安装的 nginx，就改成 www；如果你是 dnf 安装的 nginx，那就是 nginx
 25 ; RPM: Keep a group allowed to write in log dir.
 26 group = www       # 如果你是编译安装的nginx，就改成 www；如果你是 dnf 安装的 nginx，那就是 nginx
 27
 28 ; The address on which to accept FastCGI requests.
 29 ; Valid syntaxes are:
 30 ;   'ip.add.re.ss:port'    - to listen on a TCP socket to a specific IPv4 address on
 31 ;                            a specific port;
 32 ;   '[ip:6:addr:ess]:port' - to listen on a TCP socket to a specific IPv6 address on
 33 ;                            a specific port;
 34 ;   'port'                 - to listen on a TCP socket to all addresses
 35 ;                            (IPv6 and IPv4-mapped) on a specific port;
 36 ;   '/path/to/unix/socket' - to listen on a unix socket.
 37 ; Note: This value is mandatory.
 38 listen = 0.0.0.0:9000    # 绑定9000端口号，这样即使 PHP-FPM 和 Nginx 不在同一台机器也可以通信

[root@lnmp ~]# systemctl start php-fpm
[root@lnmp ~]# systemctl status php-fpm
[root@lnmp ~]# systemctl enable php-fpm

[root@lnmp ~]# ss -nlutp | grep 9000
[root@lnmp ~]# ss -ant | grep 9000
[root@lnmp ~]# netstat -pantul|grep 9000
[root@lnmp ~]# ps aux|grep php
[root@lnmp ~]# ps -ef|grep php

[root@lnmp ~]# find / -name nginx.conf
/usr/lib/sysusers.d/nginx.conf
/usr/local/nginx/conf/nginx.conf
/data/CRMEB/readme/nginx.conf
[root@lnmp ~]# cd /usr/local/nginx/conf/
[root@lnmp conf]# ls
fastcgi.conf            mime.types          scgi_params.default
fastcgi.conf.default    mime.types.default  uwsgi_params
fastcgi_params          nginx.conf          uwsgi_params.default
fastcgi_params.default  nginx.conf.bak      win-utf
koi-utf                 nginx.conf.default
koi-win                 scgi_params
[root@lnmp conf]# cat nginx.conf
worker_processes  auto;
events {
    worker_connections  65535;
}
http {
    include       mime.types;
    default_type  application/octet-stream;
    sendfile        on;
    keepalive_timeout  65;
    server {
        listen       80;
        server_name  localhost;
        root   html;
        location / {
            index  index.html index.htm;
        }

                location ~ \.php$ {
                fastcgi_pass   127.0.0.1:9000;
                fastcgi_index  index.php;
                fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
                include        fastcgi_params;
        }

        error_page   500 502 503 504  /50x.html;
        location = /50x.html {
        }
    }
}
[root@lnmp conf]# vim nginx.conf
[root@lnmp conf]# cat nginx.conf
worker_processes  auto;
events {
    worker_connections  65535;
}
http {
    include       mime.types;
    default_type  application/octet-stream;
    sendfile        on;
    keepalive_timeout  65;
    server {
        listen       80;
        server_name  localhost;
        root   html;
        location / {
            index  index.html index.htm;
        }

                location ~ \.php$ {
                fastcgi_pass   0.0.0.0:9000;
                fastcgi_index  index.php;
                fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
                include        fastcgi_params;
        }

        error_page   500 502 503 504  /50x.html;
        location = /50x.html {
        }
    }
}
[root@lnmp conf]#

[root@lnmp ~]# cd /etc/nginx
[root@lnmp conf]# grep -Ev '#|^$' nginx.conf.default  > nginx.conf
[root@lnmp conf]# vi nginx.cnf
  1 worker_processes  1;
  2 events {
  3     worker_connections  1024;
  4 }
  5 http {
  6     include       mime.types;
  7     default_type  application/octet-stream;
  8     sendfile        on;
  9     keepalive_timeout  65;
 10     server {
 11         listen       80;
 12         server_name  localhost;
 13         root html;                                # 暂定根目录为 html
 14
 15         location / {
 16             index  index.html index.htm;
 17         }
 18
 19         location ~ \.php$ {
 20             fastcgi_pass   0.0.0.0:9000;        # 绑定 PHP-FPM
 21             fastcgi_index  index.php;
 22             fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
 23             include        fastcgi_params;
 24         }
 25
 26         error_page   500 502 503 504  /50x.html;
 27         location = /50x.html {
 28             root   html;
 29         }
 30     }
 31 }

nginx -t
nginx -s reload

cat >/usr/local/nginx/html/demo.php<<EOF
<?php
      phpinfo();
?>
EOF

cat >/usr/share/nginx/html/demo.php<<EOF
<?php
      phpinfo();
?>
EOF

指定网站目录并配置伪静态

伪静态作用：
伪静态把“/index.php?s=xxx”这种带问号的动态地址伪装成“/xxx.html”的静态路径，让搜索引擎认、缓存认、用户也认，同时保证所有请求仍能悄悄交给 PHP 统一入口处理，既好看又不掉链子。

[root@lnmp ~]# vim /usr/local/nginx/conf/nginx.conf
   worker_processes  auto;
   events {
       worker_connections  65535;
   }
   http {
       include       mime.types;
       default_type  application/octet-stream;
       sendfile        on;
       keepalive_timeout  65;
      server {
          listen       80;
          server_name  localhost;
          root   /data/CRMEB/crmeb/public;                    # 配置CRMEB根目录
 
          location / {
              index  index.html index.htm index.php;        # 增加index.php首页
              if (!-e $request_filename) {                  # 伪静态处理
                  rewrite  ^(.*)$  /index.php?s=$1  last;
                  break;
               }
          }
 
 
          location ~ \.php$ {
                  # root           html;
                  fastcgi_pass   0.0.0.0:9000;            # 绑定 PHP-FPM
                  fastcgi_index  index.php;
                  fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
                  include        fastcgi_params;
          }
 
          error_page   500 502 503 504  /50x.html;
          location = /50x.html {
          }
      }
  }
[root@lnmp ~]# vim /usr/local/nginx/conf/nginx.conf
[root@lnmp ~]# cat /usr/local/nginx/conf/nginx.conf
worker_processes  auto;
events {
    worker_connections  65535;
}
http {
    include       mime.types;
    default_type  application/octet-stream;
    sendfile        on;
    keepalive_timeout  65;
    server {
        listen       80;
        server_name  localhost;
        root   /data/CRMEB/crmeb/public;

        location / {
            index  index.html index.htm index.php;
            if (!-e $request_filename) {
                  rewrite  ^(.*)$  /index.php?s=$1  last;
                  break;
               }
        }

        location ~ \.php$ {
                fastcgi_pass   0.0.0.0:9000;
                fastcgi_index  index.php;
                fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
                include        fastcgi_params;
        }

        error_page   500 502 503 504  /50x.html;
        location = /50x.html {
            root   html;
        }
    }
}
[root@lnmp ~]# nginx -t
nginx: the configuration file /usr/local/nginx/conf/nginx.conf syntax is ok
nginx: configuration file /usr/local/nginx/conf/nginx.conf test is successful
[root@lnmp ~]#

nginx -s reload

或者 

systemctl restart nginx

vim /etc/my.cnf
sql_mode=NO_ENGINE_SUBSTITUTION
[root@lnmp ~]# cat /etc/my.cnf
[mysqld]
port=3306
basedir=/export/server/mysql
datadir=/export/server/mysql/data
socket=/tmp/mysql.sock
character_set_server=utf8
collation-server=utf8_unicode_ci
[root@lnmp ~]# vim /etc/my.cnf
[root@lnmp ~]# cat /etc/my.cnf
[mysqld]
port=3306
basedir=/export/server/mysql
datadir=/export/server/mysql/data
socket=/tmp/mysql.sock
character_set_server=utf8
collation-server=utf8_unicode_ci
sql_mode=NO_ENGINE_SUBSTITUTION
[root@lnmp ~]#

systemctl restart mysqld
[root@lnmp ~]# systemctl restart mysqld
[root@lnmp ~]# systemctl status mysqld
● mysqld.service - MySQL Server
     Loaded: loaded (/etc/systemd/system/mysqld.service; enabled; preset: disabl>
     Active: active (running) since Thu 2025-12-11 21:18:56 CST; 4s ago
    Process: 213159 ExecStart=/export/server/mysql/bin/mysqld --daemonize --pid->
   Main PID: 213162 (mysqld)
      Tasks: 38 (limit: 48693)
     Memory: 369.5M
        CPU: 1.015s
     CGroup: /system.slice/mysqld.service
             └─213162 /export/server/mysql/bin/mysqld --daemonize --pid-file=/ex>

Dec 11 21:18:55 lnmp mysqld[213162]: 2025-12-11T13:18:55.505777Z 0 [System] [MY->
Dec 11 21:18:55 lnmp mysqld[213162]: 2025-12-11T13:18:55.510213Z 0 [Warning] [MY>
Dec 11 21:18:55 lnmp mysqld[213162]: 2025-12-11T13:18:55.510310Z 0 [Warning] [MY>
Dec 11 21:18:55 lnmp mysqld[213162]: 2025-12-11T13:18:55.525063Z 1 [System] [MY->
Dec 11 21:18:55 lnmp mysqld[213162]: 2025-12-11T13:18:55.798965Z 1 [System] [MY->
Dec 11 21:18:56 lnmp mysqld[213162]: 2025-12-11T13:18:56.064294Z 0 [Warning] [MY>
Dec 11 21:18:56 lnmp mysqld[213162]: 2025-12-11T13:18:56.064468Z 0 [System] [MY->
Dec 11 21:18:56 lnmp mysqld[213162]: 2025-12-11T13:18:56.093311Z 0 [System] [MY->
Dec 11 21:18:56 lnmp mysqld[213162]: 2025-12-11T13:18:56.093395Z 0 [System] [MY->
Dec 11 21:18:56 lnmp systemd[1]: Started MySQL Server.
[root@lnmp ~]# mysql -uroot -pMySQL@666
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.43 MySQL Community Server - GPL

Copyright (c) 2000, 2025, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

mysql>

mysql -uroot -pMySQL@666

[root@lnmp public]# pwd
/data/CRMEB/crmeb/public
[root@lnmp public]# ls
admin        install         product_migration.xlsx   static
assets       install.lock    README.md                statics
favicon.ico  mobile.html     robots.txt               upgrade
index.html   nginx.htaccess  router.php               uploads
index.php    pages           service_pay_result.html
[root@lnmp public]# rm -rf install
[root@lnmp public]# ls
admin        install.lock            README.md                statics
assets       mobile.html             robots.txt               upgrade
favicon.ico  nginx.htaccess          router.php               uploads
index.html   pages                   service_pay_result.html
index.php    product_migration.xlsx  static
[root@lnmp public]#

[root@lnmp ~]# mysql -uroot -pMySQL@666
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 228
Server version: 8.0.43 MySQL Community Server - GPL

Copyright (c) 2000, 2025, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| crmeb              |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

mysql> use crmeb
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-----------------------------------+
| Tables_in_crmeb                   |
+-----------------------------------+
| eb_agent_level                    |
| eb_agent_level_task               |
| eb_agent_level_task_record        |
| eb_agreement                      |
| eb_app_version                    |
| eb_article                        |
| eb_article_category               |
| eb_article_content                |
| eb_auxiliary                      |
| eb_cache                          |
| eb_capital_flow                   |
| eb_category                       |
| eb_delivery_service               |
| eb_division_agent_apply           |
| eb_diy                            |
| eb_express                        |
| eb_lang_code                      |
| eb_lang_country                   |
| eb_lang_type                      |
| eb_live_anchor                    |
| eb_live_goods                     |
| eb_live_room                      |
| eb_live_room_goods                |
| eb_luck_lottery                   |
| eb_luck_lottery_record            |
| eb_luck_prize                     |
| eb_member_card                    |
| eb_member_card_batch              |
| eb_member_right                   |
| eb_member_ship                    |
| eb_message_system                 |
| eb_other_order                    |
| eb_other_order_status             |
| eb_out_account                    |
| eb_out_interface                  |
| eb_page_categroy                  |
| eb_page_link                      |
| eb_qrcode                         |
| eb_routine_scheme                 |
| eb_shipping_templates             |
| eb_shipping_templates_free        |
| eb_shipping_templates_no_delivery |
| eb_shipping_templates_region      |
| eb_sms_record                     |
| eb_spread_apply                   |
| eb_store_activity                 |
| eb_store_advance                  |
| eb_store_bargain                  |
| eb_store_bargain_user             |
| eb_store_bargain_user_help        |
| eb_store_cart                     |
| eb_store_category                 |
| eb_store_combination              |
| eb_store_coupon_issue             |
| eb_store_coupon_issue_user        |
| eb_store_coupon_product           |
| eb_store_coupon_user              |
| eb_store_integral                 |
| eb_store_integral_order           |
| eb_store_integral_order_status    |
| eb_store_order                    |
| eb_store_order_cart_info          |
| eb_store_order_economize          |
| eb_store_order_invoice            |
| eb_store_order_refund             |
| eb_store_order_status             |
| eb_store_pink                     |
| eb_store_product                  |
| eb_store_product_attr             |
| eb_store_product_attr_result      |
| eb_store_product_attr_value       |
| eb_store_product_cate             |
| eb_store_product_coupon           |
| eb_store_product_description      |
| eb_store_product_label            |
| eb_store_product_label_cate       |
| eb_store_product_log              |
| eb_store_product_param            |
| eb_store_product_protection       |
| eb_store_product_relation         |
| eb_store_product_reply            |
| eb_store_product_rule             |
| eb_store_product_virtual          |
| eb_store_seckill                  |
| eb_store_seckill_time             |
| eb_store_service                  |
| eb_store_service_feedback         |
| eb_store_service_log              |
| eb_store_service_record           |
| eb_store_service_speechcraft      |
| eb_store_visit                    |
| eb_system_admin                   |
| eb_system_attachment              |
| eb_system_attachment_category     |
| eb_system_city                    |
| eb_system_config                  |
| eb_system_config_tab              |
| eb_system_crud                    |
| eb_system_crud_data               |
| eb_system_crud_list               |
| eb_system_event                   |
| eb_system_event_data              |
| eb_system_file                    |
| eb_system_file_info               |
| eb_system_group                   |
| eb_system_group_data              |
| eb_system_log                     |
| eb_system_menus                   |
| eb_system_notice                  |
| eb_system_notice_admin            |
| eb_system_notification            |
| eb_system_pem                     |
| eb_system_role                    |
| eb_system_route                   |
| eb_system_route_cate              |
| eb_system_sign_reward             |
| eb_system_storage                 |
| eb_system_store                   |
| eb_system_store_staff             |
| eb_system_ticket                  |
| eb_system_timer                   |
| eb_system_user_level              |
| eb_upgrade_log                    |
| eb_user                           |
| eb_user_address                   |
| eb_user_bill                      |
| eb_user_brokerage                 |
| eb_user_brokerage_frozen          |
| eb_user_cancel                    |
| eb_user_enter                     |
| eb_user_extract                   |
| eb_user_friends                   |
| eb_user_group                     |
| eb_user_invoice                   |
| eb_user_label                     |
| eb_user_label_relation            |
| eb_user_level                     |
| eb_user_money                     |
| eb_user_notice                    |
| eb_user_notice_see                |
| eb_user_recharge                  |
| eb_user_search                    |
| eb_user_sign                      |
| eb_user_spread                    |
| eb_user_visit                     |
| eb_wechat_key                     |
| eb_wechat_media                   |
| eb_wechat_message                 |
| eb_wechat_news_category           |
| eb_wechat_qrcode                  |
| eb_wechat_qrcode_cate             |
| eb_wechat_qrcode_record           |
| eb_wechat_reply                   |
| eb_wechat_user                    |
+-----------------------------------+
154 rows in set (0.00 sec)

mysql>

cd /data/CRMEB/crmeb
cat app/services/system/admin/SystemAdminServices.php | grep -A 15 "verifyLogin\|passwordHash"|grep password

# === 第1步：生成 bcrypt 哈希（把 admin2026 换成你要的密码）===
cd /data/CRMEB/crmeb && php -r "echo password_hash('admin2026', PASSWORD_BCRYPT) . PHP_EOL;"

# === 第2步：更新数据库（把单引号里的哈希替换成上面输出的）===
mysql -u root -pMySQL@666 -e "USE crmeb; UPDATE eb_system_admin SET pwd = '\$2y\$10\$xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' WHERE account = 'admin';"

# === 第3步：清缓存 ===
rm -rf /data/CRMEB/crmeb/runtime/* && systemctl restart php-fpm

# === 第4步：查看密码是否改成功 ===
mysql -u root -pMySQL@666 -D crmeb -e "SELECT account, pwd, status, is_del FROM eb_system_admin WHERE account = 'admin';"

# === 第5步：清除浏览器缓存再登录 ===
按 Ctrl + Shift + Delete 清除浏览器缓存，访问 http://IP地址/admin，用 admin / admin2026 登录。

[root@lnmp ~]# mkdir -p /usr/local/nginx/conf/conf.d
[root@lnmp ~]# vim /usr/local/nginx/conf/nginx.conf
[root@lnmp ~]# cat /usr/local/nginx/conf/nginx.conf
worker_processes  auto;
events {
    worker_connections  65535;
}
http {
    include       mime.types;
    default_type  application/octet-stream;
    include /usr/local/nginx/conf/conf.d/*.conf;
    sendfile        on;
    keepalive_timeout  65;
    server {
        listen       80;
        server_name  localhost;
        root   /data/CRMEB/crmeb/public;

        location / {
            index  index.html index.htm index.php;
            if (!-e $request_filename) {
                  rewrite  ^(.*)$  /index.php?s=$1  last;
                  break;
               }
        }

        location ~ \.php$ {
                fastcgi_pass   0.0.0.0:9000;
                fastcgi_index  index.php;
                fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
                include        fastcgi_params;
        }

        error_page   500 502 503 504  /50x.html;
        location = /50x.html {
            root   html;
        }
    }
}
[root@lnmp ~]# ls -dl /usr/local/nginx/conf/conf.d/
drwxr-xr-x 2 root root 6 Mar 25 11:23 /usr/local/nginx/conf/conf.d/
[root@lnmp ~]# chown www:www /usr/local/nginx/conf/conf.d
[root@lnmp ~]# ls -dl /usr/local/nginx/conf/conf.d/
drwxr-xr-x 2 www www 6 Mar 25 11:23 /usr/local/nginx/conf/conf.d/
[root@lnmp ~]# vim /usr/local/nginx/conf/conf.d/game_2026.conf
[root@lnmp ~]# cat /usr/local/nginx/conf/conf.d/game_2026.conf
server {
    listen       2026;
    server_name  localhost;

    root   /data/games;
    index  index.html;

    location / {
        try_files $uri $uri/ /index.html;
    }

    # 静态资源缓存优化
    location ~* \.(js|css|png|jpg|jpeg|gif|ico|svg|woff|ttf)$ {
        expires 7d;
        access_log off;
    }

    # 禁止访问隐藏文件
    location ~ /\. {
        deny all;
    }
}
[root@lnmp ~]# mkdir -p /data/games
[root@lnmp ~]# ls -dl /data/games/
drwxr-xr-x 2 root root 6 Mar 25 11:25 /data/games/
[root@lnmp ~]# chown -Rf www:www /data/games/
drwxr-xr-x 2 www www 6 Mar 25 11:25 /data/games/
[root@lnmp ~]# ls -dl /data/games/
drwxr-xr-x 2 www www 24 Mar 25 11:27 /data/games/
[root@lnmp ~]# nginx -t
nginx: the configuration file /usr/local/nginx/conf/nginx.conf syntax is ok
nginx: configuration file /usr/local/nginx/conf/nginx.conf test is successful
[root@lnmp ~]# nginx -s reload
[root@lnmp ~]# echo "games test" > /data/games/index.html
[root@lnmp ~]# cat /data/games/index.html
games test
[root@lnmp ~]#

[root@lnmp ~]# cd /data/games/
[root@lnmp games]# ls
index.html
[root@lnmp games]# rm -rf *
[root@lnmp games]# mv /root/jaking-cloud-platform.tar.gz ./
[root@lnmp games]# ls
jaking-cloud-platform.tar.gz
[root@lnmp games]# tar xf jaking-cloud-platform.tar.gz
[root@lnmp games]# ls
404.html  css     index.html                    js    screenshots
backup    images  jaking-cloud-platform.tar.gz  link  yxmb
[root@lnmp games]# netstat -pantul|grep 2026
tcp        0      0 0.0.0.0:2026            0.0.0.0:*               LISTEN      949/nginx: master p
[root@lnmp games]#

[root@lnmp html]# cat /usr/local/nginx/conf/nginx.conf
worker_processes  auto;
events {
    worker_connections  65535;
}
http {
    include       mime.types;
    default_type  application/octet-stream;
    sendfile        on;
    keepalive_timeout  65;
    server {
        listen       80;
        server_name  192.168.88.101;
        root   /data/CRMEB/crmeb/public;

        location / {
            index  index.html index.htm index.php;
            if (!-e $request_filename) {
                  rewrite  ^(.*)$  /index.php?s=$1  last;
                  break;
               }
        }

        location ~ \.php$ {
                fastcgi_pass   0.0.0.0:9000;
                fastcgi_index  index.php;
                fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
                include        fastcgi_params;
        }

        error_page   500 502 503 504  /50x.html;
        location = /50x.html {
        #    root   html;
        }
    }
   server {
        listen 8080;
        server_name 192.168.88.101;
        root /usr/local/nginx/html/itheimadevops;

        error_page   500 502 503 504  /50x.html;
        location = /50x.html {
        #   root   html;
        index index.html index.htm;
        }
    }

}
[root@lnmp html]#