CentOS MySQL 클라이언트 최신 버전 설치

CentOS MySQL 클라이언트 최신 버전 설치

1 사전작업

• MySQL 커뮤니티 yum repo 추가

2 확인

[root@zetawiki ~]# rpm -qa | grep mysql
mysql-5.1.73-7.el6.x86_64
mysql-libs-5.1.73-7.el6.x86_64

→ MySQL 클라이언트 5.1.73이 설치되어 있음 (없어도 상관없음)

3 mysql 설치 (실패)

[root@zetawiki ~]# yum install mysql
... (생략)
===========================================================================================
 Package                    Arch       Version                 Repository             Size
===========================================================================================
Installing:
 mysql-community-client     x86_64     5.7.14-1.el6            mysql57-community      22 M
     replacing  mysql.x86_64 5.1.73-7.el6
 mysql-community-libs       x86_64     5.7.14-1.el6            mysql57-community     2.1 M
     replacing  mysql-libs.x86_64 5.1.73-7.el6
Installing for dependencies:
 mysql-community-common     x86_64     5.7.14-1.el6            mysql57-community     327 k
Updating for dependencies:
 postfix                    x86_64     2:2.6.6-6.el6_7.1       base                  2.0 M

Transaction Summary
===========================================================================================
Install       3 Package(s)
Upgrade       1 Package(s)

Total download size: 27 M
Is this ok [y/N]: y

Downloading Packages:
(1/4): mysql-community-client-5.7.14-1.el6.x86_64.rpm               |  22 MB     00:00     
(2/4): mysql-community-common-5.7.14-1.el6.x86_64.rpm               | 327 kB     00:00     
(3/4): mysql-community-libs-5.7.14-1.el6.x86_64.rpm                 | 2.1 MB     00:00     
(4/4): postfix-2.6.6-6.el6_7.1.x86_64.rpm                           | 2.0 MB     00:00     
-------------------------------------------------------------------------------------------
Total                                                       18 MB/s |  27 MB     00:01     
warning: rpmts_HdrFromFdno: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Importing GPG key 0x5072E1F5:
 Userid : MySQL Release Engineering <mysql-build@oss.oracle.com>
 Package: mysql57-community-release-el6-8.noarch (@/mysql57-community-release-el6-8.noarch)
 From   : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Is this ok [y/N]: y

Running rpm_check_debug
ERROR with rpm_check_debug vs depsolve:
libmysqlclient.so.16()(64bit) is needed by postfix-2:2.6.6-6.el6_7.1.x86_64
libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by postfix-2:2.6.6-6.el6_7.1.x86_64
 You could try running: rpm -Va --nofiles --nodigest
Your transaction was saved, rerun it with: yum load-transaction /tmp/yum_save_tx-2016-09-01-13-591TK2XW.yumtx

4 postfix 업그레이드

• 문제가 되는 postfix만 따로 업그레이드해보자.

[root@zetawiki ~]# yum install postfix
... (생략)
===========================================================================================
 Package            Arch              Version                        Repository       Size
===========================================================================================
Updating:
 postfix            x86_64            2:2.6.6-6.el6_7.1              base            2.0 M

Transaction Summary
===========================================================================================
Upgrade       1 Package(s)

Total size: 2.0 M
Is this ok [y/N]: y

... (생략)
Updated:
  postfix.x86_64 2:2.6.6-6.el6_7.1                                                         

Complete!

→ 잘되네;;

5 mysql 설치 (성공)

[root@zetawiki ~]# yum install mysql
... (생략)
===========================================================================================
 Package                         Arch       Version            Repository             Size
===========================================================================================
Installing:
 mysql-community-client          x86_64     5.7.14-1.el6       mysql57-community      22 M
     replacing  mysql.x86_64 5.1.73-7.el6
 mysql-community-libs            x86_64     5.7.14-1.el6       mysql57-community     2.1 M
     replacing  mysql-libs.x86_64 5.1.73-7.el6
 mysql-community-libs-compat     x86_64     5.7.14-1.el6       mysql57-community     1.6 M
     replacing  mysql-libs.x86_64 5.1.73-7.el6
Installing for dependencies:
 mysql-community-common          x86_64     5.7.14-1.el6       mysql57-community     327 k

Transaction Summary
===========================================================================================
Install       4 Package(s)

Total size: 27 M
Total download size: 1.6 M
Is this ok [y/N]: y

... (생략)
Installed:
  mysql-community-client.x86_64 0:5.7.14-1.el6                                             
  mysql-community-libs.x86_64 0:5.7.14-1.el6                                               
  mysql-community-libs-compat.x86_64 0:5.7.14-1.el6                                        

Dependency Installed:
  mysql-community-common.x86_64 0:5.7.14-1.el6                                             

Replaced:
  mysql.x86_64 0:5.1.73-7.el6               mysql-libs.x86_64 0:5.1.73-7.el6              

Complete!

6 확인

[root@zetawiki ~]# rpm -qa | grep mysql-community
mysql-community-common-5.7.14-1.el6.x86_64
mysql-community-client-5.7.14-1.el6.x86_64
mysql-community-libs-5.7.14-1.el6.x86_64
mysql-community-libs-compat-5.7.14-1.el6.x86_64

[root@zetawiki ~]# mysql -V
mysql  Ver 14.14 Distrib 5.7.14, for Linux (x86_64) using  EditLine wrapper

7 같이 보기

• CentOS MySQL 클라이언트 설치
• MySQL 커뮤니티 yum repo 추가