lamp分离搭建+phpmyadmin

最新推荐文章于 2022-10-12 09:23:05 发布

滴答~

最新推荐文章于 2022-10-12 09:23:05 发布

阅读量487

点赞数

分类专栏： Linux 文章标签： lamp分离搭建

本文链接：https://blog.csdn.net/weixin_44245976/article/details/98958155

版权

Linux 专栏收录该内容

39 篇文章 1 订阅

订阅专栏

lamp平台构建（三台服务器）

文章目录

lamp平台构建（三台服务器）

1.环境说明

系统平台	IP	需要安装的服务
centos7 redhat7	192.168.76.131	httpd-2.4
centos7 redhat7	192.168.76.132	mysql-5.7
centos7 redhat7	192.168.76.133	php

lamp平台软件安装次序： httpd --> mysql --> php

2.http搭建

//安装开发工具包
[root@hua ~]# yum groups mark install 'Development Tools'
[root@hua ~]# yum -y install gcc gcc-c++

//创建用户和组
[root@hua ~]# groupadd -r apache
[root@hua ~]# useradd -r -M -s /sbin/nologin -g apache apache 

//安装依赖包
[root@hua ~]# yum -y install openssl-devel pcre-devel expat-devel libtool

//下载安装包
[root@hua ~]# wget http://mirror.bit.edu.cn/apache/apr/apr-1.6.5.tar.gz
[root@hua ~]# wget http://mirror.bit.edu.cn/apache/apr/apr-util-1.6.1.tar.gz
[root@hua ~]# wget http://mirror.bit.edu.cn/apache/httpd/httpd-2.4.38.tar.gz
[root@hua ~]# ls
anaconda-ks.cfg  apr-1.6.5.tar.bz2  apr-util-1.6.1.tar.bz2  httpd-2.4.38.tar.bz2

//解压
[root@hua ~]# tar xf apr-1.6.5.tar.gz 
[root@hua ~]# tar xf apr-util-1.6.1.tar.gz 
[root@hua ~]# tar xf httpd-2.4.38.tar.gz 
[root@hua ~]# ls
anaconda-ks.cfg  apr-1.6.5.tar.gz  apr-util-1.6.1.tar.gz  httpd-2.4.38.tar.gz
apr-1.6.5        apr-util-1.6.1    httpd-2.4.38
cd apr-1.6.5

//修改配置文件
[root@hua apr-1.6.5]# vim configure
    cfgfile="${ofile}T"
    trap "$RM \"$cfgfile\"; exit 1" 1 2 15
    # $RM "$cfgfile"        //将此行加上注释，或者删除此行
    
    //编译安装
 [root@hua apr-1.6.5]# ./configure --prefix=/usr/local/apr
 [root@hua apr-1.6.5]#  make && make install
 [root@hua ~]# cd apr-util-1.6.1
[root@hua apr-util-1.6.1]# ./configure --prefix=/usr/local/apr-util --with-apr=/usr/local/apr
[root@hua apr-util-1.6.1]# make && make install
[root@hua apr-util-1.6.1]# cd
[root@hua ~]# cd httpd-2.4.38
[root@hua httpd-2.4.38]# ./configure --prefix=/usr/local/apache \
> --sysconfdir=/etc/httpd24 \
> --enable-so \
> --enable-ssl \
> --enable-cgi \
> --enable-rewrite \
> --with-zlib \
> --with-pcre \
> --with-apr=/usr/local/apr \
> --with-apr-util=/usr/local/apr-util/ \
> --enable-modules=most \
> --enable-mpms-shared=all \
> --with-mpm=prefork

//安装后配置
[root@hua ~]# echo 'export PATH=/usr/local/apache/bin:$PATH' > /etc/profile.d/httpd.sh
[root@hua ~]# source /etc/profile.d/httpd.sh
[root@hua ~]# ln -s /usr/local/apache/include/ /usr/include/httpd
[root@hua ~]# echo 'MANPATH /usr/local/apache/man' >> /etc/man.config
[root@huat ~]# sed -i '/#ServerName/s/#//g' /etc/httpd24/httpd.conf 

//启动服务
[root@hua httpd-2.4.38]# apachectl start
[root@hua httpd-2.4.38]# ss -antl
State      Recv-Q Send-Q Local Address:Port                Peer Address:Port              
LISTEN     0      128                *:22                             *:*                  
LISTEN     0      100        127.0.0.1:25                             *:*                  
LISTEN     0      128               :::80                            :::*                  
LISTEN     0      128               :::22                            :::*                  
LISTEN     0      100              ::1:25                            :::*  

//关闭防火墙                
[root@hua httpd-2.4.38]# systemctl stop firewalld

3.mysql安装

//安装依赖包
[root@hua ~]# yum -y install ncurses-devel openssl-devel openssl cmake mariadb-devel

//创建用户和组
[root@hua ~]# groupadd -r -g 306 mysql
[root@hua ~]# useradd -M -s /sbin/nologin -g 306 -u 306 mysql
[root@hua ~]# wget https://downloads.mysql.com/archives/get/file/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
[root@hua ~]# ls
anaconda-ks.cfg                      mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
[root@hua ~]# tar xf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
[root@hua ~]# cd /usr/local

//创建链接
[root@hua local]# ln -sv mysql-5.7.22-linux-glibc2.12-x86_64/ mysql
"mysql" -> "mysql-5.7.22-linux-glibc2.12-x86_64/"

//修改目录/usr/local/mysql的属主属组
[root@hua local]# chown -R mysql.mysql /usr/local/mysql

//设置环境变量
[root@hua local]# echo 'export PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
[root@hua local]# . /etc/profile.d/mysql.sh
[root@hua local]# echo $PATH
/usr/local/mysql/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin

//创建数据存放目录
[root@hua local]# mkdir /opt/data
[root@hua local]# chown -R mysql.mysql /opt/data/

//初始化数据库
[root@hua local]# /usr/local/mysql/bin/mysqld --initialize --user=mysql --datadir=/opt/data/2019-08-08T17:11:33.640254Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-08-08T17:11:33.937800Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-08-08T17:11:33.976766Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-08-08T17:11:34.034121Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 92b05b89-b9ff-11e9-8402-000c29b9f16b.
2019-08-08T17:11:34.034930Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-08-08T17:11:34.035758Z 1 [Note] A temporary password is generated for root@localhost: Szo_qo,!u29/
//localhost后面是随机密码

//把随机面存到文件中
[root@hua local]# echo 'Szo_qo,!u29/' >/root/passwd

//链接头文件
[root@hua ~]# ln -sv /usr/local/mysql/include/ /usr/local/include/mysql
"/usr/local/include/mysql" -> "/usr/local/mysql/include/"
[root@hua ~]# echo '/usr/local/mysql/lib' > /etc/ld.so.conf.d/mysql.conf

//生成配置文件
[root@hua ~]# cat > /etc/my.cnf <<EOF
> [mysqld]
> basedir = /usr/local/mysql
> datadir = /opt/data
> socket = /tmp/mysql.sock
> port = 3306
> pid-file = /opt/data/mysql.pid
> user = mysql
> skip-name-resolve
> EOF

//配置开机自启
[root@hua ~]# cp -a /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@hua ~]# sed -ri 's#^(basedir=).*#\1/usr/local/mysql#g' /etc/init.d/mysqld
[root@hua ~]# sed -ri 's#^(datadir=).*#\1/opt/data#g' /etc/init.d/mysqld

//启动服务
[root@hua ~]# service mysqld start
Starting MySQL.Logging to '/opt/data/hua.err'.
. SUCCESS! 
[root@hua ~]# ss -antl
State      Recv-Q Send-Q Local Address:Port                Peer Address:Port              
LISTEN     0      128                *:22                             *:*                  
LISTEN     0      100        127.0.0.1:25                             *:*                  
LISTEN     0      128               :::22                            :::*                  
LISTEN     0      100              ::1:25                            :::*                  
LISTEN     0      80                :::3306                          :::*             

//关闭防火墙     
[root@hua ~]# systemctl stop firewalld

//修改密码
[root@hua ~]# cat passwd 
Szo_qo,!u29/
[root@hua ~]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.22

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql> set password = password('hua123');
Query OK, 0 rows affected, 1 warning (0.00 sec)

//给php那台主机权限
mysql> grant all on *.* to root@192.168.133 identified by 'hua123';
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)


mysql> quit
Bye

4.安装php

//安装编译软件
[root@hua ~]# yum -y install gcc gcc-c++ make 

//下载网络源
[root@hua ~]# cd /etc/yum.repos.d/
[root@hua yum.repos.d]# wget http://mirrors.163.com/.help/CentOS7-Base-163.repo
[root@hua yum.repos.d]# sed -i 's/\$releasever/7/g' /etc/yum.repos.d/CentOS7-Base-163.repo
[root@hua yum.repos.d]# sed -i 's/^enabled=.*/enabled=1/g' /etc/yum.repos.d/CentOS7-Base-163.repo
[root@hua yum.repos.d]# ls
CentOS7-Base-163.repo  redhat.repo  xx.repo

//把原来的本地源删除
[root@hua yum.repos.d]# rm -rf xx.repo 
[root@hua yum.repos.d]# yum clean all

[root@hua ~]# yum -y install epel-release
[root@hua ~]# rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm

//安装依赖包
[root@hua ~]# yum -y install libxml2 libxml2-devel openssl openssl-devel bzip2 bzip2-devel libcurl libcurl-devel libicu-devel libjpeg libjpeg-devel libpng libpng-devel openldap-devel  libpcre-devel freetype freetype-devel gmp gmp-devel libmcrypt libmcrypt-devel readline readline-devel libxslt libxslt-devel mhash mhash-devel php72w-mysqlnd
[root@hua ~]# wget http://cn.php.net/distributions/php-7.2.8.tar.xz
[root@hua ~]# tar xf php-7.2.8.tar.xz

//编译安装
[root@hua ~]# cd php-7.2.8
[root@hua php-7.2.8]# ./configure --prefix=/usr/local/php7  \
--with-config-file-path=/etc \
--enable-fpm \
--enable-inline-optimization \
--disable-debug \
--disable-rpath \
--enable-shared \
--enable-soap \
--with-openssl \
--enable-bcmath \
--with-iconv \
--with-bz2 \
--enable-calendar \
--with-curl \
--enable-exif  \
--enable-ftp \
--with-gd \
--with-jpeg-dir \
--with-png-dir \
--with-zlib-dir \
--with-freetype-dir \
--with-gettext \
--enable-json \
--enable-mbstring \
--enable-pdo \
--with-mysqli=mysqlnd \
--with-pdo-mysql=mysqlnd \
--with-readline \
--enable-shmop \
--enable-simplexml \
--enable-sockets \
--enable-zip \
--enable-mysqlnd-compression-support \
--with-pear \
--enable-pcntl \
--enable-posix

[root@hua php-7.2.8]# make && make install
[root@hua php-7.2.8]# echo 'export PATH=/usr/local/php7/bin:$PATH' > /etc/profile.d/php7.sh
[root@hua php-7.2.8]# source /etc/profile.d/php7.sh

//查看版本号，出来了就没问题
[root@hua php-7.2.8]# php -v
PHP 7.2.8 (cli) (built: Aug  9 2019 01:52:28) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies
[root@hua php-7.2.8]# cp php.ini-production /etc/php.ini
cp：是否覆盖"/etc/php.ini"？ y

//配置php-fpm
[root@hua php-7.2.8]# cp sapi/fpm/init.d.php-fpm /etc/init.d/php-fpm
[root@hua php-7.2.8]# chmod +x /etc/rc.d/init.d/php-fpm
[root@hua php-7.2.8]# cp /usr/local/php7/etc/php-fpm.conf.default /usr/local/php7/etc/php-fpm.conf
[root@hua php-7.2.8]# cp /usr/local/php7/etc/php-fpm.d/www.conf.default /usr/local/php7/etc/php-fpm.d/www.conf

//修改配置文件
[root@hua ~]# vim /usr/local/php7/etc/php-fpm.d/www.conf
listen = 192.168.76.133:9000
listen.allowed_clients = 192.168.76.131

[root@hua php-7.2.8]# vim /usr/local/php7/etc/php-fpm.conf
//在配置文件最后加上下面几行
pm.max_children = 50    
pm.start_servers = 5    
pm.min_spare_servers = 2    
pm.max_spare_servers = 8    

//创建php页面存放目录
[root@hua ~]# mkdir /var/www/             
[root@hua ~]# cd /var/www/          
[root@hua www]# vim index.php
<?php
        phpinfo();
?>

[root@hua php-7.2.8]# service php-fpm start
Starting php-fpm  done
[root@hua php-7.2.8]# ss -antl
State      Recv-Q Send-Q Local Address:Port                Peer Address:Port              
LISTEN     0      128                *:22                             *:*                  
LISTEN     0      100        127.0.0.1:25                             *:*                  
LISTEN     0      128        127.0.0.1:9000                           *:*                  
LISTEN     0      128               :::22                            :::*                  
LISTEN     0      100              ::1:25                            :::*             
     
[root@hua php-7.2.8]# systemctl stop firewalld

4.配置apache

//启用httpd的相关模块
[root@hua~]# sed -i '/proxy_module/s/#//g' /etc/httpd24/httpd.conf
[root@hua ~]# sed -i '/proxy_fcgi_module/s/#//g' /etc/httpd24/httpd.conf

//生成测试页
[root@hua ~]# mkdir /usr/local/apache/htdocs/hua.com
[root@hua ~]# cat > /usr/local/apache/htdocs/hua.com/index.php <<EOF
> <?php
>    phpinfo();
> ?>
> EOF
> 
[root@hua ~]# chown -R apache.apache /usr/local/apache/htdocs/
[root@hua ~]# ll /usr/local/apache/htdocs/ -d
drwxr-xr-x 3 apache apache 44 8月   9 02:06 /usr/local/apache/htdocs/

[root@hua ~]# vim /etc/httpd24/httpd.conf
//搜索AddType，添加以下内容
    # If the AddEncoding directives above are commented-out, then you
    # probably should define those extensions to indicate media types:
    #
    AddType application/x-compress .Z
    AddType application/x-gzip .gz .tgz
    AddType application/x-httpd-php .php        //添加此行
    AddType application/x-httpd-php-source .phps        //添加此行
    
//在配置文件的最后加入以下内容
<VirtualHost *:80>
    DocumentRoot "/usr/local/apache/htdocs/"
    ServerName www.hua.com
    ProxyRequests Off
    ProxyPassMatch ^/(.*\.php)$ fcgi://192.168.76.133:9000/var/www/$1   //  /var/www对应php上创建的那个文件
    <Directory "/var/www">
        Options none
        AllowOverride none
        Require all granted
    </Directory>
</VirtualHost>
[root@hua ~]# apachectl stop
[root@hua ~]# apachectl start

效果
在这里插入图片描述

5.phpmyadmin

php那台主机操作

//安装phpmyadmin
[root@hua ~]# wget https://files.phpmyadmin.net/phpMyAdmin/4.0.10.20/phpMyAdmin-4.0.10.20-all-languages.zip
//解压
[root@hua ~]# unzip phpMyAdmin-4.0.10.20-all-languages.zip
//改名
[root@hua ~]# mv phpMyAdmin-4.0.10.20-all-languages phpmyadmin
//移动到php页面存放的目录
[root@hua ~]# mv phpmyadmin /var/www/
[root@hua ~]# cd /var/www/phpmyadmin/
//制作备份
[root@hua phpmyadmin]# cp config.sample.inc.php config.inc.php
//修改备份配置文件
[root@hua phpmyadmin]# vim config.inc.php
$cfg['blowfish_secret'] = 'hua123'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */   //随便设置个登录密码
$cfg['Servers'][$i]['host'] = '192.168.76.132';    //填mysql那台主机的名字

//重启服务
[root@hua phpmyadmin]# service php-fpm restart
Gracefully shutting down php-fpm . done
Starting php-fpm  done

http那台主机操作

//创建一个空目录，名字必须对应php那边的目录名
[root@hua ~]# mkdir /usr/local/apache/htdocs/phpmyadmin     
//重启服务
[root@hua ~]# apachectl stop
[root@hua ~]# apachectl start

验证
在这里插入图片描述