Apache20 + MySQL51 + PHP5 + phpMyAdmin

Description :

        今天把我的 FreeBSD Server 重新整理過，因為都裝了最新版的軟體，所以比較生疏。而我又是一個超級健忘的人，為了害怕日後會忘記，所以將安裝過程全都記錄下來，以方便將來參考用，同時也分享我今天的安裝經驗給大家， Apache20 + Mysql51 + PHP5 希望喜歡 FreeBSD 的朋友都受益，分享是件快樂的事。

Environment :

硬體：i386 PC Intel P4 1.5G
記憶體網卡：512M RAM + Intel 網卡
作業系統：FreeBSD 6.2 Release

Setp 1.

安裝 Mysql51
#cd /usr/ports/database/mysql51-server
#make WITH_CHARSET=utf8 install clean

安裝 Apache20
#cd /usr/ports/www/apache20
#make install clean

安裝 PHP5
#cd /usr/ports/lang/php5     
#make install clean 

[X] CLI        Build CLI version                                
[X] CGI        Build CGI version                                
[X] APACHE     Build Apache module                              
[ ] DEBUG      Enable debug                                     
[X] SUHOSIN    Enable Suhosin protection system (not for jails) 
[ ] MULTIBYTE  Enable zend multibyte support                    
[ ] IPV6       Enable ipv6 support                              
[ ] MAILHEAD   Enable mail header patch                         
[ ] REDIRECT   Enable force-cgi-redirect support (CGI only)     
[ ] DISCARD    Enable discard-path support (CGI only)           
[X] FASTCGI    Enable fastcgi support (CGI only)                
[X] PATHINFO   Enable path-info-check support (CGI only) 

安裝 PHP5-extensions 延伸套件
#cd /usr/ports/lang/php5-extensions
#make config clean     #  會跳出所有的延伸套件供你選擇，依個人需求選擇自己所需要的：

[X] CTYPE ctype functions
[X] GD GD library support
[X] GETTEXT gettext library support
[X] ICONV iconv support
[X] MYSQL MySQL database support
[X] OVERLOAD user-space object overloading support
[X] PCRE Perl Compatible Regular Expression support
[X] POSIX POSIX-like functions
[X] SESSION session support
[X] TOKENIZER tokenizer support
[X] XML XML support
[X] ZLIB ZLIB support

安裝 php5-mysql 套件
# cd /usr/ports/databases/php5-mysql
# make install clean

安裝 phpMyAdmin
# cd /usr/ports/databases/phpmyadmin
#make install clean

Setp 2.

#vi /etc/rc.conf      # 設定 MySQL、Apache2 開機自動啟動 

mysql_enable="YES"
apache2_enable="YES"

# cp /usr/local/share/mysql/my-large.cnf /etc/my.cnf
# vi /etc/my.cnf        # 依喜好自行修改 my.cnf

query_cache_size = 32M

[mysqld]
default-character-set=utf8
[client]
default-character-set=utf8

#vi /usr/local/etc/apache/httpd.conf     # 編輯 Apache 的設定檔加入下列幾行：

AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
DirectoryIndex index.php

Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"

    
         Options none
         AllowOverride Limit
         Order Deny,Allow
         Deny from all
         Allow from 127.0.0.1 88.88.88.0/24
    

# cd /usr/local/www/data/phpMyAdmin  
# cp libraries/config.default.php config.inc.php
# vi config.inc.php        # 修改為 http 認證  

$cfg['Servers'][$i]['auth_type'] = 'http';


編輯 PHP5 的設定檔
#cp /usr/local/etc/php.ini-dist /usr/local/etc/php.ini      # 複製 php.ini-dist 到 php.ini

# reboot

Setp 3.

確認過 Apache Service 已經啟動後，編輯一個 php 檔：#vi /usr/local/www/data-dist/index.php 內容為下：


phpinfo();
?>

最後開個 Browse 查看 http://HostName/index.php 看PHP5 有無啟動。

同時開個   查看 phpMyAdmin 可否連線。