FreeBSD에서 MySQL 설치

#
# 글제목: FreeBSD에서 MySQL3 설치
# 작성자: hsmok (at) systemamdin.co.kr
# 작성일: 2004. 03. 20
#



FreeBSD에서 MySQL 설치는 다음과 같은 방법 들이 있다.
1. ports
2. pkg_add
3. binary
4. source

일반적이고 많이 사용하는 방법은 ports 또는 source 설치다.





#############################
# 1. ports 설치
#############################
cd /usr/ports/database/mysql323-server
make WITH_CHARSET=euc_kr install
make clean
rehash

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

# mysql 제거
cd /usr/ports/database/mysql323-server
make deinstall
cd /usr/ports/database/mysql323-client
make deinstall




#############################
# 2. pkg_add 설치
#############################
pkg_add -r mysql-server
=> pkg_add로 설치하면 mysql4가 설치된다.
=> mysql3 버전이 필요하면 ports나 소스 설치한다.

# 설치 된 패키지 확인
pkg_info | grep mysql

# 패키지 제거(패키지이름과 버전까지 정확해야 된다.)
pkg_delete mysql-server-3.23.58_2
pkg_delete mysql-client-3.23.58_2




#############################
# 3. binary 설치
#############################
pw group add mysql -g 88
pw user add mysql -g mysql -u 88 -s /sbin/nologin -d /usr/local/mysql/var

mkdir /usr/local/src
cd /usr/local/src
fetch http://mysql.holywar.net/Downloads/MySQL-3.23/mysql-3.23.58-unknown-freebsd4.7-i386.tar.gz
tar xvzf mysql-3.23.58-unknown-freebsd4.7-i386.tar.gz
mv mysql-3.23.58-unknown-freebsd4.7-i386 /usr/local/mysql-3.23.58
ln -s /usr/local/mysql-3.23.58 /usr/local/mysql

cd /usr/local/mysql
scripts/mysql_install_db --datadir=/usr/local/mysql/var
chown -R root /usr/local/mysql
chown -R mysql /usr/local/mysql/var
chgrp -R mysql /usr/local/mysql

cp support-files/my-medium.cnf /etc/my.cnf

# 시작 스크립트 복사
cp support-files/mysql.server /usr/local/etc/rc.d/mysql-server.sh
chmod +x /usr/local/etc/rc.d/mysql-server.sh

# mysql star | stop
/usr/local/etc/rc.d/mysql-server.sh start

# mysql path 설정
echo "set path = ( $path /usr/local/mysql/bin )" >> /etc/csh.cshrc
source /etc/csh.cshrc



#############################
# 4. source 설치
#############################
pw group add mysql -g 88
pw user add mysql -g mysql -u 88 -s /sbin/nologin -d /usr/local/mysql/var

mkdir /usr/local/src
cd /usr/local/src
fetch http://mysql.holywar.net/Downloads/MySQL-3.23/mysql-3.23.58.tar.gz
tar xvzf mysql-3.23.58.tar.gz
cd mysql-3.23.58.tar.gz
./configure --prefix=/usr/local/mysql-3.23.58 --with-charset=euc_kr
make
make install

scripts/mysql_install_db
cp support-files/my-medium.cnf /etc/my.cnf
ln -s /usr/local/mysql-3.23.58 /usr/local/mysql

# 시작 스크립트 복사
cp support-files/mysql.server /usr/local/etc/rc.d/mysql-server.sh
chmod +x /usr/local/etc/rc.d/mysql-server.sh

chown -R root /usr/local/mysql
chown -R mysql /usr/local/mysql/var
chgrp -R mysql /usr/local/mysql

# mysql star | stop
/usr/local/etc/rc.d/mysql-server.sh start

# mysql path 설정(cch,tcsh 사용할 경우)
echo "set path = ( $path /usr/local/mysql/bin )" >> /etc/csh.cshrc
source /etc/csh.cshrc




#############################
# MySQL 루트 비밀번호 설정
#############################
mysqladmin -u root password 'new-password'
mysqladmin -u root -h host_name password 'new-password'

또는

mysql -u root mysql
UPDATE user SET Password=PASSWORD('newpwd') WHERE User='root';
UPDATE user SET Password=PASSWORD('newpwd') WHERE User='';
FLUSH PRIVILEGES;




#############################
# 새로운 사용자 추가
#############################

# 새로운 데이터베이스 생성 -> 계정추가 -> DB 접근권한 설정
CREATE DATABASE new_db;
INSERT INTO user (Host,User,Password) VALUES('localhost','new_user',PASSWORD('newpwd'));
INSERT INTO db VALUES ('localhost','new_db','new_user','Y','Y','Y','Y','Y','Y','N','N','N','N');
FLUSH PRIVILEGES;

또는

CREATE DATABASE new_db;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON new_db.* TO 'new_user'@'localhost' IDENTIFIED BY 'newpwd';



#############################
# MySQL 서버 상태모니터링
#############################
/usr/local/bin/mysqladmin -u root -p version : 버전확인
/usr/local/bin/mysqladmin -u root -p status : 상태확인
/usr/local/bin/mysqladmin -u root -p varialble : 설정변수
/usr/local/bin/mysqladmin -u root -p proc : 프로세스 상태