MySQL 5.51a Quick Install Guide

[MySQL 설치 환경]

Ver : MySQL 5.51a
OS : CentOS 5.3(Final)

 

0. 기존 MySQL 삭제
[root@ ~] # yum remove mysql -y

 

1. 압축해제
다운로드 디렉토리 : /usr/local/src/APM
[root@ APM] # tar -zxvf mysql*.tar.gz
[root@ APM] # cd mysql*

 

2. MySQL 계정 생성
[root@ MySQL5.51a] # useradd -M -s /bin/false mysql

 

3. /.configure 실행
[root@ MySQL5.51a] # ./configure \
> --prefix=/usr/local/server/mysql \
> --with-charset=utf8 \
> --with-extra-charsets=all

[root@ MySQL5.51a] # make && make install

 

4. 환경파일 복사
[root@ MySQL5.51a] # cp support-files/my-large.cnf /etc/my.cnf

my-huge.cnf : Mem 1G ~ 2G
my-large.cnf : Mem 512M
my-medium.cnf : Mem 64~256M
my-small.cnf : Mem less than 64M

 

5. 기본 DB 생성
[root@ MySQL5.51a] # cd /usr/local/server/mysql
[root@ mysql] # bin/mysql_install_db --user=mysql

 

6. 권한설정
[root@ mysql] # chown -R root .
[root@ mysql] # chown -R mysql var
[root@ mysql] # chgrp -R mysql .

 

7. 환경변수 설정
[root@ mysql] # vi ~/.bash_profile
export MYSQL_HOME="/usr/local/server/mysql"
export PATH=$PATH:$MYSQL_HOME/bin

 

[root@ mysql] # source ~/.bash_profile

8. 자동실행 등록
[root@ mysql] # cp share/mysql/mysql.server /etc/init.d/mysqld
[root@ mysql] # chkconfig --add mysqld
[root@ mysql] # chkconfig --list | grep mysqld
run levle 2,3,4,5 에서 수행

 

9. MySQL root 패스워드 변경
[root@ mysql] # /etc/init.d/mysqld start
[root@ mysql] # mysqladmin -u root password mysql
[root@ mysql] # mysql -u root -p

 

10. 기동 확인
mysql> use mysql;
mysql> show tables;