# 安装apache httpd+扩展服务yum -y install httpd httpd-manual mod_ssl mod_perl mod_auth_mysql
# 启动apache 默认80端口systemctl start httpd.service

# 卸载mariadb相关依赖包 --nodeps不检查依赖关系rpm -e mariadb-libs --nodeps# 安装mysql5.7版本yum install -y https://mirrors.aliyun.com/mysql/MySQL-5.7/mysql-community-common-5.7.35-1.el7.x86_64.rpm
yum install -y https://mirrors.aliyun.com/mysql/MySQL-5.7/mysql-community-libs-5.7.35-1.el7.x86_64.rpm
yum install -y https://mirrors.aliyun.com/mysql/MySQL-5.7/mysql-community-libs-compat-5.7.35-1.el7.x86_64.rpm
yum install -y https://mirrors.aliyun.com/mysql/MySQL-5.7/mysql-community-client-5.7.35-1.el7.x86_64.rpm
yum install -y https://mirrors.aliyun.com/mysql/MySQL-5.7/mysql-community-server-5.7.35-1.el7.x86_64.rpm
# 查看安装mysql版本mysql -V

# 启动MySQLsystemctl start mysqld.service
重置mysql密码
# 从mysql启动日志中获取默认初始密码grep"password" /var/log/mysqld.log
# 登陆mysqlmysql -uroot-p# 输入初始密码# 修改mysql安全策略,将校验密码级别改为低级别,只校验密码长度不低于8位set global validate_password_policy=0;
# 重置密码ALTER USER 'root'@'localhost' IDENTIFIED BY '12345678';
# 赋权GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '12345678';
#退出exit

yum -y install php php-mysql gd php-gd gd-devel php-xml php-common php-mbstring php-ldap php-pear php-xmlrpc php-imap

echo"<?php phpinfo(); ?>" > /var/www/html/phpinfo.php

systemctl restart httpd

mkdir-p /var/www/html/phpmyadmin

# 下载phpadmin压缩包 --no-check-certificate 不检查证书wget--no-check-certificate https://files.phpmyadmin.net/phpMyAdmin/4.0.10.20/phpMyAdmin-4.0.10.20-all-languages.zip
# 下载 unzip 解压软件yum install -y unzip
# 解压phpAdmin压缩包unzip phpMyAdmin-4.0.10.20-all-languages.zip
# 复制phpAdmin相关文件到我们创建好的php工作目录mv phpMyAdmin-4.0.10.20-all-languages/*  /var/www/html/phpmyadmin

rpm -Uvh  http://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

# --nogpgcheck 禁掉GPG验证检查yum -y install mysql-community-server --nogpgcheck# 查看mysql版本mysql -V

# 设置开机自启并立即启动systemctl enabled mysqld --now

# 获取mysql初始密码grep'temporary password' /var/log/mysqld.log
# 进行安全性一系列配置命令mysql_secure_installation
# 首先就需要重置root账号密码,先校验初始密码,在输入两次root密码 新密码因为没设置密码安全级别,默认最高级别 大小写字母+数字+特殊符号 长度>8Enter password for user root: 
The existing password for the user account root has expired. Please set a new password.
New password: 
Re-enter new password: 
The 'validate_password' plugin is installed on the server.
The subsequent steps will run with the existing configuration
of the plugin.
Using existing password for root.
# 接下来就是安全性的设置 是否修改root账号密码,不修改了我们就用刚才设置的新密码 输入NChange the password for root ? ((Press y|Y for Yes, any other key for No) 
# 是否删除匿名用户 删除即可Remove anonymous users? (Press y|Y for Yes, any other key for No) : Y
# 禁止root账号远程登陆,只能通过本机登陆 安全起见Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Y
# 删除mysql安装自带的一个test库,这个库任何应用都能访问 主要用于安装测试.Remove test database and access to it? (Press y|Y for Yes, any other key for No) : Y
# 刷新权限Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y
接下来新建用户,新建用户需要登陆到mysql中
我们使用root账号本机登陆
mysql -uroot-p# 输入刚才设置的密码# 创建用户,设置用户密码create user 'dms'@'%' identified by 'PASSword123!';
# 授权访问哪些库 并允许此用户通过任何ip地址连接mysqlgrant all privileges on *.* to 'dms'@'%'with grant option;
# 刷新权限flush privileges;