yum install mysql on new Centos box

NotionCommotion · 03-24-2014, 07:00 AM

I am trying to install mysql55 from the ius repo, but get the following error:

Code:

yum -y install mysql55 mysql55-server mysql55-devel

Error: mysql55-libs conflicts with mysql-libs-5.1.73-3.el6_5.x86_64

My server is a new install Centos 6.5. After investigating, I have found that I have one and only one mysql package installed.

Code:

[root@localhost ~]# yum list installed | grep mysql
mysql-libs.x86_64       5.1.71-1.el6    @anaconda-CentOS-201311272149.x86_64/6.5
[root@localhost ~]#

Why is this package installed? Should I just remove it using "yum remove mysql-libs.x86_64"?

Thanks

knanda · 03-24-2014, 10:01 AM

Mysql Install:

1. Download the latest ius-release rpm from
http://dl.iuscommunity.org/pub/ius/s...dhat/5/x86_64/

2. Install ius-release rpm:
# rpm -Uvh ius-release*rpm

3. Install mysql55-devel rpm package:
# yum install mysql55-devel

for further information refer:
http://pkgs.org/centos-5/ius-x86_64/...86_64.rpm.html

Package Deletion:
#yum erase <package name>

NotionCommotion · 03-24-2014, 10:41 AM

Thanks knanda,

But what about mysql-libs-5.1.73-3.el6_5.x86_64?

Does this need to be removed first?

Why is this MySQL package, and only this MySQL package installed by default?

knanda · 03-24-2014, 11:31 AM

Before installing its a good practice to check the installed packages version. I believe in this scenario the available package with yum repo is mysql5.1. So its recommended to update the repo for latest version using update command.

#yum update

Be cautious with update command. It upgrades linux kernel as well. Be sure with the command before running and if not sure don't run in production.

Quest-2,

Remove the mysql-libs-5.1.73-3.el6_5.x86_64 and do fresh installation.

#yum erase mysql-libs

John VV · 03-24-2014, 11:39 AM

i would advise NOT using a rhel5 repo on centos 6

5 and 6 do not mix

you will likely be left with a FUBAR'ed install of centos 6.5

if you must then USE the rhel6 repo
http://dl.iuscommunity.org/pub/ius/s...dhat/6/x86_64/

as to conflicts

install and CONFIGURE!!!!!!!!!
the "yum-priorites" plugin
see the wiki:"Available Repositories for CentOS"
http://wiki.centos.org/AdditionalResources/Repositories

and the plugin
http://wiki.centos.org/PackageManagement/Yum/Priorities

knanda · 03-24-2014, 11:59 AM

Steps to enable IUS repository for CENTOS6:
Download the rpm:
#wget http://dl.iuscommunity.org/pub/ius/s...el6.noarch.rpm

Install the rpm:
#rpm -Uvh ius-release-1.0-11.ius.el6.noarch.rpm

Install Mysql:
#yum install mysql-server

smallpond · 03-24-2014, 12:03 PM

As to why it is installed:

Code:

rpm -q --whatrequires mysql-libs
postfix-2.6.6-2.2.el6_1.x86_64

NotionCommotion · 03-24-2014, 12:31 PM

Quote:

Originally Posted by John VV

i would advise NOT using a rhel5 repo on centos 6

5 and 6 do not mix

you will likely be left with a FUBAR'ed install of centos 6.5

if you must then USE the rhel6 repo
http://dl.iuscommunity.org/pub/ius/s...dhat/6/x86_64/

as to conflicts

install and CONFIGURE!!!!!!!!!
the "yum-priorites" plugin
see the wiki:"Available Repositories for CentOS"
http://wiki.centos.org/AdditionalResources/Repositories

and the plugin
http://wiki.centos.org/PackageManagement/Yum/Priorities

I don't think I am using rhel5's repo. Agree?

Also, yes I am using priorities.

Thanks

Code:

[root@localhost html]# yum list installed | grep mysql
mysql55.x86_64          5.5.36-1.ius.centos6
mysql55-devel.x86_64    5.5.36-1.ius.centos6
mysql55-libs.x86_64     5.5.36-1.ius.centos6
mysql55-server.x86_64   5.5.36-1.ius.centos6
mysqlclient16.x86_64    5.1.61-4.ius.centos6
php55u-mysqlnd.x86_64   5.5.10-1.ius.centos6
[root@localhost html]# yum list mysql55.x86_64
Loaded plugins: fastestmirror, priorities, security
Loading mirror speeds from cached hostfile
 * PUIAS_6_computational: puias.math.ias.edu
 * Webmin: download.webmin.com
 * base: mirror.beyondhosting.net
 * epel: mirror.pnl.gov
 * extras: mirror.pac-12.org
 * ius: mirror.sothatswhy.org.uk
 * updates: centos-distro.cavecreek.net
593 packages excluded due to repository priority protections
Installed Packages
mysql55.x86_64                     5.5.36-1.ius.centos6                     @ius
[root@localhost html]# rpm -qi mysql55.x86_64
Name        : mysql55                      Relocations: (not relocatable)
Version     : 5.5.36                            Vendor: (none)
Release     : 1.ius.centos6                 Build Date: Fri 31 Jan 2014 12:52:43 PM PST
Install Date: Sun 23 Mar 2014 09:05:01 PM PDT      Build Host: 339180-build01.rpmdev.rackspace.com
Group       : Applications/Databases        Source RPM: mysql55-5.5.36-1.ius.centos6.src.rpm
Size        : 42358999                         License: GPLv2 with exceptions
Signature   : DSA/SHA1, Tue 18 Feb 2014 09:24:55 PM PST, Key ID da221cdf9cd4953f
URL         : http://www.mysql.com
Summary     : MySQL client programs and shared libraries
Description :
MySQL is a multi-user, multi-threaded SQL database server. MySQL is a
client/server implementation consisting of a server daemon (mysqld)
and many different client programs and libraries. The base package
contains the standard MySQL client programs and generic MySQL files.
[root@localhost html]#

szboardstretcher · 03-24-2014, 01:07 PM

I would suggest removing all mysql related packages. Then use Percona mysql: http://www.percona.com/

which is free, enterprise,.. great backup features and monitoring. And the multi-master replication works.

This is the way we do it over here. Up to you.