MySQL安裝紀錄 for FreeBSD

# cd /usr/ports/database/mysql51-server

# make WITH_CHARSET=utf8 install clean

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

# /usr/local/bin/mysql_install_db

# vi /etc/rc.conf

mysql_enable="YES"

 

# cp /usr/local/share/mysql/my-huge.cnf /etc/my.cnf

# vi /etc/my.cnf

 

[mysqld]

default-character-set = utf8

[client]

default-character-set = utf8

 

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

# mysqladmin -u root -p password '密碼'

# mysql -p