[DB] MYSQL 5.6 버전 설치

환경 

centos 6.5 desktop 버전

mysql-5.6.17 버전

5.5 부터 컴파일링은 ./configure 에서 cmake로 하면됨.

그이전 버전은 ./configure 사용

겁나빡침

[패키지 확인/삭제]

(1) rpm -qa | grep mysql

(2) yum remove -y mysql

//굳이 안해줘도 되는거 같습니다.

[라이브러리 설치]

yum -y install make cmake

yum -y install gcc g++ cpp gcc-c++

yum -y install ncurses-devel

yum -y install wget

yum -y install make cmake

yum -y install gcc g++ cpp gcc-c++

yum -y install perl

yum -y install ncurses-devel

yum -y install bison

yum -y install zlib curl

yum -y install openssl openssl-devel

yum -y install bzip2-devel

yum -y install libtermcap-devel libc-client-devel

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql--socket=/usr/local/mysql/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DMYSQL_DATADIR=/usr/local/mysql/data -DENABLED_LOCAL_INFILE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1

make && make install

cp support-files/mysql.server /etc/init.d/mysqld

[계정 생성/보안]

(1) useradd -M -s /bin/false mysql

(2) cat /etc/shadow

(3) cat /etc/group

정상적으로 셋팅되었는지 확인

＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃

/bin/false

allows a login, but no shell, no ssh tunnels and no home directory.

사용자 계정의 쉘부분에 /bin/false 로 설정을 하면

시스템의 로그인,FTP 서버 프로그램 불가능

쉘,SSH과 같은 터널링(원격접속), 홈디렉토리를 사용할 수 없다.

＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃

                                              

[다운로드]

 http://dev.mysql.com

cd /usr/local/src

wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.17.tar.gz

tar zxvf mysql-5.6.17.tar.gz

cd mysql-5.6.17.tar.gz

# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql--socket=/usr/local/mysql/tmp/mysql.sock \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DWITH_EXTRA_CHARSETS=all \

-DMYSQL_DATADIR=/usr/local/mysql/data \

-DENABLED_LOCAL_INFILE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql--socket=/usr/local/mysql/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DWITH_EXTRA_CHARSETS=all \-DMYSQL_DATADIR=/usr/local/mysql/data \-DENABLED_LOCAL_INFILE=1 \-DWITH_INNOBASE_STORAGE_ENGINE=1 \

make && make install

나중에정리점..

   1  useradd -M -s /bin/false mysql
    2  cd /usr/local/src
    3  ls
    4  wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.17.tar.gz
    5  tar zxvf mysql-5.6.17.tar.gz
    6  yum -y install make cmake
    7  ls
    8  sdfsdfsdfs
    9  cd mysql-5.6.17
   10  ls
   11  cmake
   12  -DCMAKE_INSTALL_PREFIX=/usr/local/mysql--socket=/usr/local/mysql/tmp/mysql.sock
   13  -DDEFAULT_CHARSET=utf8
   14  -DDEFAULT_COLLATION=utf8_general_ci
   15  -DWITH_EXTRA_CHARSETS=all
   16  -DMYSQL_DATADIR=/usr/local/mysql/data
   17  -DENABLED_LOCAL_INFILE=1
   18  -DWITH_INNOBASE_STORAGE_ENGINE=1
   19  cmake \
   20  -DCMAKE_INSTALL_PREFIX=/usr/local/mysql--socket=/usr/local/mysql/tmp/mysql.sock \
   21  -DDEFAULT_CHARSET=utf8 \
   22  -DDEFAULT_COLLATION=utf8_general_ci \
   23  -DWITH_EXTRA_CHARSETS=all \
   24  -DMYSQL_DATADIR=/usr/local/mysql/data \
   25  -DENABLED_LOCAL_INFILE=1 \
   26  -DWITH_INNOBASE_STORAGE_ENGINE=1 \
   27  cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql--socket=/usr/local/mysql/tmp/mysql.sock
   28  -DDEFAULT_CHARSET=utf8 \
   29  -DDEFAULT_COLLATION=utf8_general_ci \
   30  -DWITH_EXTRA_CHARSETS=all \
   31  -DMYSQL_DATADIR=/usr/local/mysql/data \
   32  -DENABLED_LOCAL_INFILE=1 \
   33  -DWITH_INNOBASE_STORAGE_ENGINE=1 \
   34  clear
   35  cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql--socket=/usr/local/mysql/tmp/mysql.sock
   36  -DDEFAULT_CHARSET=utf8 \
   37  -DDEFAULT_COLLATION=utf8_general_ci \
   38  -DWITH_EXTRA_CHARSETS=all \
   39  -DMYSQL_DATADIR=/usr/local/mysql/data \
   40  -DENABLED_LOCAL_INFILE=1 \
   41  -DWITH_INNOBASE_STORAGE_ENGINE=1
   42  cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql--socket=/usr/local/mysql/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DWITH_EXTRA_CHARSETS=all \-DMYSQL_DATADIR=/usr/local/mysql/data \-DENABLED_LOCAL_INFILE=1 \-DWITH_INNOBASE_STORAGE_ENGINE=1
   43  cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql--socket=/usr/local/mysql/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DMYSQL_DATADIR=/usr/local/mysql/data -DENABLED_LOCAL_INFILE=1 DWITH_INNOBASE_STORAGE_ENGINE=1 .
   44  ls
   45  rm CMakeCache.txt
   46  cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql--socket=/usr/local/mysql/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DMYSQL_DATADIR=/usr/local/mysql/data -DENABLED_LOCAL_INFILE=1 DWITH_INNOBASE_STORAGE_ENGINE=1 .
   47  yum -y install gcc g++ cpp gcc-c++
   48  ls
   49  rm -Rf CMakeCache.txt
   50  ls
   51  cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql--socket=/usr/local/mysql/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DMYSQL_DATADIR=/usr/local/mysql/data -DENABLED_LOCAL_INFILE=1 DWITH_INNOBASE_STORAGE_ENGINE=1 .
   52  rm -Rf CMakeCache.txt
   53  yum -y install ncurses-devel
   54  cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql--socket=/usr/local/mysql/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DMYSQL_DATADIR=/usr/local/mysql/data -DENABLED_LOCAL_INFILE=1 DWITH_INNOBASE_STORAGE_ENGINE=1 .
   55  make && make install
   56  ls
   57  cp support-files/mysql.server /etc/init.d/mysqld
   58  chmod 777 /etc/init.d/mysqld
   59  vi /etc/my.cnf
   60  rm -rf /etc/my.cnf
   61  ifconfig
   62  mkdir /usr/local/mysql/tmp
   63  vi /etc/my.cnf
   64  chown -R mysql:mysql /usr/local/mysql
   65  /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
   66  /etc/init.d/mysqld start
   67  mysql
   68  cd /usr/local/mysql/bin/mysql
   69  /usr/local/mysql/bin/mysql
   70  ifconfig
   71  cd /etc/sysconfig
   72  ls
   73  vi iptables
   74  ps -ef | grep iptables
   75  service iptables stop
   76  mysql
   77  service iptables stop
   78  ls
   79  ifconfig
   80  mysql
   81  cd /usr/local/mysql/bin/
   82  ls
   83  mysql
   84  cd mysql
   85  cd ..
   86  ls
   87  mysql-test/
   88  ls
   89  pwd
   90  cd bin/mysql
   91  /bin/mysql
   92  cd bing
   93  ./mysql-test/
   94  cd bing
   95  cd bin
   96  ./mysql
   97  ls
   98  history

계정 권한주기

GRANT ALL PRIVILEGES ON test_db.* TO 'root'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip%';