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

FreeBSD下安装mysql基本步骤

/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

Leave a Reply