LAMP-安装Apache服务-安装MYSQL服务-搭建PHP运行环境

第一部分 准备工作

一：服务器：
服务器系统：CentOS 7.5
服务器IP：192.168.42.12
版本：
httpd：2.4.41
mysql：5.7.18
php：7.2.9

___________________________________________________________________

第二部分 安装Apache服务
参考https://blog.csdn.net/tangbin0505/article/details/102474080

———————————————————————————————————

第三部分 安装MYSQL服务

1.下载扩展包和软件安装包
yum -y install make gcc-c++ cmake bison-devel ncurses-devel libaio libaio-devel perl-Data-Dumper net-tools
wget http://sourceforge.mirrorservice.org/b/bo/boost/boost/1.59.0/boost_1_59_0.tar.gz
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.18.tar.gz

2.安装mysql 

下载地址 https://download.csdn.net/download/tangbin0505/12488419
tar zxf boost_1_59_0.tar.gz -C /usr/local/
tar zxvf mysql-5.7.18.tar.gz
cd mysql-5.7.18

预编译

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DMYSQL_DATADIR=/data/mysql \
-DSYSCONFDIR=/etc \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=/usr/local/boost_1_59_0 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_TCP_PORT=3306 \
-DWITH_READLINE=1 \
-DMYSQL_USER=mysql \
-DWITH_SSL=yes

说明

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \       #MySQL的安装目录
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \            #连接数据库socket路径
-DMYSQL_DATADIR=/data/mysql \                        #MySQL的数据目录
-DSYSCONFDIR=/etc \                    #my.cnf路径
-DEXTRA_CHARSETS=all \                    #安装所有的字符集
-DDEFAULT_CHARSET=utf8 \                #设置默认字符集为utf-8
-DDEFAULT_COLLATION=utf8_general_ci \            #设定默认排序规则（utf8_general_ci快速/utf8_unicode_ci准确）
-DWITH_MYISAM_STORAGE_ENGINE=1 \            #启用MySQL的myisam引擎
-DWITH_INNOBASE_STORAGE_ENGINE=1 \            #启用MySQL的innobase引擎
-DWITH_MEMORY_STORAGE_ENGINE=1 \            #启用MySQL的memory引擎
-DWITH_PARTITION_STORAGE_ENGINE=1 \            #安装支持数据库分区
-DDOWNLOAD_BOOST=1 \                    #下载boost
-DWITH_BOOST=/usr/local/boost_1_59_0 \            #boost的安装目录
-DENABLED_LOCAL_INFILE=1 \                #允许从本地导入数据
-DMYSQL_TCP_PORT=3306 \                    #MySQL端口
-DWITH_READLINE=1 \                    #启用readline库支持（提供可编辑的命令行）
-DMYSQL_USER=mysql \                    
-DWITH_SSL=yes    

编译安装                    
[root@localhost mysql-5.7.18]# make && make install

3.创建用户和MYSQL数据存储data目录，授权属主。
groupadd mysql
useradd -g mysql -s /sbin/nologin mysql
mkdir -p /data/mysql
chown -R mysql.mysql /data/mysql
chown -R mysql.mysql /usr/local/mysql

4.编辑MYSQL主配置文件
vim /etc/my.cnf

[client]
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 = /data/mysql
port = 3306
character_set_server=utf8
pid-file = /usr/local/mysql/mysqld.pid
socket = /usr/local/mysql/mysql.sock
log-error = /tmp/mysqld.log
server-id = 1
log-bin = mysql
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

5.初始化mysql数据库和配置成开机自启动的系统服务
cd /usr/local/mysql/bin
./mysqld --initialize-insecure --user=mysql --datadir=/data/mysql --basedir=/usr/local/mysql
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on

service mysqld start    服务形式启动
/etc/init.d/mysqld start  全路径启动
systemctl restart mysqld  服务重启
[root@localhost bin]# /usr/local/mysql/bin/mysql 访问数据库
输入quit  exit 退出

————————————————————————————————————————

第四部分 搭建PHP运行环境

yum方式安装（推荐）

安装php
yum install php  php-fpm php-mysql  php-devel php-common php-gd php-xml php-mbstring php-ldap php-pear php-xmlrpc  php-mcrypt

php -v 查看版本

开机启动
systemctl daemon-reload
systemctl enable php-fpm

1.第三方软件源安装依赖软件
wget -O /etc/yum.repos.d/epel.repo http://mirrors.aliyun.com/repo/epel-7.repo
yum -y install gcc gcc-c++ libvpx libvpx-devel libjpeg-turbo libjpeg-turbo-devel libzip libpng libpng-devel freetype-devel libxml2 libxml2-devel gd gd-devel libxslt-devel libcurl-devel libmcrypt-devel mhash mcrypt openssl openssl-devel

2.编译安装libiconv
wget http://ftp.gnu.org/pub/gnu/libiconv/libiconv-1.15.tar.gz
tar zxf libiconv-1.15.tar.gz
cd libiconv-1.15
./configure --prefix=/usr/local/libiconv
make && make install

3.安装PHP-7.2.9
wget http://cn2.php.net/distributions/php-7.2.9.tar.gz
tar zxf php-7.2.9.tar.gz
cd php-7.2.9

预编译

./configure --prefix=/usr/local/php \
--with-config-file-path=/usr/local/php/etc \
--with-apxs2=/usr/local/apache/bin/apxs \
--with-mysql=mysqlnd \
--with-mysqli=mysqlnd \
--with-pdo-mysql=mysqlnd \
--enable-opcache \
--with-iconv-dir=/usr/local/libiconv \
--with-freetype-dir \
--with-jpeg-dir \
--with-png-dir \
--with-zlib \
--with-libxml-dir \
--enable-xml \
--disable-rpath \
--enable-bcmath \
--enable-shmop \
--enable-sysvsem \
--enable-inline-optimization \
--with-curl \
--enable-mbregex \
--enable-fpm \
--enable-mbstring \
--with-mcrypt \
--with-gd \
--enable-gd-native-ttf \
--with-openssl \
--with-mhash \
--enable-pcntl \
--enable-sockets \
--with-xmlrpc \
--enable-soap \
--enable-short-tags \
--enable-static \
--with-fpm-user=apache \
--with-fpm-group=apache \
--enable-ftp \
--enable-zip \
--with-gettext

编译及安装
[root@localhost php-7.2.9.]# make && make install

4.配置PHP
[root@localhost php-7.2.9]# cp /usr/local/php/etc/php-fpm.conf.default /usr/local/php/etc/php-fpm.conf
[root@localhost php-7.2.9]# cp php.ini-production /usr/local/php/etc/php.ini

5.关联PHP和Apache服务
[root@localhost php-7.2.9]# useradd -s /sbin/nologin apache
[root@localhost php-7.2.9]# sed -i 's/User daemon/User apache/' /usr/local/apache/conf/httpd.conf
[root@localhost php-7.2.9]# sed -i 's/Group daemon/Group apache/' /usr/local/apache/conf/httpd.conf
[root@localhost php-7.2.9]# sed -i '/AddType *.* .tgz/a\\tAddType application/x-httpd-php .php' /usr/local/apache/conf/httpd.conf
[root@localhost php-7.2.9]# sed -i 's/index.html/index.php index.html/' /usr/local/apache/conf/httpd.conf

6.验证

#编辑PHP测试页面
[root@localhost php-7.2.9]# cd /usr/local/apache/htdocs/
[root@localhost htdocs]# vim index.php

<?php
phpinfo();
?>

#重启httpd服务
[root@localhost htdocs]# systemctl restart httpd   #启动apache

/usr/local/apache/bin/apachectl graceful 平滑重启 推荐
#浏览器访问服务器：http://192.168.42.12//index.php

7.测试数据库

[root@localhost htdocs]# /usr/local/mysql/bin/mysql
mysql> create database test;
mysql> grant all on test.* to test@'%' identified by '123456';
mysql> flush privileges;
[root@localhost htdocs]# vim info_mysql.php

<?php
$link=mysqli_connect('192.168.42.12','test','123456');
if($link) echo "<h1>Success!!</h1>";
else echo "Fail!!";
?>

[root@localhost htdocs]# systemctl restart httpd  #启动apache
/usr/local/apache/bin/apachectl graceful   #平滑重启apache 推荐
浏览器访问http://192.168.42.12/info_mysql.php

8.查看lamp各编译参数
查看nginx编译参数：
/usr/local/nginx/sbin/nginx -V
查看apache编译参数：
cat /usr/local/apache/build/config.nice
查看mysql编译参数：
cat /usr/local/mysql/bin/mysqlbug | grep CONFIGURE_LINE
查看php编译参数：
usr/local/php/bin/php -i | grep configure