Update MySQL version from 5.1 to 5.5 in CentOS 6.2

Question

I tried to update MySQL from 5.1 to 5.5 in CentOS 6.2. The following is the process I did:

1. rpm -Uvh http://repo.webtatic.com/yum/centos/5/latest.rpm 2. yum install libmysqlclient15 --enablerepo=webtatic 3. yum remove mysql mysql-* 4. yum install mysql55 mysql55-server --enablerepo=webtatic 

When I tried the 4th step, I got the following output:

[root@d2005 /]# yum install mysql55 mysql55-server --enablerepo=webtatic Failed to set locale, defaulting to C Loaded plugins: fastestmirror, presto Loading mirror speeds from cached hostfile  * base: yum.singlehop.com  * extras: centos.mirrors.tds.net  * updates: pubmirrors.reflected.net Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package mysql55.x86_64 0:5.5.10-1.w5 will be installed --> Processing Dependency: mysql55-libs = 5.5.10-1.w5 for package: mysql55-5.5.10-1.w5.x86_64 ---> Package mysql55-server.x86_64 0:5.5.10-1.w5 will be installed --> Processing Dependency: perl-DBD-MySQL for package: mysql55-server-5.5.10-1.w5.x86_64 --> Running transaction check ---> Package mysql55-libs.x86_64 0:5.5.10-1.w5 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 mysql-libs.x86_64 0:5.1.61-1.el6_2.1 will be installed --> Processing Conflict: mysql55-libs-5.5.10-1.w5.x86_64 conflicts mysql-libs < 5.5.10 --> Finished Dependency Resolution Error: mysql55-libs conflicts with mysql-libs  You could try using --skip-broken to work around the problem  You could try running: rpm -Va --nofiles --nodigest 

How to fix it?

Answer 1

To list Old MySql

yum list installed | grep -i mysql 

To remove Old MySql

yum remove mysql mysql-* 

Remi Dependency on CentOS 6 and Red Hat (RHEL) 6

rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm  rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm 

Install MySQL server

yum --enablerepo=remi,remi-test install mysql mysql-server 

To list New MySql

yum list installed | grep -i mysql 

start MySql server

/etc/init.d/mysqld start ## use restart after update

OR

service mysqld start ## use restart after update

chkconfig --levels 235 mysqld on 

Last

mysql_upgrade -u root -p 

Now my MySql version is 5.5.32

Ref:

http://www.webtatic.com/packages/mysql55/

http://www.if-not-true-then-false.com/2010/install-mysql-on-fedora-centos-red-hat-rhel/

Hope it help some one

NOTE: Adding comments from @pim (in comments)

Just wanted to add that after the upgrade, my crontab was removed as well. Had to reinstall with "yum install vixie-cron" (CentOS 6)  

Answer 2

I used the following commands to add a new YUM repo and make the update:

Download the Remi repo

cd /etc/yum.repos.d wget http://rpms.famillecollet.com/enterprise/remi.repo 

Install/Update the mysql version

yum --enablerepo=remi install mysql-server 

OR

yum --enablerepo=remi update mysql-server