Install MySQL On FreeBSD.

1.创建数据存放目录，默认在/var/db/mysql下，根据自身喜好选择存放地址：
# mkdir /usr/dbdata
# mkdir /usr/dbdata/mysql

2.安装mysql4
# cd /usr/ports/database/mysql41-server
# make BUILD_OPTIMIZED=yes WITH_PROC_SCOPE_PTH=yes BUILD_STATIC=yes install
# make clean

3.安装p5-DBI, P5-DBD-mysql41
# cd /usr/ports/databases/p5-DBI
# make install clean
# cd /usr/ports/databases/p5-DBD-mysql41
# make install clean

4.配置mysql
# cp /usr/local/share/mysql/my-large.cnf /etc/my.cnf
# vi /etc/my.cnf
根据需要修改。

5.初始化mysql
/usr/local/bin/mysql_install_db --user=mysql --datadir=/usr/dbdata/mysql
chown -R mysql:mysql /usr/dbdata/mysql/mysql
chgrp -R mysql /usr/dbdata/mysql/mysql

6.设置开机自动启动mysql
vi /etc/rc.conf
mysql_enable="YES"
mysql_dbdir="/usr/dbdata/mysql"

7.启动mysql
/usr/local/etc/rc.d/mysql-server.sh start