关防火墙:
systemctl stop firewalld.service && systemctl disable firewalld
sed -i '/SELINUX/s/enforcing/disabled/' /etc/selinux/config
安装mysql:
yum -y install wget wget https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm rpm -ivh mysql57-community-release-el7-8.noarch.rpm(安装MySQL) cd /etc/yum.repos.d/ rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022(安装MySQL的新密钥) yum -y install mysql-server systemctl start mysqld
修改初始密码:
grep 'temporary password' /var/log/mysqld.log mysql -uroot -p
set global validate_password_policy=LOW;(密码校验强度改为低风险) set global validate_password_length=5;(修改MySQL的密码长度) ALTER USER 'root'@'localhost' IDENTIFIED BY 'admin'; (修改MySQL的密码) exit
修改访问权限:
mysql -uroot -padmin
use mysql; select Host,User from user; update user set Host='%' where User='root';(修改为允许任何地址访问) flush privileges;(刷新权限) exit
systemctl restart mysqld
安装php:
yum -y install php php-devel systemctl restart httpd.service
ip a(可用ip地址打开浏览器页面) vi /var/www/html/1.php
<?php phpinfo(); ?>
安装php的扩展:
yum -y install php-mysql php-gd php-imap php-ldap php-odbc php-pear php-xml php-xmlrpc
systemctl restart httpd.service
vi /var/www/html/phpmysqltest.php
<?php $con = mysql_connect("localhost","root","admin"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("mysql", $con); $result = mysql_query("SELECT * FROM user"); while($row = mysql_fetch_array($result)) { echo $row['User'] . " " . $row['Password'] . " " . $row['Host']; echo "<br />"; } mysql_close($con); ?>
错误:
错误原因:"localhost","root","admin"写出"192.168.1.24","root","root",忘记修改