学习搭建LAMP

学习搭建LAMP
检查linux系统环境
关闭防火墙，开启自启关闭防火墙，selinux

[root@gujipeng ~]# 
[root@gujipeng ~]# iptables -F
[root@gujipeng ~]# systemctl stop firewalld
[root@gujipeng ~]# systemctl disable firewalld
[root@gujipeng ~]# getenforce
Disabled

安装httpd软件

[root@gujipeng ~]# yum install httpd

启动httpd服务

[root@gujipeng ~]# systemctl start httpd 
[root@gujipeng ~]# systemctl status httpd
[root@gujipeng ~]# systemctl status httpd
● httpd.service - The Apache HTTP Server
   Loaded: loaded (/usr/lib/systemd/system/httpd.service; enabled; vendor preset: disabled)
   Active: active (running) since Sun 2020-09-06 18:15:16 CST; 31min ago

配置apache文件主配置文件/etc/httpd/conf/httpd.conf

[root@gujipeng ~]# vim /etc/httpd/conf/httpd.conf 
ServerRoot "/etc/httpd"      
Listen 80                    
Include conf.modules.d/*.conf 
User apache                   
Group apache                 
ServerAdmin root@localhost   
<Directory />
</Directory>
DocumentRoot "/www/html"   
<Directory "/www/html">
</Directory>

[root@gujipeng ~]# mkdir -p /www/html
[root@gujipeng ~]# vim /www/html/index.html
<meta charset=utf8>
欢迎大家来学习lamp，我是主机192.168.3.140

[root@gujipeng ~]# systemctl restart httpd

部署mariadb（masql）
安装mariadb-server和mariadb

[root@gujipeng ~]# yum install mariadb-server mariadb

启动数据库，检查数据库启动状态、查看进程信息

[root@gujipeng ~]# systemctl start mariadb
[root@gujipeng ~]# netstat -tunlp |grep mysql
tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN      2105/mysqld   

[root@gujipeng ~]# ps -fef|grep mysql
mysql      1942      1  0 12:32 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
mysql      2105   1942  0 12:32 ?        00:00:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock
root      17429   1249  0 12:33 pts/0    00:00:00 grep --color=auto mysql

检查mariadb服务状态

[root@gujipeng ~]# systemctl status mariadb
● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
   Active: active (running) since Sun 2020-09-06 12:32:26 CST; 2min 53s ago
  Process: 1943 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)

用数据库客户端命令，登录数据库，查看数据库信息
#masql客户端命令 -u用户名 -p密码

[root@gujipeng ~]# mysql -uroot -p    #直接回车默认没有密码
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.65-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases
    -> 
    -> ;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.00 sec)

简单sql命令（命令结尾要带；号）
show database 查看所有数据库
use mysql 切换进mysql库
show tables 查看所有数据表
desc user 显示user表结构
select user，host，password from user； 从指定的user表读取指定的字段信息

设置mariadb用户root的登录密码（密码为123456）

[root@gujipeng ~]# mysqladmin -uroot password "123456"

部署php环境搭建

1.解决php安装的依赖开发环境

```bash
[root@gujipeng ~]# yum install -y zlib-devel libxml2-devel libjpeg-devel libjpeg-turbo-devel libiconv-devel freetype-devel libpng-devel gd-devel libcurl-devel libxslt-devel libtool-ltdl-devel pcre pcre-devel apr apr-devel zlib-devel gcc make

2.安装php，以及php连接mysql数据库的驱动

[root@gujipeng ~]# yum install php php-mysql

3.php不需要额外修改，但是需要修改apache配置文件，支持php

[root@gujipeng ~]# vim /etc/httpd/conf/httpd.conf 
DocumentRoot "/www/html"
<Directory "/www/html">
    AllowOverride None
    # Allow open access:
    Require all granted
    TypesConfig /etc/mime.types
    AddType application/x-httpd-php  .php
    AddType application/x-httpd-php-source  .phps
    DirectoryIndex  index.php index.html
</Directory>

4.修改首页文件内容

[root@gujipeng ~]# vim /www/html/index.php
<meta charset=utf8>
我是新的测试首页~~~
<?php
phpinfo();
?>

5.重启apache服务

[root@gujipeng ~]# systemctl restart httpd

php连接mysql
1.添加php脚本

[root@gujipeng ~]# vim /www/html/test.php
<?php
     $conn = mysql_connect('localhost','root','123456');
 if ($conn)
   echo "php已成功连接mysql，恭喜你小兄弟，你真棒";
 else
   echo "你咋回事小老弟，这个php都连接不上mysql，去检查下lamp的配置，以及代码是否写错了，数据库是否启动了，细心检查下吧";
 mysql_close();
?>

访问php脚本文件，测试是否能连接mysql数据库

若是关闭了数据库，或者出现其他配置错误，就会显示如下