实验：LAMP的php模块方式应用phpmyadm和wordpress

实验环境：

两台主机

一台A:httpd,php
一台B:mariadb server

1安装相关包组

在A上:

yum httpd php php-mysql

vim /etc/php.ini
date.timezone = Asia/Shanghai   修改时区

vim /etc/httpd/conf/httpd.conf
<IfModule dir_module>
    DirectoryIndex index.php index.html
</IfModule>

systemctl restart httpd


vim /var/www/html/index.php
<?php
echo date("Y/m/d H:i:s");
phpinfo();
?>

2 安装数据库

在B上

yum install mariadb-server
systemctl start  mariadb  启动数据库

mysql_secure_installation 执行数据库安全策阅

mysql -uroot -pcentos
>grant all on  *.* to root@'192.168.37.%' identified by 'centos';  授权用户登陆

vim /var/www/html/index2.php
<?php
$mysqli=new mysqli("localhost","root","centos");
if(mysqli_connect_errno()){
echo "连接数据库失败!";
$mysqli=null;
exit;
}
echo "连接数据库成功!";
$mysqli->close();

测试 http://websrv/

3 实现phpmyadmin

yum install php-mbstring

unzip phpMyAdmin-4.0.10.20-all-languages.zip
cp -r phpMyAdmin-4.0.10.20-all-languages /var/www/html/pma
cd /var/www/html/pma
cp config.sample.inc.php config.inc.php
vim config.inc.php
$cfg['Servers'][$i]['host'] = 'mysqlserverip';

测试 http://websrv/pma/
使用root账号,密码centos  登录测试
注意：phpmyadmin默认连接本机 （httpd mariadb  php在同一个主机）

4 A上部署wordpress

mysql -uroot -pcentos
> create database wpdb;  创建数据库
> grant all wpdb.* to wpuser@'192.168.37.%' identified by 'centos';
> flush privileges;    刷新生效

tar xvf wordpress-4.8.1-zh_CN.tar.gz
cp -r  wordpress   /var/www/html/blog
cd /var/www/html/blog
cp wp-config-sample.php wp-config.php
vim wp-config.php
define('DB_NAME', 'wpdb');
define('DB_USER', 'wpuser');
define('DB_PASSWORD', 'centos');

define('DB_HOST', '192.168.37.107');

测试http://websrv/blog/