[CentOS7] MySql 5.6 설치 및 설정

1. 참고 url

   1. https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/
   2. http://zero-gravity.tistory.com/274

2. yum repository 설치
   repo 설치가 안될경우 참고 : https://dejavuqa.tistory.com/349
   

   $ rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

3. yum repository 체크

   $ yum repolist all | grep mysql

4. yum repository 설정 (안하면 최신 mysql이 깔리니 5.6으로 설정필요)

   $ vi /etc/yum.repos.d/mysql-community.repo
   ---------------------------------------------------
   # Enable to use MySQL 5.6
   [mysql56-community]
   name=MySQL 5.6 Community Server
   baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/6/$basearch/
   enabled=1
   gpgcheck=1
   gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

5. yum repository 활성화

   $ yum repolist enabled | grep mysql

6. 설치

   $ yum install mysql-server

7. 실행 및 정지, 재구동 명령어

   $ systemctl start mysqld
   $ systemctl stop mysqld
   $ systemctl restart mysqld

8. 재부팅 후 바로 실행 환경변수 등록 

   $ systemctl enable mysqld

9. mysql 5.6 설정

   $ mysql_secure_installation

10. UTF-8설정

    1. /etc/my.conf 원본백업

       $ cp /etc/my.cnf /etc/my.cnf.ori

    2. /etc/my.conf  수정 (해당위치에 아래 설정파일 포함)

       $ vi /etc/my.cnf
       -------------------------------------
       [mysqld]
       collation-server = utf8_unicode_ci
       character-set-server = utf8

    3. 재구동

       $ systemctl restart mysqld

11. 계정 셋팅 https://hhseong.tistory.com/180

sudo yum update

sudo yum install wget

sudo wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm

sudo yum update