Centos7.8服务器搭建LNMP环境

查看主机是否安装了yum工具：

rpm -qa | grep yum

yum --version

sudo yum install -y epel-release
sudo yum -y update

sudo yum install -y nginx

配置文件：/etc/nginx/nginx.conf
自定义配置文件目录：/etc/nginx/conf.d/*.conf
默认目录网站：/usr/share/nginx/html

# 添加存储库
# 上一步已添加了epel存储库，这里可以不用执行
# sudo yum -y install https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
sudo yum -y install https://rpms.remirepo.net/enterprise/remi-release-7.rpm

# 启用PHP 7.4 Remi存储库并在CentOS 7上安装PHP 7.4：
sudo yum -y install yum-utils
sudo yum-config-manager --enable remi-php74

sudo yum update
sudo yum install php php-cli

# 命令安装其他软件包
sudo yum install php-xxx
例：sudo yum install php  php-cli php-fpm php-mysqlnd php-zip php-devel php-gd php-mcrypt php-mbstring php-curl php-xml php-pear php-bcmath php-json

# 查看php版本
php -v

# 查看已安装的PHP模块
php -m

# 相关配置
/etc/php.ini
/etc/php-fpm.conf
/etc/php.d
/etc/php-fpm.d
  

# 添加MySQL Yum存储库
#（这里安装的是mysql80，本想安装mysql57，由于执行了这一步，导致与下方的mysql57冲突）
#sudo rpm -Uvh https://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm

# 下载mysql并yum安装
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql-community-server

# 提示：mysql-community-common-5.7.43-1.el7.x86_64.rpm 的公钥尚未安装
# 失败的软件包是：mysql-community-common-5.7.43-1.el7.x86_64
# GPG  密钥配置为：file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
解决：
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
yum -y install mysql-community-server

启动mysql：systemctl start  mysqld.service
停止mysql：systemctl stop mysqld.service
查看mysql状态：systemctl status mysqld.service


因执行了mysql80的安装导致下方改为mysql57的时候出现冲突，
可通过rpm -qa | grep mysql查看安装的mysql文件包，
# rpm -qa | grep mysql
# php-mysqlnd-7.4.33-8.el7.remi.x86_64
# mysql80-community-release-el7-3.noarch
删除刚刚的mysql80包：rpm -e --nodeps mysql80-community-release-el7-3.noarch

解决：忘记登录mysql的密码：
停止mysql服务：systemctl stop mysqld.service
修改配置文件：/etc/my.cnf，在[mysqld]最后添加：skip-grant-tables并保存
mysql -u root -p 回车，无需输入密码，直接回车，即可登录
查看相关账号信息及密码：
use mysql;
SELECT host,user,Grant_priv,Super_priv,authentication_string,password_expired FROM user;
修改root用户密码：update user set authentication_string=password("admin12345") where user="root";

错误：ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
修改密码即可：alter user 'root'@'localhost' identified by '12345';
错误：ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
set global validate_password_policy=0;
再次执行修改密码：
alter user 'root'@'localhost' identified by '12345';

新建用户admin，密码设置为123456，可以操作所有数据库，并可远程连接：
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' IDENTIFIED BY '123456.' WITH GRANT OPTION;