MySQL 5.7 rpm 설치

MySQL 5.7 rpm 설치

MySQL 5.7 rpm으로 설치를 진행 해보겠다

먼저 다운로드를 받는다 http://dev.mysql.com/downloads/mysql/ (새창) 로 가서

다운받은 후 원하는 위치에 전송을 해두고 진행을 하도록 하자

/my/rpm 경로에 mysql-5.7.13-1.el6.i686.rpm-bundle.tar 라는 이름으로 저장 후 진행 하였다

tar 풀기

[root@localhost rpm]# tar -xvf mysql-5.7.13-1.el6.i686.rpm-bundle.tar mysql-community-libs-5.7.13-1.el6.i686.rpm mysql-community-embedded-5.7.13-1.el6.i686.rpm mysql-community-server-5.7.13-1.el6.i686.rpm mysql-community-test-5.7.13-1.el6.i686.rpm mysql-community-common-5.7.13-1.el6.i686.rpm mysql-community-devel-5.7.13-1.el6.i686.rpm mysql-community-libs-compat-5.7.13-1.el6.i686.rpm mysql-community-client-5.7.13-1.el6.i686.rpm mysql-community-embedded-devel-5.7.13-1.el6.i686.rpm

rpm 설치 순서

설치 순서는 common -> libs -> libs-compat -> embedded -> embedded-devel -> client -> server 순으로 설치한다

mysql-community-common 설치

[root@localhost rpm]# rpm -Uvh mysql-community-common-5.7.13-1.el6.i686.rpm warning: mysql-community-common-5.7.13-1.el6.i686.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing...                ########################################### [100%] file /usr/share/mysql/czech/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/danish/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/dutch/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/english/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/estonian/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/french/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/german/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/greek/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/hungarian/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/italian/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/japanese/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/korean/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/norwegian-ny/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/norwegian/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/polish/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/portuguese/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/romanian/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/russian/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/serbian/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/slovak/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/spanish/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/swedish/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/ukrainian/errmsg.sys from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/Index.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/armscii8.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/ascii.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/cp1250.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/cp1256.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/cp1257.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/cp850.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/cp852.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/cp866.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/dec8.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/geostd8.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/greek.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/hebrew.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/hp8.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/keybcs2.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/koi8r.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/koi8u.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/latin1.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/latin2.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/latin5.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/latin7.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/macce.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/macroman.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 file /usr/share/mysql/charsets/swe7.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 [root@localhost rpm]#

음? conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64

설치를 하려했더니 충돌이 난다고 친절하게 알려준다 linux 설치시 mysql 관련 라이브러리가 설치되어있어서 그렇다

지워주도록 하자

mysql-libs-5.1.71-1.el6.x86_64 삭제

file /usr/share/mysql/charsets/swe7.xml from install of mysql-community-common-5.7.13-1.el6.i686 conflicts with file from package mysql-libs-5.1.71-1.el6.x86_64 [root@localhost rpm]# yum remove mysql-libs-5.1.71-1.el6.x86_64 Loaded plugins: fastestmirror, refresh-packagekit, security Setting up Remove Process Resolving Dependencies --> Running transaction check ---> Package mysql-libs.x86_64 0:5.1.71-1.el6 will be erased --> Processing Dependency: libmysqlclient.so.16()(64bit) for package: 2:postfix-2.6.6-2.2.el6_1.x86_64 --> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: 2:postfix-2.6.6-2.2.el6_1.x86_64 --> Processing Dependency: mysql-libs for package: 2:postfix-2.6.6-2.2.el6_1.x86_64 --> Running transaction check ---> Package postfix.x86_64 2:2.6.6-2.2.el6_1 will be erased --> Processing Dependency: /usr/sbin/sendmail for package: cronie-1.4.4-12.el6.x86_64 --> Running transaction check ---> Package cronie.x86_64 0:1.4.4-12.el6 will be erased --> Processing Dependency: cronie = 1.4.4-12.el6 for package: cronie-anacron-1.4.4-12.el6.x86_64 --> Running transaction check ---> Package cronie-anacron.x86_64 0:1.4.4-12.el6 will be erased --> Processing Dependency: /etc/cron.d for package: crontabs-1.10-33.el6.noarch --> Processing Dependency: /etc/cron.d for package: sysstat-9.0.4-22.el6.x86_64 --> Restarting Dependency Resolution with new changes. --> Running transaction check ---> Package crontabs.noarch 0:1.10-33.el6 will be erased ---> Package sysstat.x86_64 0:9.0.4-22.el6 will be erased --> Finished Dependency Resolution base                                                                                                                                                                                                                                     | 3.7 kB     00:00      base/primary_db                                                                                                                                                                                                                          | 4.7 MB     00:37      extras                                                                                                                                                                                                                                   | 3.4 kB     00:00      extras/primary_db                                                                                                                                                                                                                        |  36 kB     00:00      updates                                                                                                                                                                                                                                  | 3.4 kB     00:00      updates/primary_db                                                                                                                                                                                                                       | 732 kB     00:00      Dependencies Resolved ================================================================================================================================================================================================================================================================  Package                                                  Arch                                             Version                                                     Repository                                                                          Size ================================================================================================================================================================================================================================================================ Removing:  mysql-libs                                               x86_64                                           5.1.71-1.el6                                                @anaconda-CentOS-201311272149.x86_64/6.5                                           4.0 M Removing for dependencies:  cronie                                                   x86_64                                           1.4.4-12.el6                                                @anaconda-CentOS-201311272149.x86_64/6.5                                           174 k  cronie-anacron                                           x86_64                                           1.4.4-12.el6                                                @anaconda-CentOS-201311272149.x86_64/6.5                                            43 k  crontabs                                                 noarch                                           1.10-33.el6                                                 @anaconda-CentOS-201311272149.x86_64/6.5                                           2.4 k  postfix                                                  x86_64                                           2:2.6.6-2.2.el6_1                                           @anaconda-CentOS-201311272149.x86_64/6.5                                           9.7 M  sysstat                                                  x86_64                                           9.0.4-22.el6                                                @anaconda-CentOS-201311272149.x86_64/6.5                                           824 k Transaction Summary ================================================================================================================================================================================================================================================================ Remove        6 Package(s) Installed size: 15 M Is this ok [y/N]: y Downloading Packages: Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction   Erasing    : sysstat-9.0.4-22.el6.x86_64                                                                                                                                                                                                                  1/6    Erasing    : cronie-1.4.4-12.el6.x86_64                                                                                                                                                                                                                   2/6    Erasing    : cronie-anacron-1.4.4-12.el6.x86_64                                                                                                                                                                                                           3/6    Erasing    : crontabs-1.10-33.el6.noarch                                                                                                                                                                                                                  4/6    Erasing    : 2:postfix-2.6.6-2.2.el6_1.x86_64                                                                                                                                                                                                             5/6    Erasing    : mysql-libs-5.1.71-1.el6.x86_64                                                                                                                                                                                                               6/6    Verifying  : cronie-anacron-1.4.4-12.el6.x86_64                                                                                                                                                                                                           1/6    Verifying  : 2:postfix-2.6.6-2.2.el6_1.x86_64                                                                                                                                                                                                             2/6    Verifying  : mysql-libs-5.1.71-1.el6.x86_64                                                                                                                                                                                                               3/6    Verifying  : crontabs-1.10-33.el6.noarch                                                                                                                                                                                                                  4/6    Verifying  : sysstat-9.0.4-22.el6.x86_64                                                                                                                                                                                                                  5/6    Verifying  : cronie-1.4.4-12.el6.x86_64                                                                                                                                                                                                                   6/6  Removed:   mysql-libs.x86_64 0:5.1.71-1.el6                                                                                                                                                                                                                               Dependency Removed:   cronie.x86_64 0:1.4.4-12.el6                    cronie-anacron.x86_64 0:1.4.4-12.el6                    crontabs.noarch 0:1.10-33.el6                    postfix.x86_64 2:2.6.6-2.2.el6_1                    sysstat.x86_64 0:9.0.4-22.el6                    Complete! [root@localhost rpm]#

중간에 Y를 입력해준다

제거가 완료되었다면 다시 설치를 진행한다

mysql-community-common-5.7.13-1.el6.i686.rpm

[root@localhost rpm]# rpm -Uvh mysql-community-common-5.7.13-1.el6.i686.rpm warning: mysql-community-common-5.7.13-1.el6.i686.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing...                ########################################### [100%]    1:mysql-community-common ########################################### [100%] [root@localhost rpm]#

mysql-community-libs-5.7.13-1.el6.i686.rpm 

[root@localhost rpm]# rpm -Uvh mysql-community-libs-5.7.13-1.el6.i686.rpm  warning: mysql-community-libs-5.7.13-1.el6.i686.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY error: Failed dependencies: libc.so.6 is needed by mysql-community-libs-5.7.13-1.el6.i686 libc.so.6(GLIBC_2.0) is needed by mysql-community-libs-5.7.13-1.el6.i686 libc.so.6(GLIBC_2.1) is needed by mysql-community-libs-5.7.13-1.el6.i686 libc.so.6(GLIBC_2.1.3) is needed by mysql-community-libs-5.7.13-1.el6.i686 libc.so.6(GLIBC_2.2) is needed by mysql-community-libs-5.7.13-1.el6.i686 libc.so.6(GLIBC_2.3.4) is needed by mysql-community-libs-5.7.13-1.el6.i686 libc.so.6(GLIBC_2.4) is needed by mysql-community-libs-5.7.13-1.el6.i686 libdl.so.2 is needed by mysql-community-libs-5.7.13-1.el6.i686 libdl.so.2(GLIBC_2.0) is needed by mysql-community-libs-5.7.13-1.el6.i686 libdl.so.2(GLIBC_2.1) is needed by mysql-community-libs-5.7.13-1.el6.i686 libgcc_s.so.1 is needed by mysql-community-libs-5.7.13-1.el6.i686 libgcc_s.so.1(GCC_3.0) is needed by mysql-community-libs-5.7.13-1.el6.i686 libgcc_s.so.1(GLIBC_2.0) is needed by mysql-community-libs-5.7.13-1.el6.i686 libm.so.6 is needed by mysql-community-libs-5.7.13-1.el6.i686 libm.so.6(GLIBC_2.0) is needed by mysql-community-libs-5.7.13-1.el6.i686 libpthread.so.0 is needed by mysql-community-libs-5.7.13-1.el6.i686 libpthread.so.0(GLIBC_2.0) is needed by mysql-community-libs-5.7.13-1.el6.i686 libpthread.so.0(GLIBC_2.1) is needed by mysql-community-libs-5.7.13-1.el6.i686 libpthread.so.0(GLIBC_2.2) is needed by mysql-community-libs-5.7.13-1.el6.i686 librt.so.1 is needed by mysql-community-libs-5.7.13-1.el6.i686 libstdc++.so.6 is needed by mysql-community-libs-5.7.13-1.el6.i686 libstdc++.so.6(CXXABI_1.3) is needed by mysql-community-libs-5.7.13-1.el6.i686 libstdc++.so.6(GLIBCXX_3.4) is needed by mysql-community-libs-5.7.13-1.el6.i686

그러하다..... 설치가 잘 되지 않는다

libc.so.6, libdl.so.2, libgcc_s.so.1 ... 등등등 이 필요하고 설치방법은

yum install libc.so.6 으로 설치가 가능하다

yum install libc.so.6 

[root@localhost rpm]# rpm -Uvh mysql-community-libs-5.7.13-1.el6.i686.rpm  warning: mysql-community-libs-5.7.13-1.el6.i686.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY error: Failed dependencies: libc.so.6 is needed by mysql-community-libs-5.7.13-1.el6.i686 libc.so.6(GLIBC_2.0) is needed by mysql-community-libs-5.7.13-1.el6.i686 libc.so.6(GLIBC_2.1) is needed by mysql-community-libs-5.7.13-1.el6.i686 libc.so.6(GLIBC_2.1.3) is needed by mysql-community-libs-5.7.13-1.el6.i686 libc.so.6(GLIBC_2.2) is needed by mysql-community-libs-5.7.13-1.el6.i686 libc.so.6(GLIBC_2.3.4) is needed by mysql-community-libs-5.7.13-1.el6.i686 libc.so.6(GLIBC_2.4) is needed by mysql-community-libs-5.7.13-1.el6.i686 libdl.so.2 is needed by mysql-community-libs-5.7.13-1.el6.i686 libdl.so.2(GLIBC_2.0) is needed by mysql-community-libs-5.7.13-1.el6.i686 libdl.so.2(GLIBC_2.1) is needed by mysql-community-libs-5.7.13-1.el6.i686 libgcc_s.so.1 is needed by mysql-community-libs-5.7.13-1.el6.i686 libgcc_s.so.1(GCC_3.0) is needed by mysql-community-libs-5.7.13-1.el6.i686 libgcc_s.so.1(GLIBC_2.0) is needed by mysql-community-libs-5.7.13-1.el6.i686 libm.so.6 is needed by mysql-community-libs-5.7.13-1.el6.i686 libm.so.6(GLIBC_2.0) is needed by mysql-community-libs-5.7.13-1.el6.i686 libpthread.so.0 is needed by mysql-community-libs-5.7.13-1.el6.i686 libpthread.so.0(GLIBC_2.0) is needed by mysql-community-libs-5.7.13-1.el6.i686 libpthread.so.0(GLIBC_2.1) is needed by mysql-community-libs-5.7.13-1.el6.i686 libpthread.so.0(GLIBC_2.2) is needed by mysql-community-libs-5.7.13-1.el6.i686 librt.so.1 is needed by mysql-community-libs-5.7.13-1.el6.i686 libstdc++.so.6 is needed by mysql-community-libs-5.7.13-1.el6.i686 libstdc++.so.6(CXXABI_1.3) is needed by mysql-community-libs-5.7.13-1.el6.i686 libstdc++.so.6(GLIBCXX_3.4) is needed by mysql-community-libs-5.7.13-1.el6.i686 [root@localhost rpm]# yum install libc.so.6 Loaded plugins: fastestmirror, refresh-packagekit, security Loading mirror speeds from cached hostfile  * base: centos.mirror.cdnetworks.com  * extras: centos.mirror.cdnetworks.com  * updates: centos.mirror.cdnetworks.com Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package glibc.i686 0:2.12-1.192.el6 will be installed --> Processing Dependency: glibc-common = 2.12-1.192.el6 for package: glibc-2.12-1.192.el6.i686 --> Processing Dependency: libfreebl3.so(NSSRAWHASH_3.12.3) for package: glibc-2.12-1.192.el6.i686 --> Processing Dependency: libfreebl3.so for package: glibc-2.12-1.192.el6.i686 --> Running transaction check ---> Package glibc-common.x86_64 0:2.12-1.132.el6 will be updated --> Processing Dependency: glibc-common = 2.12-1.132.el6 for package: glibc-2.12-1.132.el6.x86_64 ---> Package glibc-common.x86_64 0:2.12-1.192.el6 will be an update --> Processing Dependency: tzdata >= 2015g-4 for package: glibc-common-2.12-1.192.el6.x86_64 ---> Package nss-softokn-freebl.x86_64 0:3.14.3-9.el6 will be updated ---> Package nss-softokn-freebl.i686 0:3.14.3-23.el6_7 will be installed ---> Package nss-softokn-freebl.x86_64 0:3.14.3-23.el6_7 will be an update --> Running transaction check ---> Package glibc.x86_64 0:2.12-1.132.el6 will be updated --> Processing Dependency: glibc = 2.12-1.132.el6 for package: glibc-headers-2.12-1.132.el6.x86_64 --> Processing Dependency: glibc = 2.12-1.132.el6 for package: glibc-devel-2.12-1.132.el6.x86_64 ---> Package glibc.x86_64 0:2.12-1.192.el6 will be an update ---> Package tzdata.noarch 0:2013g-1.el6 will be updated ---> Package tzdata.noarch 0:2016d-1.el6 will be an update --> Running transaction check ---> Package glibc-devel.x86_64 0:2.12-1.132.el6 will be updated ---> Package glibc-devel.x86_64 0:2.12-1.192.el6 will be an update ---> Package glibc-headers.x86_64 0:2.12-1.132.el6 will be updated ---> Package glibc-headers.x86_64 0:2.12-1.192.el6 will be an update --> Finished Dependency Resolution Dependencies Resolved ================================================================================================================================================================================================================================================================  Package                                                             Arch                                                    Version                                                             Repository                                                Size ================================================================================================================================================================================================================================================================ Installing:  glibc                                                               i686                                                    2.12-1.192.el6                                                      base                                                     4.4 M Installing for dependencies:  nss-softokn-freebl                                                  i686                                                    3.14.3-23.el6_7                                                     base                                                     157 k Updating for dependencies:  glibc                                                               x86_64                                                  2.12-1.192.el6                                                      base                                                     3.8 M  glibc-common                                                        x86_64                                                  2.12-1.192.el6                                                      base                                                      14 M  glibc-devel                                                         x86_64                                                  2.12-1.192.el6                                                      base                                                     988 k  glibc-headers                                                       x86_64                                                  2.12-1.192.el6                                                      base                                                     617 k  nss-softokn-freebl                                                  x86_64                                                  3.14.3-23.el6_7                                                     base                                                     167 k  tzdata                                                              noarch                                                  2016d-1.el6                                                         updates                                                  451 k Transaction Summary ================================================================================================================================================================================================================================================================ Install       2 Package(s) Upgrade       6 Package(s) Total download size: 25 M Is this ok [y/N]: y Downloading Packages: (1/8): glibc-2.12-1.192.el6.i686.rpm                                                                                                                                                                                                     | 4.4 MB     00:00      (2/8): glibc-2.12-1.192.el6.x86_64.rpm                                                                                                                                                                                                   | 3.8 MB     00:00      (3/8): glibc-common-2.12-1.192.el6.x86_64.rpm                                                                                                                                                                                            |  14 MB     00:02      (4/8): glibc-devel-2.12-1.192.el6.x86_64.rpm                                                                                                                                                                                             | 988 kB     00:00      (5/8): glibc-headers-2.12-1.192.el6.x86_64.rpm                                                                                                                                                                                           | 617 kB     00:00      (6/8): nss-softokn-freebl-3.14.3-23.el6_7.i686.rpm                                                                                                                                                                                       | 157 kB     00:00      (7/8): nss-softokn-freebl-3.14.3-23.el6_7.x86_64.rpm                                                                                                                                                                                     | 167 kB     00:00      (8/8): tzdata-2016d-1.el6.noarch.rpm                                                                                                                                                                                                     | 451 kB     00:00      ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total                                                                                                                                                                                                                           3.4 MB/s |  25 MB     00:07      warning: rpmts_HdrFromFdno: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6 Importing GPG key 0xC105B9DE:  Userid : CentOS-6 Key (CentOS 6 Official Signing Key) <centos-6-key@centos.org>  Package: centos-release-6-5.el6.centos.11.1.x86_64 (@anaconda-CentOS-201311272149.x86_64/6.5)  From   : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6 Is this ok [y/N]: y Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Warning: RPMDB altered outside of yum.   Updating   : tzdata-2016d-1.el6.noarch                                                                                                                                                                                                                   1/14    Updating   : glibc-common-2.12-1.192.el6.x86_64                                                                                                                                                                                                          2/14    Updating   : glibc-2.12-1.192.el6.x86_64                                                                                                                                                                                                                 3/14    Updating   : nss-softokn-freebl-3.14.3-23.el6_7.x86_64                                                                                                                                                                                                   4/14    Updating   : glibc-headers-2.12-1.192.el6.x86_64                                                                                                                                                                                                         5/14    Installing : glibc-2.12-1.192.el6.i686                                                                                                                                                                                                                   6/14    Installing : nss-softokn-freebl-3.14.3-23.el6_7.i686                                                                                                                                                                                                     7/14    Updating   : glibc-devel-2.12-1.192.el6.x86_64                                                                                                                                                                                                           8/14    Cleanup    : glibc-devel-2.12-1.132.el6.x86_64                                                                                                                                                                                                           9/14    Cleanup    : glibc-headers-2.12-1.132.el6.x86_64                                                                                                                                                                                                        10/14    Cleanup    : glibc-common-2.12-1.132.el6.x86_64                                                                                                                                                                                                         11/14    Cleanup    : nss-softokn-freebl-3.14.3-9.el6.x86_64                                                                                                                                                                                                     12/14    Cleanup    : glibc-2.12-1.132.el6.x86_64                                                                                                                                                                                                                13/14    Cleanup    : tzdata-2013g-1.el6.noarch                                                                                                                                                                                                                  14/14    Verifying  : nss-softokn-freebl-3.14.3-23.el6_7.i686                                                                                                                                                                                                     1/14    Verifying  : glibc-devel-2.12-1.192.el6.x86_64                                                                                                                                                                                                           2/14    Verifying  : glibc-headers-2.12-1.192.el6.x86_64                                                                                                                                                                                                         3/14    Verifying  : nss-softokn-freebl-3.14.3-23.el6_7.x86_64                                                                                                                                                                                                   4/14    Verifying  : glibc-2.12-1.192.el6.i686                                                                                                                                                                                                                   5/14    Verifying  : glibc-2.12-1.192.el6.x86_64                                                                                                                                                                                                                 6/14    Verifying  : glibc-common-2.12-1.192.el6.x86_64                                                                                                                                                                                                          7/14    Verifying  : tzdata-2016d-1.el6.noarch                                                                                                                                                                                                                   8/14    Verifying  : nss-softokn-freebl-3.14.3-9.el6.x86_64                                                                                                                                                                                                      9/14    Verifying  : glibc-2.12-1.132.el6.x86_64                                                                                                                                                                                                                10/14    Verifying  : glibc-devel-2.12-1.132.el6.x86_64                                                                                                                                                                                                          11/14    Verifying  : tzdata-2013g-1.el6.noarch                                                                                                                                                                                                                  12/14    Verifying  : glibc-common-2.12-1.132.el6.x86_64                                                                                                                                                                                                         13/14    Verifying  : glibc-headers-2.12-1.132.el6.x86_64                                                                                                                                                                                                        14/14  Installed:   glibc.i686 0:2.12-1.192.el6                                                                                                                                                                                                                                    Dependency Installed:   nss-softokn-freebl.i686 0:3.14.3-23.el6_7                                                                                                                                                                                                                      Dependency Updated:   glibc.x86_64 0:2.12-1.192.el6        glibc-common.x86_64 0:2.12-1.192.el6        glibc-devel.x86_64 0:2.12-1.192.el6        glibc-headers.x86_64 0:2.12-1.192.el6        nss-softokn-freebl.x86_64 0:3.14.3-23.el6_7        tzdata.noarch 0:2016d-1.el6        Complete! [root@localhost rpm]#

자 다음

yum install libgcc_s.so.1

[root@localhost rpm]# yum install libgcc_s.so.1 Loaded plugins: fastestmirror, refresh-packagekit, security Loading mirror speeds from cached hostfile  * base: centos.mirror.cdnetworks.com  * extras: centos.mirror.cdnetworks.com  * updates: centos.mirror.cdnetworks.com Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package libgcc.i686 0:4.4.7-17.el6 will be installed --> Finished Dependency Resolution Error:  Multilib version problems found. This often means that the root        cause is something else and multilib version checking is just        pointing out that there is a problem. Eg.:                  1. You have an upgrade for libgcc which is missing some             dependency that another package requires. Yum is trying to             solve this by installing an older version of libgcc of the             different architecture. If you exclude the bad architecture             yum will tell you what the root cause is (which package             requires what). You can try redoing the upgrade with             --exclude libgcc.otherarch ... this should give you an error             message showing the root cause of the problem.                  2. You have multiple architectures of libgcc installed, but             yum can only see an upgrade for one of those arcitectures.             If you don't want/need both architectures anymore then you             can remove the one with the missing update and everything             will work.                  3. You have duplicate versions of libgcc installed already.             You can use "yum check" to get yum show these errors.                ...you can also use --setopt=protected_multilib=false to remove        this checking, however this is almost never the correct thing to        do as something else is very likely to go wrong (often causing        much more problems).                Protected multilib versions: libgcc-4.4.7-17.el6.i686 != libgcc-4.4.7-4.el6.x86_64  You could try using --skip-broken to work around the problem  You could try running: rpm -Va --nofiles --nodigest

yum install libgcc_s.so.1 를 했더니 설치를 안해준다

1. You have an upgrade for libgcc which is missing some dependency that another package requires.

dependency로 인한 libgcc 업그레이드 필요

그럼 libgcc를 설치하자

yum install libgcc

[root@localhost rpm]# yum install libgcc Loaded plugins: fastestmirror, refresh-packagekit, security Loading mirror speeds from cached hostfile  * base: centos.mirror.cdnetworks.com  * extras: centos.mirror.cdnetworks.com  * updates: centos.mirror.cdnetworks.com Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package libgcc.x86_64 0:4.4.7-4.el6 will be updated ---> Package libgcc.x86_64 0:4.4.7-17.el6 will be an update --> Finished Dependency Resolution Dependencies Resolved ================================================================================================================================================================================================================================================================  Package                                                      Arch                                                         Version                                                             Repository                                                  Size ================================================================================================================================================================================================================================================================ Updating:  libgcc                                                       x86_64                                                       4.4.7-17.el6                                                        base                                                       103 k Transaction Summary ================================================================================================================================================================================================================================================================ Upgrade       1 Package(s) Total download size: 103 k Is this ok [y/N]: y Downloading Packages: libgcc-4.4.7-17.el6.x86_64.rpm                                                                                                                                                                                                           | 103 kB     00:00      Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction   Updating   : libgcc-4.4.7-17.el6.x86_64                                                                                                                                                                                                                   1/2    Cleanup    : libgcc-4.4.7-4.el6.x86_64                                                                                                                                                                                                                    2/2    Verifying  : libgcc-4.4.7-17.el6.x86_64                                                                                                                                                                                                                   1/2    Verifying  : libgcc-4.4.7-4.el6.x86_64                                                                                                                                                                                                                    2/2  Updated:   libgcc.x86_64 0:4.4.7-17.el6                                                                                                                                                                                                                                   Complete!

성공 

다른것들도 동일한 방식으로 진행한다

rpm -Uvh mysql-community-libs-5.7.13-1.el6.i686.rpm

[root@localhost rpm]# rpm -Uvh mysql-community-libs-5.7.13-1.el6.i686.rpm warning: mysql-community-libs-5.7.13-1.el6.i686.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing...                ########################################### [100%]    1:mysql-community-libs   ########################################### [100%]

rpm -Uvh mysql-community-libs-compat-5.7.13-1.el6.i686.rpm

[root@localhost rpm]# rpm -Uvh mysql-community-libs-compat-5.7.13-1.el6.i686.rpm warning: mysql-community-libs-compat-5.7.13-1.el6.i686.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY error: Failed dependencies: libcrypto.so.10 is needed by mysql-community-libs-compat-5.7.13-1.el6.i686 libcrypto.so.10(libcrypto.so.10) is needed by mysql-community-libs-compat-5.7.13-1.el6.i686 libssl.so.10 is needed by mysql-community-libs-compat-5.7.13-1.el6.i686 libssl.so.10(libssl.so.10) is needed by mysql-community-libs-compat-5.7.13-1.el6.i686 libz.so.1 is needed by mysql-community-libs-compat-5.7.13-1.el6.i686

위와 같은 요령으로 해결한다

[root@localhost rpm]# rpm -Uvh mysql-community-libs-compat-5.7.13-1.el6.i686.rpm warning: mysql-community-libs-compat-5.7.13-1.el6.i686.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing...                ########################################### [100%]    1:mysql-community-libs-co########################################### [100%]

[root@localhost rpm]# rpm -Uvh mysql-community-embedded-5.7.13-1.el6.i686.rpm warning: mysql-community-embedded-5.7.13-1.el6.i686.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing...                ########################################### [100%]    1:mysql-community-embedde########################################### [100%] [root@localhost rpm]# rpm -Uvh mysql-community-embedded-devel-5.7.13-1.el6.i686.rpm warning: mysql-community-embedded-devel-5.7.13-1.el6.i686.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing...                ########################################### [100%]    1:mysql-community-embedde########################################### [100%]

설치

[root@localhost rpm]# rpm -Uvh mysql-community-client-5.7.13-1.el6.i686.rpm warning: mysql-community-client-5.7.13-1.el6.i686.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing...                ########################################### [100%]    1:mysql-community-client ########################################### [100%] [root@localhost rpm]# rpm -Uvh mysql-community-server-5.7.13-1.el6.i686.rpm warning: mysql-community-server-5.7.13-1.el6.i686.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing...                ########################################### [100%]    1:mysql-community-server ########################################### [100%] [root@localhost rpm]#

설치 끝

mysql 시작

[root@localhost rpm]# service mysqld start Initializing MySQL database:                               [  OK  ] Installing validate password plugin:                     [  OK  ] Starting mysqld:                                            [  OK  ] [root@localhost rpm]# service mysqld stop Stopping mysqld:                                           [  OK  ] [root@localhost rpm]# service mysqld start Starting mysqld:                                           [  OK  ] [root@localhost rpm]#

mysql 데몬 확인

[root@localhost rpm]# ps -ef |grep mysql root      3033     1  0 17:35 pts/2    00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql mysql     3231  3033  0 17:35 pts/2    00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock root      3265  2278  0 17:36 pts/2    00:00:00 grep mysql

basedir : /usr

datadir : /var/lib/mysql

을 확인 할수 있다

접속을 해서 데이터베이스를 조회 해보겠다

[root@localhost rpm]# mysql -uroot -p Enter password:  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)  [root@localhost rpm]# mysql -uroot ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

음.... 패스워드를 모르는데

아래와같이 확인 하도록 하자

[root@localhost rpm]# cat /var/log/mysqld.log |grep temporary 2016-06-09T00:34:32.924215Z 1 [Note] A temporary password is generated for root@localhost: Bb7b8A/DqjMf 2016-06-09T00:34:36.166515Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-06-09T00:34:38.110330Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2016-06-09T00:34:38.956758Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-06-09T00:34:57.941077Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2016-06-09T00:35:07.415606Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables [root@localhost rpm]#

접속을 한다

[root@localhost rpm]# mysql -uroot -pBb7b8A/DqjMf mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 5 Server version: 5.7.13 Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. mysql>

show databases;.................... 를 했는데 alter user로 패스워드를 반드시 변경해야 사용이 가능하다

mysql> alter user 'root'@'localhost' identified by 'Root!234'; Query OK, 0 rows affected (0.00 sec)  mysql> show databases; +--------------------+ | Database           | +--------------------+ | information_schema | | mysql              | | performance_schema | | sys                | +--------------------+ 4 rows in set (0.02 sec)

설치가 끝나면 외부에서 접속을 할 수 있도록 새 유저를 생성해 주도록 하자

mysql> create user 'opendatab'@'%' identified by 'Open1!datab'; Query OK, 0 rows affected (0.00 sec) mysql> grant all privileges on *.* to 'opendatab'@'%'; Query OK, 0 rows affected (0.00 sec)

[root@localhost ~]# mysql -uopendatab -p Enter password:  Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 9 Server version: 5.7.13 MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database           | +--------------------+ | information_schema | | mysql              | | performance_schema | | sys                | +--------------------+ 4 rows in set (0.00 sec) mysql>

끝!