lamp+phpmyadmin

lamp+phpmyadmin

上一篇我们部署了lamp 查看 https://blog.csdn.net/sky1791/article/details/99181344

环境说明：

务器类型	ip地址	应用	操作系统
httpd	192.168.35.128	httpd	centos7/redhat7
mysql	192.168.35.130	mysql	centos7/redhat7
php	192.168.35.129	php phpmyadmin	centos7/redhat7

php服务端操作

下载phpMyAdmin压缩包
[root@php ~]# cd /usr/src/
[root@php src]# wget https://files.phpmyadmin.net/phpMyAdmin/4.0.10.20/phpMyAdmin-4.0.10.20-all-languages.zip

将包解压到/www/swk/下面
[root@php src]# unzip phpMyAdmin-4.0.10.20-all-languages.zip
[root@php src]# mv phpMyAdmin-4.0.10.20-all-languages /www/swk/
[root@php src]# ls /www/swk/
index.php  phpMyAdmin-4.0.10.20-all-languages

建立软连接
[root@php ~]# cd /www/swk/
[root@php swk]# ls
index.php  phpMyAdmin-4.0.10.20-all-languages
[root@php swk]# 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 swk]# cd pma
[root@php pma]# cp config.sample.inc.php config.inc.php
[root@php pma]# vim config.inc.php
$cfg['Servers'][$i]['host'] = '192.168.35.130';	   # 修改为数据库主机的地址

mysql服务端

[root@mysql ~]# mysql -uroot -p'suwenkang123!'
mysql> grant all on *.* to pmauser@'192.168.40.129.%' identified by 'pmapass';
Query OK, 0 rows affected, 1 warning (0.12 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

重启php服务和httpd服务

[root@php ~]# service php-fpm restart
Gracefully shutting down php-fpm warning, no pid file found - php-fpm is not running ?
Starting php-fpm  done
[root@httpd ~]# apachectl stop
[root@httpd ~]# apachectl start

访问phpMyadmin