CentOS7 에서 MySQL 8.0 소스 설치

필수 패키지 설치

# yum -y install cmake ncurses-devel gcc* openssl openssl-devel

계정 추가

# groupadd -g 400 mysql

# useradd -u400 -g400 -d /usr/local/mysql -s /bin/false mysql

설치

# cd /usr/local/src

# wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.12.tar.gz

# tar xvfz mysql-8.0.12.tar.gz 

# cd mysql-8.0.12

# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DENABLED_LOCAL_INFILE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DSYSCONFDIR=/etc -DDEFAULT_CHARSET=utf8 -DWITH_SSL=system -DMYSQL_TCP_PORT=3306 -DWITH_EXTRA_CHARSETS=all -DDEFAULT_COLLATION=utf8_general_ci -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/include/boost

# make

# make install

초기 데이터 베이스 구성 및 권한 설정

# cd

# /usr/local/mysql/bin/mysqld --initialize-insecure --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql

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

# chmod 711 /usr/local/mysql

# chmod 700 /usr/local/mysql/data

# chmod 751 /usr/local/mysql/bin/

# chmod 750 /usr/local/mysql/bin/*

# chmod 755 /usr/local/mysql/bin/mysql

# chmod 755 /usr/local/mysql/bin/mysqldump

boost 설치

# cd /usr/local/include/boost/boost_1_66_0    // boost 버전이 다를 수 있음

# ./bootstrap.sh 

# ./b2 install

자동 실행 설정 및 기타 파일 적용

# vi /etc/my.cnf

[mysqld] datadir=/usr/local/mysql/data basedir=/usr/local/mysql/ port=3306 socket=/tmp/mysql.sock [mysqld_safe] log-error=/var/log/mysql_log.err pid-file=/usr/local/mysql/mysql.pid

# cp -arp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

# chkconfig --add mysqld

# chkconfig mysqld on

이후 작업

- iptables 방화벽 설정 (tcp 3306 추가)

- root 패스워드 업데이트