上一遍文章通过分离部署了lamp,下面在lamp的基础上部署phpmyadmmin,查看lamp分离部署请往 https://blog.csdn.net/whell_scl/article/details/98772391 。
环境说明:
服务器类型 | ip地址 | 应用 | 操作系统 |
---|---|---|---|
httpd | 192.168.100.100 | httpd | centos7/redhat7 |
mysql | 192.168.100.96 | mysql | centos7/redhat7 |
php | 192.168.100.27 | php phpmyadmin | centos7/redhat7 |
php服务端操作
# 下载phpMyAdmin压缩包
[root@php ~]# wget https://files.phpmyadmin.net/phpMyAdmin/4.0.10.20/phpMyAdmin-4.0.10.20-all-languages.zip
[root@php ~]# ls
anaconda-ks.cfg phpMyAdmin-4.0.10.20-all-languages.zip
# 解压至/www/ddd 下面
[root@php ~]# unzip phpMyAdmin-4.0.10.20-all-languages.zip
[root@php ~]# mv phpMyAdmin-4.0.10.20-all-languages /www/ddd/
[root@php ~]# ls /www/ddd/
index.php phpMyAdmin-4.0.10.20-all-languages
# 建立软连接
[root@php ~]# cd /www/ddd/
[root@php ddd]# ln -sv phpMyAdmin-4.0.10.20-all-languages pma
"pma" -> "phpMyAdmin-4.0.10.20-all-languages"
# 复制样本配置文件config.sample.inc.php为config.inc.php
[root@php ddd]# cd pma
[root@php pma]# cp config.sample.inc.php config.inc.php
[root@php pma]# vim config.inc.php # 修改以下两处的内容
$cfg['blowfish_secret'] ='shicailun666'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ #加上随机码用于通信加密(可用openssl rand -base64 15生成)
$cfg['Servers'][$i]['host'] = '192.168.100.96'; # 修改为数据库主机的地址
# 重启服务
[root@php ~]# service php-fpm restart
Gracefully shutting down php-fpm . done
Starting php-fpm done
mysql服务端操作:
# 在mysql主机上授权用户
[root@mysql ~]# mysql -uroot -p'shicailun123!'
mysql> grant all on *.* to pmauser@'192.168.100.%' identified by 'pmapass';
Query OK, 0 rows affected, 1 warning (0.06 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.07 sec)
mysql>
httpd服务端操作:
[root@web ~]# mkdir /usr/local/apache/htdocs/pma
验证:
hosts文件由于上次配置lamp时已经添加所以此处不需要添加,直接访问即可