Installing MySQl 5.5 on CentOS 6 dependencies conflict

Question

I installed mysql on my centos 6 yesterday but I wasb't aware that it's installing mysql 5.1 which is an outdated version. Now I've remove old version and all it's dependencies, but when I try to install MySQL 5.5 yum says there are problems because of mysql-libs conflicting with new one.

[root@Pooya /]# yum --enablerepo=remi install mysql mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.kiewel-online.ch
 * epel: kartolo.sby.datautama.net.id
 * extras: ftp.linux.org.tr
 * ius: download.srv.ro
 * remi: remi-mirror.dedipower.com
 * rpmforge: mirror.nl.leaseweb.net
 * updates: ftp.plusline.de
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.5.28-1.el6.remi will be installed
--> Processing Dependency: mysql-libs(x86-64) = 5.5.28-1.el6.remi for package: mysql-5.5.28-1.el6.remi.x86_64
---> Package mysql-server.x86_64 0:5.5.28-1.el6.remi will be installed
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server-5.5.28-1.el6.remi.x86_64
--> Running transaction check
---> Package mysql-libs.x86_64 0:5.5.28-1.el6.remi will be installed
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Running transaction check
---> Package mysql51-libs.x86_64 0:5.1.66-1.ius.el5 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=================================================================================================================================================================================
 Package                                       Arch                                  Version                                           Repository                           Size
=================================================================================================================================================================================
Installing:
 mysql                                         x86_64                                5.5.28-1.el6.remi                                 remi                                5.7 M
 mysql-server                                  x86_64                                5.5.28-1.el6.remi                                 remi                                 10 M
Installing for dependencies:
 mysql-libs                                    x86_64                                5.5.28-1.el6.remi                                 remi                                771 k
 mysql51-libs                                  x86_64                                5.1.66-1.ius.el5                                  ius                                 1.7 M
 perl-DBD-MySQL                                x86_64                                4.013-3.el6                                       base                                134 k

Transaction Summary
=================================================================================================================================================================================

As you can see it's downloading both mysql libs for mysql 5.5 and 5.1! How can I fix that?

Answer 1

You also have the IUS community repo installed and enabled. Disable this repo, as it conflicts with remi (and many other repositories).

Answer 2

I don't think this is a problem that needs to be fixed. You have different libraries that depend on different versions of the libmysqlclient.so, the DB server can talk to clients of different versions safely. In this case MySQL comes with some utilities written in perl and the perl MySQL library is built against the 5.1 version of the client library, shouldn't affect the utilities in any way.

Answer 3

The problem was because of repositories conflict, which some of them are storing newer version of mySQL and some of them are just holding their old, sure-to-be-stable versions.

I disabled those repositories and kept only the ones which are holding latest stable version of MySQL and problem fixed.

Thanks for your help!

Answer 4

If you want to install MySql 5.5 on a CentOS 6 and over-right conflicts in mysql-libs you have to:

yum install yum-plugin-replace
wget https://mirror.webtatic.com/yum/el6/latest.rpm
rpm -Uvh https://mirror.webtatic.com/yum/el6/latest.rpm
yum install mysql.`uname -i` yum-plugin-replace
yum replace mysql --replace-with mysql55w
yum replace mysql-libs --replace-with mysql55w-libs
yum install mysql55w-server mysql55w
service mysqld start
mysql_secure_installation

Enter your password and done!