Upgrade Mysql 5.7 RPM Package Fail due to conflicts with mysql package Solution

MySQL 5.7 RPM packages not possible to be installed or upgraded to due to package conflicts.

You may face this issue on MySQL Server - Version 5.7 to 5.7 [Release 5.7] MySQL Cluster - Version 7.6 to 7.6 [Release 7.0] during installation or upgradation of mysql 5.7 RPM Packages on Linux.
MySQL 5.7 commercial RPM packages not possible to be installed or upgraded due to :
[root@host ~]# [root@host ~]# rpm -ivh mysql-commercial-server-5.7.9-1.1.el5.x86_64.rpm
warning: mysql-commercial-server-5.7.9-1.1.el5.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
mysql-commercial-client = 5.7.9-1.1.el5 is needed by mysql-commercial-server-5.7.9-1.1.el5.x86_64
mysql-commercial-common = 5.7.9-1.1.el5 is needed by mysql-commercial-server-5.7.9-1.1.el5.x86_64

[root@host ~]# rpm -ivh mysql-commercial-common-5.7.9-1.1.el5.x86_64.rpm
warning: mysql-commercial-common-5.7.9-1.1.el5.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
mysql = 5.7.9-1.1.el5 is needed by mysql-commercial-common-5.7.9-1.1.el5.x86_64

Issue logs:
 
[root@host ~]# rpm -Uhv mysql-commercial-server-5.7.9-1.1.el6.x86_64.rpm
warning: mysql-commercial-server-5.7.9-1.1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
mysql-commercial-client(x86-64) = 5.7.9-1.1.el6 is needed by mysql-commercial-server-5.7.9-1.1.el6.x86_64
mysql-commercial-common(x86-64) = 5.7.9-1.1.el6 is needed by mysql-commercial-server-5.7.9-1.1.el6.x86_64
[root@host ~]# rpm -Uhv mysql-commercial-client-5.7.9-1.1.el6.x86_64.rpm
warning: mysql-commercial-client-5.7.9-1.1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
mysql-commercial-libs(x86-64) = 5.7.9-1.1.el6 is needed by mysql-commercial-client-5.7.9-1.1.el6.x86_64
[root@host ~]# rpm -Uhv mysql-commercial-libs-5.7.9-1.1.el6.x86_64.rpm
warning: mysql-commercial-libs-5.7.9-1.1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
mysql-commercial-common(x86-64) = 5.7.9-1.1.el6 is needed by mysql-commercial-libs-5.7.9-1.1.el6.x86_64
[root@host ~]# rpm -Uhv mysql-commercial-common-5.7.9-1.1.el6.x86_64.rpm
warning: mysql-commercial-common-5.7.9-1.1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ########################################### [100%]
file /usr/share/mysql/bulgarian/errmsg.sys from install of mysql-commercial-common-5.7.9-1.1.el6.x86_64 conflicts with file from package MySQL-server-advanced-5.6.25-1.rhel5.x86_64
file /usr/share/mysql/czech/errmsg.sys from install of mysql-commercial-common-5.7.9-1.1.el6.x86_64 conflicts with file from package MySQL-server-advanced-5.6.25-1.rhel5.x86_64
file /usr/share/mysql/danish/errmsg.sys from install of mysql-commercial-common-5.7.9-1.1.el6.x86_64 conflicts with file from package MySQL-server-advanced-5.6.25-1.rhel5.x86_64
...
file /usr/share/mysql/charsets/macroman.xml from install of mysql-commercial-common-5.7.9-1.1.el6.x86_64 conflicts with file from package MySQL-server-advanced-5.6.25-1.rhel5.x86_64
file /usr/share/mysql/charsets/swe7.xml from install of mysql-commercial-common-5.7.9-1.1.el6.x86_64 conflicts with file from package MySQL-server-advanced-5.6.25-1.rhel5.x86_64
file /usr/share/mysql/errmsg-utf8.txt from install of mysql-commercial-common-5.7.9-1.1.el6.x86_64 conflicts with file from package MySQL-server-advanced-5.6.25-1.rhel5.x86_64

You may also get below error during up-gradation of mysql 5.6 to 5.7

root@host ~]# rpm -ivh mysql-commercial-{server,client,common,libs-compat,libs}-*
warning: mysql-commercial-server-5.7.9-1.1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
libnuma.so.1()(64bit) is needed by mysql-commercial-server-5.7.9-1.1.el6.x86_64
libnuma.so.1(libnuma_1.1)(64bit) is needed by mysql-commercial-server-5.7.9-1.1.el6.x86_64
libnuma.so.1(libnuma_1.2)(64bit) is needed by mysql-commercial-server-5.7.9-1.1.el6.x86_64
libcrypto.so.10 is needed by mysql-commercial-libs-compat-5.7.9-1.1.el6.i686
libssl.so.10 is needed by mysql-commercial-libs-compat-5.7.9-1.1.el6.i686
libz.so.1 is needed by mysql-commercial-libs-compat-5.7.9-1.1.el6.i686
libcrypto.so.10(libcrypto.so.10)(64bit) is needed by mysql-commercial-libs-compat-5.7.9-1.1.el6.x86_64
libssl.so.10(libssl.so.10)(64bit) is needed by mysql-commercial-libs-compat-5.7.9-1.1.el6.x86_64

Solution.

Mysql RPM Package Conflict

STEP-1: Exctract the RPM package using tar -xvf command.
[root@ctpdb1 MY57]# tar -xvf mysql-5.7.31-1.el6.x86_64.rpm-bundle.tar
mysql-community-test-5.7.31-1.el6.x86_64.rpm
mysql-community-devel-5.7.31-1.el6.x86_64.rpm
mysql-community-libs-compat-5.7.31-1.el6.x86_64.rpm
mysql-community-embedded-5.7.31-1.el6.x86_64.rpm
mysql-community-common-5.7.31-1.el6.x86_64.rpm
mysql-community-server-5.7.31-1.el6.x86_64.rpm
mysql-community-embedded-devel-5.7.31-1.el6.x86_64.rpm
mysql-community-libs-5.7.31-1.el6.x86_64.rpm
mysql-community-client-5.7.31-1.el6.x86_64.rpm

STEP-2: Now try to install each package sepratly , you will get package conflict error as we already discussed at starting.
[root@ctpdb1 MY57]# rpm -Uvh mysql-community-libs-compat-5.7.31-1.el6.x86_64.rpm
warning: mysql-community-libs-compat-5.7.31-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
        mysql-community-libs(x86-64) >= 5.7.9 is needed by mysql-community-libs-compat-5.7.31-1.el6.x86_64
        mysql-libs is needed by (installed) postfix-2:2.6.6-8.el6.x86_64

STEP-3: To Solve issue use below command.
[root@ctpdb1 MY57]# yum install mysql-community-{server,client,common,libs-compat,libs}-* mysql-5.*.
or if you are going to install commercial package then Use.
[root@ctpdb1 MY57]# yum install mysql-commercial-{server,client,common,libs-compat,libs}-* mysql-5.*

Example of yum and rpm commands for installation and up-gradation.
For RHEL 5 / OL 5 / CentOS 5 systems
shell$ yum install mysql-commercial-{server,client,common,libs-compat,libs}-* mysql-5.*
For other systems than the above
shell$ yum install mysql-commercial-{server,client,common,libs-compat,libs}-*

Use RPM command
Install
shell$ rpm -ivh mysql-commercial-{server,client,common,libs-compat,libs}-*
Upgrade
shell$ rpm -Uvh mysql-commercial-{server,client,common,libs-compat,libs}-*

Loaded plugins: refresh-packagekit, security, ulninfo
Replaced:
  MySQL-client.x86_64 0:5.6.48-1.el6   MySQL-server.x86_64 0:5.6.48-1.el6   MySQL-shared.x86_64 0:5.6.48-1.el6   MySQL-shared-compat.x86_64 0:5.6.48-1.el6
Complete!

STEP-4 Start MySQL database.
[root@ctpdb1 MY57]# service mysql start
mysql: unrecognized service
[root@ctpdb1 MY57]# service mysqld start
Starting mysqld:                                           [  OK  ]

Do not forget to share your comments.
SHARE

pavan

  • Image
  • Image
  • Image
  • Image
  • Image
    Blogger Comment
    Facebook Comment

0 Comments:

Post a Comment

Subscribe Us