MySQL 5.5 소스 설치

1. 셋업 기준 설치

wget http://cdn.mysql.com//archives/mysql-5.5/mysql-5.5.38.tar.gz

tar xzvf mysql-5.5.38.tar.gz

cd /usr/local/src/mysql-5.5.38

groupadd mysql

useradd -g mysql -M -s /bin/false mysql

 

yum -y install cmake bison

yum -y install make

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DWITH_INNOBASE_STORAGE_ENGINE=1 -DDEFAULT_CHARSET=euckr -DDEFAULT_COLLATION=euckr_korean_ci  -DENABLED_LOCAL_INFILE=1 -DWITH_EXTRA_CHARSETS=all -DWITH_ZLIB=system

make ; make install

 

2. DB 파일 및 기동

chown -R root.mysql /usr/local/mysql/

chown -R mysql /usr/local/mysql/data

cd /usr/local/mysql/

mv data data_old

rsync -avr /usr/local/mysql/data_old/ /data/

ln -s /data data

chown mysql.mysql /data

 

rsync -av 121.78.197.64::R/etc/my.cnf /etc/

mkdir /local_backup/mysql_binlog/

chown mysql.mysql /local_backup/mysql_binlog/

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

support-files/mysql.server start

 

3. Init.d 등록

cp -a support-files/mysql.server /etc/init.d/mysqld

cd /etc/rc3.d

ln -s ../init.d/mysqld S90mysqld

 

 

vi /etc/profile

source /etc/profile

/usr/local/mysql/bin/mysqladmin -u root -p password 'tyvldahftkdjqqn!#%&'

mysql -u root -p