freebsd mysql57_FreeBSD下安装mysql基本步骤

cd /usr/ports/databases/mysql51-server

make WITH_XCHARSET=all WITH_CHARSET=utf8 WITH_PROC_SCOPE_PTH=yes SKIP_DNS_CHECK=yes BUILD_OPTIMIZED=yes install clean

/usr/local/bin/mysql_install_db

chown -R mysql:mysql /var/db/mysql

ee /etc/rc.conf

mysql_enable=”YES”

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

ee /etc/my.cnf

在

# The MySQL server

[mysqld]

port = 3306

socket = /tmp/mysql.sock

后面加入：

bind-address = 127.0.0.1

max_connections = 1000

max_user_connections = 1000

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

/usr/local/bin/mysqladmin -u root password ‘123456’

配置线程库为libthr.so：

ee /etc/libmap.conf

加入

[mysqld]

libpthread.so.2 libthr.so.2

libpthread.so libthr.so

最新的没时间实验了，回家过年了

http://bbs.bsdlover.cn/thread-2218-1-1.html