建 Group 和 用户

# pw groupadd mysql #建立mysql组
# pw useradd mysql -g mysql #建立mysql用户并且加入到mysql组中

去mysql下载 for freebsd的mysql
mysql-max-5.0.27-freebsd6.0-i386.tar.gz

#tar zxvf mysql-max-5.0.27-freebsd6.0-i386.tar.gz
#mv mysql-max-5.0.27-freebsd6.0-i386 /usr/local/mysql
#cd /usr/local/mysql
#./scripts/mysql_install_db –user=mysql #初始化数据库

配置mysql

#bin/mysqld_safe –user=mysql & #第一次启动mysql
#bin/mysqladmini -uroot password 123456 #修改数据库管理员密码
#cp support-files/mysql.server /usr/local/etc/rc.d/mysql.sh #添加自动启动

附 mysql php 手动编译参数

mysql

# ./configure –prefix=/usr/local/mysql –without-debug –without-bench –enable-thread-safe-client –enable-assembler –with-extra-charsets=complex –with-named-thread-libs=’-lthr’ –with-archive-storage-engine –with-big-tables –with-mysqld-ldflags=-all-static –with-client-ldflags=-all-static

php

#./configure –enable-fastcgi –with-mysql=/usr/local/mysql –with-ttf –with-xml –enable-ftp –with-gd –with-zlib –with-freetype –with-jpeg-dir=/usr/local/lib/ –enable-force-cgi-redirect –enable-mbstring –with-iconv –enable-sockets –with-curlwrappers

注: mysqp php 编译参数摘录至 [weeker]