CentOS7에 mysql 5.7 설치

CentOS7에서 mysql 5.7버전을 사용하기 위해 yum repository package 다운로드
wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm

패키지 설치
sudo yum localinstall mysql57-community-release-el7-7.noarch.rpm

Mysql repository 활성화
sudo yum repolist enabled | grep "mysql.*-community.*"

Mysql 설치
sudo yum install mysql-server # 필요하면 추가로 설치 mysql-community-server mysql mysql-libs mysql-devel

Mysql 서비스 시작
sudo systemctl start mysqld

root 초기 패스워드 확인 (5.7버전부터)
sudo grep 'temporary password' /var/log/mysqld.log

Mysql 서버 접속 후 root 패스워드 변경
mysql -u root -p
패스워드 입력
 
mysql> use mysql;
mysql> set password = password('패스워드');
mysql> flush privileges;

보안 설정(옵션)
sudo mysql_secure_installation

원격접속
use mysql;
SELECT Host,User,authentication_string FROM mysql.user;

INSERT INTO mysql.user (host,user,authentication_string,ssl_cipher, x509_issuer, x509_subject) VALUES ('%','계정',password('패스워드'),'','','');
GRANT ALL PRIVILEGES ON *.* TO '계정'@'%';
FLUSH PRIVILEGES;

권한 추가
GRANT ALL PRIVILEGES ON DB명.* to 계정@'%' identified by '패스워드'
FLUSH PRIVILEGES;

CentOS 7.x Clang 6.0 설치

# 다운로드
wget http://releases.llvm.org/6.0.0/llvm-6.0.0.src.tar.xz
wget http://releases.llvm.org/6.0.0/cfe-6.0.0.src.tar.xz
wget http://releases.llvm.org/6.0.0/libcxx-6.0.0.src.tar.xz
wget http://releases.llvm.org/6.0.0/libcxxabi-6.0.0.src.tar.xz

unxz llvm-6.0.0.src.tar.xz
unxz cfe-6.0.0.src.tar.xz
unxz libcxx-6.0.0.src.tar.xz
unxz libcxxabi-6.0.0.src.tar.xz

tar -xvf llvm-6.0.0.src.tar
tar -xvf cfe-6.0.0.src.tar
tar -xvf libcxx-6.0.0.src.tar
tar -xvf libcxxabi-6.0.0.src.tar

# 아래에서 이 이름을 기준으로 빌드 방법을 설명할것이므로 변경하는게 좋음
mv llvm-6.0.0.src llvm
mv cfe-6.0.0.src clang
mv libcxx-6.0.0.src libcxx
mv libcxxabi-6.0.0.src libcxxabi

#llvm 빌드
mv clang ./llvm/tools
mkdir llvm.build
cd llvm.build
cmake -G "Unix Makefiles" -DCMAKE_BUILD_TYPE=Release -DCMAKE_INSTALL_PREFIX=/usr/local ../llvm
make
sudo make install
cd ..

#libcxx, libcxxabi 빌드
# 1st round to build libcxx without libcxxabi
cd libcxx
mkdir tmp
cd tmp
cmake -DCMAKE_BUILD_TYPE=Release -DCMAKE_INSTALL_PREFIX=/usr/local/ -DCMAKE_C_COMPILER=clang -DCMAKE_CXX_COMPILER=clang++ ..
make
sudo make install
cd ..
rm tmp -rf
cd ..

# Build libcxxabi with libc++
cd libcxxabi

mkdir tmp

cd tmp
cmake -DCMAKE_BUILD_TYPE=Release -DCMAKE_INSTALL_PREFIX=/usr/local -DCMAKE_C_COMPILER=clang -DCMAKE_CXX_COMPILER=clang++ -DLIBCXXABI_LIBCXX_INCLUDES=../../libcxx/include ..
make
sudo make install
cd ../..

# 2nd round to build libcxx with libcxxabi
cd libcxx
mkdir tmp
cd tmp
# This time, we want to compile libcxx with libcxxabi, so we have to specify LIBCXX_CXX_ABI=libcxxabi and the path to libcxxabi headers, LIBCXX_LIBCXXABI_INCLUDE_PATHS.
cmake -DCMAKE_BUILD_TYPE=Release -DCMAKE_INSTALL_PREFIX=/usr/local -DCMAKE_C_COMPILER=clang -DCMAKE_CXX_COMPILER=clang++ -DLIBCXX_CXX_ABI=libcxxabi -DLIBCXX_CXX_ABI_INCLUDE_PATHS=../../libcxxabi/include ..
make
sudo make install
cd ../..

CentOS7에 cmake 3.11.0 설치

wget https://cmake.org/files/v3.11/cmake-3.11.0.tar.gz

tar -zxf cmake-3.11.0.tar.gz

cd cmake-3.11.0

./bootstrap

make

sudo make install