PhpMyAdmin 4.9 설치
cd /usr/ports/databases/phpmyadmin
make config
make all install clean
설치한 다음에 나오는 중요한 정보
phpMyAdmin-php74-4.9.7 has been installed into:
/usr/local/www/phpMyAdmin
Please edit config.inc.php to suit your needs.
To make phpMyAdmin available through your web site, I suggest
that you add something like the following to httpd.conf:
For Apache versions earlier than 2.4:
Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"
<Directory "/usr/local/www/phpMyAdmin/">
Options none
AllowOverride Limit
Order Deny,Allow
Deny from all
Allow from 127.0.0.1 .example.com
</Directory>
For Apache version 2.4.x or above:
Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"
<Directory "/usr/local/www/phpMyAdmin/">
Options None
AllowOverride Limit
Require local
Require host .example.com
</Directory>
SECURITY NOTE: phpMyAdmin is an administrative tool that has had several
remote vulnerabilities discovered in the past, some allowing remote
attackers to execute arbitrary code with the web server's user credential.
All known problems have been fixed, but the FreeBSD Security Team strongly
advises that any instance be protected with an additional protection layer,
e.g. a different access control mechanism implemented by the web server
as shown in the example. Do consider enabling phpMyAdmin only when it
is in use.
이건 관리자용 연장이므로 접속하는 환경을 단속하는 것이 중요하다. 다음과 같은 문서를 /usr/local/etc/apache24/vhost/admin.conf 로 만들어 준다.
/usr/local/etc/apache24/vhost/admin.conf
설정 문서 중 일부 내용.
Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"
<Directory "/usr/local/www/phpMyAdmin/">
Options None
AllowOverride Limit
Require local
Require ip xy.225.181.63 # home
Require ip xyz.164.119.217 # office
</Directory>
apachectl restat 로 아파치 재기동 하고, https://my.domain/phpmyadmin 로 접속을 한다.