MySQL 5.7 에서 Warning 안뜨게 하는법 (MySQL 5.7 설치법)

1) 키 등록

mysql_config_editor set --login-path=client --host=localhost --user=root --password --socket=/tmp/mysql.sock --port=3306

 

2) 명령어 실행시 로그인 부분 --login-path=/root 대체

/home/mysql/bin/mysql --login-path=/root -e "show databases" | grep -v "Database"

 

 

 

yum -y install cmake ncurses-devel gcc-c++ bison

 

wget -P /root/src/ https://cdn.mysql.com/archives/mysql-5.7/mysql-boost-5.7.20.tar.gz

cd /root/src; tar xvzf mysql-boost-5.7.20.tar.gz; cd mysql-5.7.20

 

cmake -DCMAKE_INSTALL_PREFIX=/home/mysql -DWITH_INNOBASE_STORAGE_ENGINE=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DENABLED_LOCAL_INFILE=1 -DWITH_EXTRA_CHARSETS=all -DDOWNLOAD_BOOST=1 -DWITH_BOOST=boost

 

make -j `grep processor /proc/cpuinfo | wc -l`; make install

 

useradd -M -s /bin/false mysql

 

/home/mysql/bin/mysqld --initialize --user=mysql --datadir=/home/mysql/var

 

chown -R mysql. /home/mysql/

 

/home/mysql/support-files/mysql.server start

 

my.cnf 생성

[mysqld]

init_connect=SET collation_connection=utf8_general_ci

init_connect=SET NAMES utf8

character-set-server=utf8

collation-server=utf8_general_ci

table_open_cache=1024

max_connections=2048

max_user_connections=500

max_connect_errors=10000

wait_timeout=300

query_cache_type=1

query_cache_size=128M

query_cache_limit=5M

slow_query_log

long_query_time=3

max_allowed_packet=16M

sort_buffer_size=2M

skip-name-resolve

symbolic-links=0

 

[mysql]

default-character-set=utf8

 

 

cat /root/.mysql_secret

 

ALTER USER 'root'@'localhost' IDENTIFIED BY 'e54a4a8e';

flush privileges;

 

php 5.2연동할때

cd /opt/mysql/lib

for f in libmysqlclient.so*; do ln -s $f $(echo $f | sed s/libmysqlclient/libmysqlclient_r/); done

ln -s libmysqlclient.a libmysqlclient_r.a

 

 

1) mysql 설치 과정

 

mysql 5.7 설치과정 간략히 정리하여 안내해드립니다

mysql 5.7 버전에서는 기본적으로 boost 1.59 이상 설치가 되어있어야하며, 고객님의 서버에 설치되어있는 경로는 아래와 같습니다

boost : /usr/local/boost

boost 프로그램은 별도로 다운받아서 압축해제후 /usr/local에 복사해주시면 됩니다

boost 1.5.9 다운로드  :  wget http://sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz

tar zfvx boost_1_59_0.tar.gz;

cp -a boost_1_59_0  /usr/local/boost

mysql 5.7 다운로드및 설치

wget http://ftp.kaist.ac.kr/mysql/Downloads/MySQL-5.7/mysql-5.7.20.tar.gz

 

tar zvxf mysql-5.7.13.tar.gz; cd /root/src/mysql-5.7.13

cmake -DCMAKE_INSTALL_PREFIX=/home/mysql -DWITH_INNOBASE_STORAGE_ENGINE=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DENABLED_LOCAL_INFILE=1 -DWITH_EXTRA_CHARSETS=all -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/boost

make -j `grep processor /proc/cpuinfo | wc -l`; make install

 

2) mysql root 패스워드 변경

mysql root 패스워드 변경은 mysql 5.7 매뉴얼 참고하여 변경해드린부분입니다.

update user set authentication_string=password('vmffjtmdkfvk!!00') where user='root';

FLUSH PRIVILEGES;

 

ALTER USER 'root'@'localhost' IDENTIFIED BY 'qwer1234##$$';

flush privileges;