CentOS7+apache+php7+mysql5.7配置教程详解
yumupgrade yuminstallnet-tools
安装apache
关闭SELinux
编辑器打开etc/selinux/config文件,找到SELINUX=enforcing字段,将其改成SELINUX=disabled,并重启设备。
yum-yinstallhttpdmod_ssl
配置防火墙
firewall-cmd--permanent--add-port=80/tcp firewall-cmd--permanent--add-port=443/tcp firewall-cmd--reload
开机启动
systemctlstarthttpd systemctlenablehttpd
终端输入如下指令检查httpd的运行状态
sudosystemctlstatushttpd
安装PHP7
添加源
rpm-Uvhhttps://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm rpm-Uvhhttps://mirror.webtatic.com/yum/el7/webtatic-release.rpm
安装
yuminstallphp70w
安装mysql5.7
1.安装wget
yum-yinstallwget
2.安装源
wgethttp://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm rpm-ivhmysql57-community-release-el7-8.noarch.rpm
3.安装mysql
yuminstallmysql-server
4.启动mysql服务
systemctlstartmysqld
5.查看MySQL的启动状态
systemctlstatusmysqld
6.开机启动
systemctlenablemysqld systemctldaemon-reload
7.修改root本地登录密码
查找mysql生成的随机密码
grep'temporarypassword'/var/log/mysqld.log mysql-uroot-p
修改密码,注意:mysql5.7默认安装了密码安全检查插件(validate_password),默认密码检查策略要求密码必须包含:大小写字母、数字和特殊符号,并且长度不能少于8位。否则会提示ERROR1819(HY000):Yourpassworddoesnotsatisfythecurrentpolicyrequirements错误
ALTERUSER'root'@'localhost'IDENTIFIEDBY'MyNewPass4!';
8.配置默认编码为utf8
修改/etc/my.cnf配置文件,在[mysqld]下添加编码配置
[mysqld] character_set_server=utf8 init_connect='SETNAMESutf8'
9.配置mysql远程连接
mysql-uroot-p usemysql; Grantallon*.*to'root'@'%'identifiedby'root用户的密码'withgrantoption; flushprivileges;
然后用以下命令查看哪些用户和host可以访问,%代表任意ip地址
selectuser,hostfromuser;
防火墙添加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.servicemysqldrestart后,即可直接用mysql进入
3.
mysql>updatemysql.usersetauthentication_string=password('123qwe')whereuser='root'andHost='localhost'; mysql>flushprivileges; mysql>quit;
将/etc/my.cnf文件还原,重新启动mysql:servicemysqlrestart,这个时候可以使用mysql-uroot-p'123qwe'进入了
mysql>SETPASSWORD=PASSWORD('newpasswd');设置新密码
总结
以上所述是小编给大家介绍的CentOS7+apache+php7+mysql5.7配置教程详解,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对毛票票网站的支持!