LAMP(PHP编译安装及Mysql连接)

安装依赖包

yum -y install libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxm12 liype-devel libxml2 libxml2-devel zlib zlib-devel curl curl-devel openssl openssl-devel

导入安装包

• php-7.1.10.tar.bz2

解包

[root@server1 ~]# tar jxvf php-7.1.10.tar.bz2

配置文件

[root@server1 ~]# cd php-7.1.10/
./configure \
--prefix=/usr/local/php \
--with-apxs2=/usr/local/httpd/bin/apxs \
--with-mysql-sock=/usr/local/mysql/mysql.sock \
--with-mysqli \
--with-zlib \
--with-curl \
--with-gd \
--with-jpeg-dir \
--with-png-dir \
--with-freetype-dir \
--with-openssl \
--enable-mbstring \
--enable-xml \
--enable-session \
--enable-ftp \
--enable-pdo \
--enable-tokenizer \
--enable-zip

进行编译安装

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

配置文件

[root@server1 php-7.1.10]# cp php.ini-development /usr/local/php/lib/php.ini
[root@server1 php-7.1.10]# vi /usr/local/php/lib/php.ini 
//添加以下内容，添加位置见下图
mysqli.default_socket = /usr/local/mysql/musql.sock
date.timezone = Asia/Shanghai

检查模块

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

编辑配置文件

vi /etc/httpd.conf
//添加  添加位置见下图
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
//修改  修改位置见下图
DirectoryIndex index.php index.html

配置PHP文件进行检验

vi /usr/local/httpd/htdocs/index.php
<?php
phpinfo();
?>

连接Mysql

登录数据库

[root@server1 ~]# mysql -uroot -pabc123
mysql> create database myadm;   //创建一个数据库
mysql> grant all privileges on myadm.* to 'myadm'@'localhost' identified by 'admin123'   //本地授权
mysql> grant all privileges on myadm.* to 'myadm'@'%' identified by 'admin123';   //远程授权
mysql> flush privileges;  刷新
mysql> exit
//%：表示范围，任意

修改php的网页

[root@server1 ~]# vi /usr/local/httpd/htdocs/index.php
<?php
$link=mysqli_connect('20.0.0.10','myadm','admin123');
if($link) echo "<h1>Success!</h1>";
else echo "Fail!";
?>

安装phpMyadmin

解压缩

[root@server1 ~]# unzip phpMyAdmin-4.7.6-all-languages.zip

[root@server1 ~]# mv phpMyAdmin-4.7.6-all-languages /usr/local/httpd/htdocs/myadm
[root@server1 ~]# cp /usr/local/httpd/htdocs/myadm/config.sample.inc.php /usr/local/httpd/htdocs/myadm/config.inc.php 
[root@server1 ~]# vi /usr/local/httpd/htdocs/myadm/config.inc.php 
$cfg['Servers'][$i]['host'] = '20.0.0.10';

注：如出现错误

解决方法

[root@server1 ~]# mysql -uroot -pabc123
mysql> grant all privileges on *.* to 'root'@'server1' identified by 'abc123';
mysql> flush privileges;
mysql> exit