Detailed explanation of the installation and configuration of apache, php7 and mysql5.7 in CentOS7

This article mainly introduces the installation and configuration code of apache, php7 and mysql5.7 in the CentOS7 server. Friends who need it can refer to it

The configuration code of apache, php7 and mysql5.7 in the CentOS7 server is as follows Shown:

yum upgrade
yum install net-tools

Install apache

关闭SELinux
编辑器打开 etc/selinux/config 文件，找到 SELINUX=enforcing 字段，将其改成 SELINUX=disabled ，并重启设备。
yum -y install httpd mod_ssl
配置防火墙
firewall-cmd --permanent --add-port=80/tcp
firewall-cmd --permanent --add-port=443/tcp
firewall-cmd --reload
开机启动
systemctl start httpd
systemctl enable httpd
终端输入如下指令检查httpd的运行状态
sudo systemctl status httpd

Install PHP7

添加源
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm
安装
yum install php70w

Install mysql5.7

1.安装wget
  yum -y install wget
2.安装源
  wget https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
  rpm -ivh mysql57-community-release-el7-8.noarch.rpm
3.安装mysql
  yum install mysql-server
4.启动mysql服务
  systemctl start mysqld
5.查看MySQL的启动状态
  systemctl status mysqld
6.开机启动
  systemctl enable mysqld
  systemctl daemon-reload
7.修改root本地登录密码
  查找mysql生成的随机密码
  grep 'temporary password' /var/log/mysqld.log
  mysql -uroot -p
  修改密码，注意：mysql5.7默认安装了密码安全检查插件（validate_password），默认密码检查策略要求密码必须包含：大小写字母、数字和特殊符号，并且长度不能少于8位。否则会提示ERROR 1819 (HY000): Your password does not satisfy the current policy requirements错误
  ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!'; 
8.配置默认编码为utf8
  修改/etc/my.cnf配置文件，在[mysqld]下添加编码配置
  [mysqld]
  character_set_server=utf8
  init_connect='SET NAMES utf8'
9.配置mysql远程连接
  mysql -uroot -p
  use mysql;
  Grant all on *.* to 'root'@'%' identified by 'root用户的密码' with grant option;
flush privileges;
然后用以下命令查看哪些用户和host可以访问，%代表任意ip地址
select user,host from user;
防火墙添加3306端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
10.mysql忘记密码
1.修改MySQL的配置文件（默认为/etc/my.cnf）,在[mysqld]下添加一行skip-grant-tables
2.service mysqld restart后，即可直接用mysql进入
3.mysql> update mysql.user set authentication_string=password('123qwe') where user='root' and Host = 'localhost';
  mysql> flush privileges;
  mysql> quit;
 将/etc/my.cnf文件还原，重新启动mysql:service mysql restart,这个时候可以使用mysql -u root -p'123qwe'进入了
 mysql>SET PASSWORD = PASSWORD('newpasswd'); 设置新密码

Summary

The above is the detailed content of Detailed explanation of the installation and configuration of apache, php7 and mysql5.7 in CentOS7. For more information, please follow other related articles on the PHP Chinese website!