/*******************************************************
有人將這些網路服務"套件"稱之為架站黃金組合, 至於個人
看法是...不用錢就是最佳組合= =+
一開始寫互動是網頁語言是從M$公司的ASP, 但後來發現身邊
太多人使用PHP, 漸漸也被洗腦改玩PHP...
以上是廢話, 本篇文章先來安裝MySQL吧
*******************************************************/

//安裝MySQL-Client-5.1.11
# cd /usr/ports/databases/mysql51-client/
# make WITH_CHARSET=utf8 WITH_XCHARSET=all SKIP_DNS_CHECK=yes BUILD_OPTIMIZED=yes BUILD_STATIC=yes NO_CHECKSUM=yes install clean

//安裝MySQL-Server-5.1.11
# cd /usr/ports/databases/mysql51-server/
# make WITH_CHARSET=utf8 WITH_XCHARSET=all SKIP_DNS_CHECK=yes BUILD_OPTIMIZED=yes BUILD_STATIC=yes WITH_DB_DIR=/usr/local/mysql NO_CHECKSUM=yes install clean

# chown -R mysql:mysql /usr/local/bin/mysql
//讓開機時自動開啟Mysql
# ee /etc/rc.conf
//加入mysql_enable="yes"
//立即啟動MySQL
# /usr/local/etc/rc.d/mysql-server restart
//更改Mysql的root密碼
# mysql
mysql> use mysql
mysql> UPDATE user SET password=password('密碼') WHERE user='root' ;
mysql> exit

/*******************************************************
去FreeBSD官網查了一下, 看到MySQL-Server-5.1.11相依
MySQL-Client-5.1.11 這代表安裝MySQL-Server就會自動安裝
MySQL-Client了...可以嘗試看看!!
*******************************************************/