LNMP架构搭建（MYSQL,NGINX,PHP）

一、搭建 Nginx

• 解压压缩包

[root@localhost mnt]# tar zxvf nginx-1.12.2.tar.gz -C /opt/

• 安装nginx所需要的环境包

[root@localhost mnt]# yum install gcc gcc-c++ pcre pcre-devel zlib-devel -y

• 创建用户，且不允许登录系统

[root@localhost mnt]# useradd -M -s /sbin/nologin nginx

• 进入nginx解压包路径，配置nginx服务

[root@localhost opt]# cd /opt/nginx-1.12.2/
[root@localhost nginx-1.12.2]# ./configure \
> --prefix=/usr/local/nginx \
> --user=nginx \
> --group=nginx \
> --with-http_stub_status_module

• 安装nginx服务

[root@localhost nginx-1.12.2]# make && make install

• 为了方便管理，可以给nginx创建一个软连接

[root@localhost system]# ln -s /usr/local/nginx/sbin/nginx /usr/local/sbin

• 编写一个脚本，可以用 systemctl 工具控制其开启、关闭、重载

[root@localhost nginx-1.12.2]# cd /lib/systemd/syste
[root@localhost system]# vim nginx.service

[Unit]
Description=nginx
After=network.target
[Service]
Type=forking
PIDFile=/usr/local/nginx/logs/nginx.pid
ExecStart=/usr/local/nginx/sbin/nginx
ExecReload=/usr/bin/kill -s HUP $MAINPID
ExecStop=/usr/bin/kill -s QUIT $MAINPID
PrivateTmp=true
[Install]
WantedBy=multi-user.target

• 添加权限

root@localhost system]# chmod 754 nginx.service

• 关闭防火墙，启动服务，在客户机访问，验证服务

[root@localhost system]# systemctl stop firewalld.service
[root@localhost system]# systemctl start nginx.service
[root@localhost system]# netstat -ntap | grep nginx
tcp        0      0 0.0.0.0:80              0.0.0.0:*               LISTEN      6279/nginx: master  
[root@localhost system]#

 

 二、搭建 Mysql

解压压缩包

[root@localhost opt]# tar zxvf mysql-boost-5.7.20.tar.gz -C /opt

安装工具，环境

[root@localhost opt]# yum -y install \
> ncurses \
> ncurses-devel \
> bison \
> cmake

创建用户

[root@localhost opt]# useradd -s /sbin/nologin mysql

编译

[root@localhost opt]# cmake \
> -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
> -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \
> -DSYSCONFDIR=/etc \
> -DSYSTEMD_PID_DIR=/usr/local/mysql \
> -DDEFAULT_CHARSET=utf8 \
> -DDEFAULT_COLLATION=utf8_general_ci \
> -DWITH_INNOBASE_STORAGE_ENGINE=1 \
> -DWITH_ARCHIVE_STORAGE_ENGINE=1 \
> -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
> -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \
> -DMYSQL_DATADIR=/usr/local/mysql/data \
> -DWITH_BOOST=boost \
> -DWITH_SYSTEMD=1

安装mysql数据库

[root@localhost opt]# make && male install

设置权限

[root@localhost opt]# chown -R mysql:mysql /usr/local/mysql/

调整配置文件：删掉原有内容，添加以下内容

[root@localhost opt]# vim /etc/my.cnf
[client]
port = 3306
default-character-set=utf8
socket = /usr/local/mysql/mysql.sock

[mysql]
port = 3306
default-character-set=utf8
socket = /usr/local/mysql/mysql.sock

[mysqld]
user = mysql
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
character_set_server=utf8
pid-file = /usr/local/mysql/mysqld.pid
socket = /usr/local/mysql/mysql.sock
server-id = 1

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,PIPES_AS_CONCAT,ANSI_QUOTES

设置环境变量：

[root@localhost opt]# echo 'PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH' >>/etc/profile
[root@localhost opt]# echo 'export PATH' >>/etc/profile
[root@localhost opt]# source /etc/profile

初始化数据库

[root@localhost opt]# cd /usr/local/mysql/
[root@localhost mysql]# bin/mysqld \
> --initialize-insecure \
> --user=mysql \
> --basedir=/usr/local/mysql \
> --datadir=/usr/local/mysql/data

保持路径不变，将服务复制到 /lib/systemd/system/路径下，可以用systemctl控制管理

[root@localhost mysql]# cp usr/lib/systemd/system/mysqld.service /lib/systemd/system/

启动服务，检测mysql 服务是否成功

[root@localhost mysql]# systemctl start mysqld.service
[root@localhost mysql]# netstat -natp | grep 3306
tcp6       0      0 :::3306                 :::*                    LISTEN      60701/mysqld        
[root@localhost mysql]#

设置 mysql 密码：
默认密码没有，直接回传即可，输入新密码

[root@localhost mysql]# mysqladmin -u root -p password
Enter password:                //初始密码无，直接回车
New password:                  //设置密码为123456
Confirm new password:          //确认密码123456
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.

登录数据库：

[root@localhost mysql]# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 5.7.20 Source distribution

Copyright (c) 2000, 2017, 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>

安装 PHP

安装环境依赖包

[root@localhost mysql]# yum -y install \
> libjpeg \
> libjpeg-devel \
> libpng libpng-devel \
> freetype freetype-devel \
> libxml2 \
> libxml2-devel \
> zlib zlib-devel \
> curl curl-devel \
> openssl openssl-deve

解压缩包

[root@localhost mnt]# tar jxvf php-7.1.10.tar.bz2 -C /opt

configure配置

[root@localhost php-7.1.10]# make && make install

修改配置文件

[root@localhost php-7.1.10]# cp php.ini-development /usr/local/php/lib/php.ini

1170 mysqli.default_socket = /usr/local/mysql/mysql.sock  //添加mysql数据库连接文件路径

939 date.timezone = Asia/Shanghai                        //添加时区为上海

验证安装模块

[root@localhost php-7.1.10]# /usr/local/php/bin/php -m

配置及优化FPM模块

[root@localhost php-7.1.10]# cd /usr/local/php/etc/
[root@localhost etc]# cp php-fpm.conf.default php-fpm.conf
[root@localhost etc]# cd /usr/local/php/etc/php-fpm.d
[root@localhost php-fpm.d]# cp www.conf.default www.conf
[root@localhost etc]# vim php-fpm.conf

17 pid = run/php-fpm.pid            //开启此功能

启动 PHP，检查是否开启

[root@localhost etc]# /usr/local/php/sbin/php-fpm -c /usr/local/php/lib/php.ini
[root@localhost etc]# netstat -ntap | grep 9000
tcp        0      0 127.0.0.1:9000          0.0.0.0:*               LISTEN      69026/php-fpm: mast 
[root@localhost etc]# 

创建软连接文件，便于管理命令

[root@localhost etc]# ln -s /usr/local/php/bin/* /usr/local/bin/

使nginx 支持 PHP

[root@localhost etc]# vim /usr/local/nginx/conf/nginx.conf

location ~ \.php$ {
 66         root           html;
 67         fastcgi_pass   127.0.0.1:9000;
 68         fastcgi_index  index.php;
 69         fastcgi_param  SCRIPT_FILENAME   /usr/local/nginx/html$fastcgi_script_name;
 70         include        fastcgi_params;
 71         }



  //69行，主要路径

重启nginx服务

[root@localhost etc]# systemctl restart nginx

创建PHP首页

[root@localhost etc]# vim /usr/local/nginx/html/index.php
<?php
phpinfo();
?>

网站访问PHP首页

 安装论坛

mysql>
//输入以下命令
CREATE DATABASE bbs;   //创建数据库bbs
GRANT all ON bbs.* TO 'bbsuser'@'%' IDENTIFIED BY 'admin123';  //设置用户bbsuser密码
GRANT all ON bbs.* TO 'bbsuser'@'localhost' IDENTIFIED BY 'admin123'; 
flush privileges;

解压 Discuz 论坛文件

[root@localhost mnt]# unzip Discuz_X3.4_SC_UTF8.zip -d /opt

授权

[root@localhost mnt]# cd /opt/dir_SC_UTF8/
[root@localhost dir_SC_UTF8]# cp -r upload/ /usr/local/nginx/html/bbs
[root@localhost dir_SC_UTF8]# cd /usr/local/nginx/html/bbs/
[root@localhost bbs]# chown -R root:nginx ./config/
[root@localhost bbs]# chown -R root:nginx ./data/
[root@localhost bbs]# chown -R root:nginx ./uc_client/
[root@localhost bbs]# chown -R root:nginx ./uc_server/
[root@localhost bbs]# chmod -R 777 ./config/
[root@localhost bbs]# chmod -R 777 ./data/
[root@localhost bbs]# chmod -R 777 ./uc_client/
[root@localhost bbs]# chmod -R 777 ./uc_server/

访问网址，安装论坛

填好数据库名称和密码之后，就可以进入首页了