CentOS 5.6에 MySQL 5.1 소스설치

#1. 계정 추가

groupadd mysql

useradd -g mysql mysql

getent group mysql

#2. 설치

wget http://downloads.mysql.com/archives/mysql-5.1/mysql-5.1.56.tar.gz

tar xvfz mysql-5.1.48.tar.gz

chown mysql:mysql /usr/local/src/mysql-5.1.48

mkdir /usr/local/mysql

chown -R mysql:mysql  /usr/local/mysql

./configure --prefix=/usr/local/mysql --with-charset=utf8 --with-extra-charsets=all --with-mysqld-user=mysql --with-innodb

configure: error: No curses/termcap library found

=> yum install libtermcap-devel

make

make install

#3. DB 초기화

/usr/local/mysql/bin/mysql_install_db --user=mysql

#4. Path추가

vi /etc/profile

export PATH=$PATH:/usr/local/mysql/bin

#5. 설정

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

#6. 자동실행

cp /usr/local/mysql/share/mysql/mysql.server /etc/rc.d/init.d/  

cp /usr/local/mysql/share/mysql/mysql.server /etc/rc.d/init.d/mysql

chmod 755 /usr/local/mysql

#7. 기동

/etc/rc.d/init.d/mysql start