• soup
  • New member
  • Offline
  • Registered: 2011-05-04
  • Posts: 8

Topic: mysql install

Theoretically mysql is not installed yet, although phpMyAdmin is.
yum --enablerepo=remi install mysql = Package(s) mysql available, but not installed.

Ok fine so

yum --enablerepo=remi install mysql
I then get this message

Package mysql is obsoleted by MySQL-server-community, trying to install MySQL-server-community-5.1.52-1.rhel5.x86_64 instead

Ok don't care just want an uptodate running MySQL, so click y
Then the following errors turn up

Transaction Check Error:
  file /etc/my.cnf from install of MySQL-server-community-5.1.52-1.rhel5.x86_64 conflicts with file from package mysql-libs-5.5.11-1.el5.remi.x86_64
  file /usr/share/mysql/charsets/cp1251.xml from install of MySQL-server-community-5.1.52-1.rhel5.x86_64 conflicts with file from package mysql-libs-5.5.11-1.el5.remi.x86_64
  file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-community-5.1.52-1.rhel5.x86_64 conflicts with file from package mysql-libs-5.5.11-1.el5.remi.x86_64
  file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-community-5.1.52-1.rhel5.x86_64 conflicts with file from package mysql-libs-5.5.11-1.el5.remi.x86_64
  file /usr/share/mysql/dutch/errmsg.sys from install of MySQL-server-community-5.1.52-1.rhel5.x86_64 conflicts with file from package mysql-libs-5.5.11-1.el5.remi.x86_64


plus some more for other languages

New to centOS......so someone please help !

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,836

Re: mysql install

remove MySQL-server-community before update.

+

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

3 Reply by soup (edited by soup 2011-05-04 12:57:31)

  • soup
  • New member
  • Offline
  • Registered: 2011-05-04
  • Posts: 8

Re: mysql install

what update ?
i have now removed the MySQL-server-community

yum --enablerepo=remi update php - No Packages marked for Update
yum --enablerepo=remi update mysql - Package(s) mysql available, but not installed.


so how do i now install mysql ?
if i do  yum --enablerepo=remi install mysql-server
if get
Package mysql-server is obsoleted by MySQL-server-community, trying to install MySQL-server-community-5.1.52-1.rhel5.x86_64 instead

which if i say yes to gives the following errors

Transaction Check Error:
  file /etc/my.cnf from install of MySQL-server-community-5.1.52-1.rhel5.x86_64 conflicts with file from package mysql-libs-5.5.11-1.el5.remi.x86_64
  file /usr/share/mysql/charsets/cp1251.xml from install of MySQL-server-community-5.1.52-1.rhel5.x86_64 conflicts with file from package mysql-libs-5.5.11-1.el5.remi.x86_64
  file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-community-5.1.52-1.rhel5.x86_64 conflicts with file from package mysql-libs-5.5.11-1.el5.remi.x86_64

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,836

Re: mysql install

I can't help, I need the full yum command output.

And the "yum repolist" result

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

5 Reply by soup (edited by soup 2011-05-04 13:06:56)

  • soup
  • New member
  • Offline
  • Registered: 2011-05-04
  • Posts: 8

Re: mysql install

Think i've sorted it with the following

yum remove phpMyAdmin - let it remove whatever it wants
yum remove mysql-libs-5.5.11-1.el5.remi.x86_64

yum --enablerepo=remi install mysql mysql-server php-mysql
and then reinstall phpMyAdmin
yum --enablerepo=remi install phpMyAdmin


hope this helps someone - because it drove me nuts !

6 Reply by soup (edited by soup 2011-05-04 13:21:56)

  • soup
  • New member
  • Offline
  • Registered: 2011-05-04
  • Posts: 8

Re: mysql install

and of course the next problem turns up on phpMyAdmin (which is at least working)

Your PHP MySQL library version 5.5.11 differs from your MySQL server version 5.1.52. This may cause unpredictable behavior.

yum --enablerepo=remi update  mysql mysql-server php-mysql mysql-client
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.de.leaseweb.net
* epel: vesta.informatik.rwth-aachen.de
* extras: mirror.de.leaseweb.net
* remi: remirpm.mirror.gymkl.ch
* updates: mirror.de.leaseweb.net
Setting up Update Process
Package(s) mysql available, but not installed.
Package(s) mysql-server available, but not installed.
No Packages marked for Update


yum --enablerepo=remi install  mysql mysql-server php-mysql mysql-client
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.plusline.de
* epel: vesta.informatik.rwth-aachen.de
* extras: ftp.plusline.de
* remi: remirpm.mirror.gymkl.ch
* updates: ftp.plusline.de
Setting up Install Process
Package mysql is obsoleted by MySQL-server-community, trying to install MySQL-server-community-5.1.52-1.rhel5.x86_64 instead
Package MySQL-server-community-5.1.52-1.rhel5.x86_64 already installed and latest version
Package mysql is obsoleted by MySQL-server-community, trying to install MySQL-server-community-5.1.52-1.rhel5.x86_64 instead
Package MySQL-server-community-5.1.52-1.rhel5.x86_64 already installed and latest version
Package mysql-server is obsoleted by MySQL-server-community, trying to install MySQL-server-community-5.1.52-1.rhel5.x86_64 instead
Package MySQL-server-community-5.1.52-1.rhel5.x86_64 already installed and latest version
Package php-mysql-5.3.6-3.el5.remi.x86_64 already installed and latest version
Package MySQL-client-community-5.1.52-1.rhel5.x86_64 already installed and latest version
Nothing to do

Impressive - update says they are not installed, install says they are the latest versions !

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,836

Re: mysql install

what is the result of 

rpm -qa | grep -i mysql | sort
Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

  • soup
  • New member
  • Offline
  • Registered: 2011-05-04
  • Posts: 8

Re: mysql install

MySQL-client-community-5.1.52-1.rhel5
mysql-libs-5.5.11-1.el5.remi
MySQL-server-community-5.1.52-1.rhel5
MySQL-shared-compat-5.1.52-1.rhel5
php-mysql-5.3.6-3.el5.remi

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,836

Re: mysql install

so remove the Oracle RPM (MySQL-*) and install the ones from my repo

yum remove MySQL-client-community MySQL-server-community MySQL-shared-compat
yum --enablerepo=remi install mysql mysql-server
Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

10 Reply by soup (edited by soup 2011-05-04 15:54:18)

  • soup
  • New member
  • Offline
  • Registered: 2011-05-04
  • Posts: 8

Re: mysql install

when i do that, i get exactly the same as before
yum --enablerepo=remi install mysql mysql-server mysql-client


Package mysql is obsoleted by MySQL-server-community, trying to install MySQL-server-community-5.1.52-1.rhel5.x86_64 instead
Package mysql is obsoleted by MySQL-server-community, trying to install MySQL-server-community-5.1.52-1.rhel5.x86_64 instead
Package mysql-server is obsoleted by MySQL-server-community, trying to install MySQL-server-community-5.1.52-1.rhel5.x86_64 instead
Resolving Dependencies
--> Running transaction check
---> Package MySQL-server-community.x86_64 0:5.1.52-1.rhel5 set to be updated
--> Finished Dependency Resolution
=
Installing:
MySQL-server-community              x86_64              5.1.52-1.rhel5               centos5-x86_64-custom               20 M

and then i get the same problems as before

Transaction Check Error:
  file /etc/my.cnf from install of MySQL-server-community-5.1.52-1.rhel5.x86_64 conflicts with file from package mysql-libs-5.5.11-1.el5.remi.x86_64
  file /usr/share/mysql/charsets/cp1251.xml from install of MySQL-server-community-5.1.52-1.rhel5.x86_64 conflicts with file from package mysql-libs-5.5.11-1.el5.remi.x86_64
  file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-community-5.1.52-1.rhel5.x86_64 conflicts with file from package mysql-libs-5.5.11-1.el5.remi.x86_64
  file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-community-5.1.52-1.rhel5.x86_64 conflicts with file from package mysql-libs-5.5.11-1.el5.remi.x86_64
  file /usr/share/mysql/dutch/errmsg.sys from install of MySQL-server-community-5.1.52-1.rhel5.x86_64 conflicts with file from package mysql-libs-5.5.11-1.el5.remi.x86_64

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,836

Re: mysql install

I don't understand from which repository MySQL* package comes from...

yum --exclude MySQL\* --enablerepo=remi install mysql mysql-server

Or 

yum --disablerepo=centos5-x86_64-custom --enablerepo=remi install mysql mysql-server
Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

  • soup
  • New member
  • Offline
  • Registered: 2011-05-04
  • Posts: 8

Re: mysql install

and if remove
yum remove mysql-libs-5.5.11-1.el5.remi.x86_64

and then install
yum --enablerepo=remi install mysql mysql-server php-mysql
this is installed


Installing:
MySQL-server-community             x86_64             5.1.52-1.rhel5                  centos5-x86_64-custom              20 M
php-mysql                          x86_64             5.3.6-3.el5.remi                remi                                     159 k
Installing for dependencies:
mysql-libs                         x86_64             5.5.11-1.el5.remi               remi                                     1.1 M

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,836

Re: mysql install

You are using 2 repository which provides mysql stuff.
You must chose one and disable the other.

remi repo is designed to work with official RHEL/CentOS repo and EPEL only.

I can't manage conflicts with all the other third party repositories which exist.

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website