MySQL 5.7 source 설치

가. 설치

# yum groupinstall "Development Tools"

# wget http://downloads.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz
# tar xvfz boost_1_59_0.tar.gz

#yum install openssl-devel
#yum install openssl
#yum install ncurses-devel

 

#cmake . -DCMAKE_INSTALL_PREFIX=/home/o2olab/apps/mysql -DMYSQL_DATADIR=/home/o2olab/data -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_general_ci -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/home/o2olab/apps/boost_1_59_0 -DMYSQL_TCP_PORT=8088 -DMYSQL_UNIX_ADDR=/home/o2olab/data/mysql.sock -DMYSQL_USER=o2olab

 

#make && make install

 

나. 기본설정

$cd /home/o2olab/apps/mysql/support-files

$cp ./mysql.server ..

$mkdir /home/o2olab/apps/mysql/logs

 

$./bin/mysqld --initialize --user=o2olab --datadir=/home/o2olab/data
2021-06-24T12:04:48.221748+09:00 1 [Note] A temporary password is generated for root@localhost: 초기루트비밀번호

 

$./mysql.server start

 

다. 접속후 초기 비밀번호 변경

mysql>create USER 'user'@'%' IDENTIFIED BY 'password';