FreeBSD架設網頁伺服器，Apache，PHP，MySQL，phpmyadmin

Port位置
/usr/ports/www/apache24
/usr/ports/databases/mysql56-server
/usr/ports/www/mod_php55阿帕契的PHP套件
/usr/ports/lang/php55
/usr/ports/lang/php55-extensions函式庫
/usr/ports/databases/phpmyadmin

編輯/etc/rc.conf開機啟動

apache24_enable="YES"
mysql_enable="YES"

編輯apache設定檔

/usr/local/etc/apache24/httpd.conf

依個人喜好修改

依個人喜好修改
ServerRoot "/usr/local"
ServerAdmin you@your.address
ServerName www.example.com:80
DocumentRoot "/usr/local/www/apache24/data"網頁根目錄
Listen :80監聽埠

首頁預設名稱
DirectoryIndex index.php index.html

加入PHP支援
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
LoadModule php5_module        libexec/apache24/libphp5.so

加入phpMyAdmin支援
Alias /phpmyadmin "/usr/local/www/phpMyAdmin"

<Directory "/usr/local/www/phpMyAdmin">
Options None
AllowOverride None
Require all granted
</Directory>

語言選項
AddDefaultCharset On

做一個目錄

mkdir /usr/local/www/phpMyAdmin/config
hmod o+w /usr/local/www/phpMyAdmin/config權限不對沒辦法用
chmod o+r /usr/local/www/phpMyAdmin/config.inc.php
這檔案應該是從config.inc.php.sample還是 config.sample.inc.php或是/usr/local/etc/php.ini-development複製來的，忘了，內容好像都一樣

MYSQL設定ROOT密碼

/usr/local/bin/mysqladmin -u root password

登入MYSQL設定讓遠端可以連線

mysql -u root -p
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'mypassword' WI
TH GRANT OPTION;

複製MYSQL設定檔

cp /usr/local/share/mysql/my-default.cnf /etc/my.cnf

啟動apach、mysql

/usr/local/etc/rc.d/mysql-server start
/usr/local/sbin/apachectl start

寫一個index.php丟進網頁根目錄 /usr/local/www/apache24/data

<? php 
phpinfo();
?>

用瀏覽器有看到PHP資訊就是apache架設成功且可以正常解析PHP
再瀏覽IP/phpmyadmin/網頁，出現登入畫面表示phpmyadmin安裝成功，
可以登入看到MYSQL內建資料庫表示資料庫架設成功。

httpd，80Port mysqld，3306