trying to install mysqlserver

[110V8]

Hi,

When trying to install mysql server I type yum update, then the following error(s) occur, did I forget something, or do I have to install mariadb first?

yum update
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* base: mirror.nl.webzilla.com
* extras: mirror.nl.webzilla.com
* updates: mirror.nl.webzilla.com
Resolving Dependencies
--> Running transaction check
---> Package mariadb.x86_64 1:5.5.50-1.el7_2 will be obsoleted
---> Package mariadb-libs.x86_64 1:5.5.50-1.el7_2 will be obsoleted
---> Package mariadb-server.x86_64 1:5.5.50-1.el7_2 will be obsoleted
--> Processing Dependency: mariadb-server for package: akonadi-mysql-1.9.2-4.el7.x86_64
---> Package mysql-community-client.x86_64 0:5.6.33-2.el7 will be obsoleting
---> Package mysql-community-libs.x86_64 0:5.6.33-2.el7 will be obsoleting
--> Processing Dependency: mysql-community-common(x86-64) >= 5.6.10 for package: mysql-community-libs-5.6.33-2.el7.x86_64
---> Package mysql-community-server.x86_64 0:5.6.33-2.el7 will be obsoleting
--> Running transaction check
---> Package mariadb-server.x86_64 1:5.5.50-1.el7_2 will be obsoleted
--> Processing Dependency: mariadb-server for package: akonadi-mysql-1.9.2-4.el7.x86_64
---> Package mysql-community-common.x86_64 0:5.6.33-2.el7 will be installed
--> Finished Dependency Resolution
Error: Package: akonadi-mysql-1.9.2-4.el7.x86_64 (@anaconda)
Requires: mariadb-server
Removing: 1:mariadb-server-5.5.50-1.el7_2.x86_64 (@updates)
mariadb-server = 1:5.5.50-1.el7_2
Obsoleted By: mysql-community-server-5.6.33-2.el7.x86_64 (mysql56-community)
Not found
Available: 1:mariadb-server-5.5.44-2.el7.centos.x86_64 (base)
mariadb-server = 1:5.5.44-2.el7.centos
Available: 1:mariadb-server-5.5.47-1.el7_2.x86_64 (updates)
mariadb-server = 1:5.5.47-1.el7_2
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
[root@localhost Downloads]# yum install mysql-server
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* base: mirror.nl.webzilla.com
* extras: mirror.nl.webzilla.com
* updates: mirror.nl.webzilla.com
Resolving Dependencies
--> Running transaction check
---> Package mariadb-server.x86_64 1:5.5.50-1.el7_2 will be obsoleted
--> Processing Dependency: mariadb-server for package: akonadi-mysql-1.9.2-4.el7.x86_64
---> Package mysql-community-server.x86_64 0:5.6.33-2.el7 will be obsoleting
--> Processing Dependency: mysql-community-common(x86-64) = 5.6.33-2.el7 for package: mysql-community-server-5.6.33-2.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 5.6.10 for package: mysql-community-server-5.6.33-2.el7.x86_64
--> Running transaction check
---> Package mariadb.x86_64 1:5.5.50-1.el7_2 will be obsoleted
---> Package mariadb-server.x86_64 1:5.5.50-1.el7_2 will be obsoleted
--> Processing Dependency: mariadb-server for package: akonadi-mysql-1.9.2-4.el7.x86_64
---> Package mysql-community-client.x86_64 0:5.6.33-2.el7 will be obsoleting
--> Processing Dependency: mysql-community-libs(x86-64) >= 5.6.10 for package: mysql-community-client-5.6.33-2.el7.x86_64
---> Package mysql-community-common.x86_64 0:5.6.33-2.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.50-1.el7_2 will be obsoleted
---> Package mariadb-server.x86_64 1:5.5.50-1.el7_2 will be obsoleted
--> Processing Dependency: mariadb-server for package: akonadi-mysql-1.9.2-4.el7.x86_64
---> Package mysql-community-libs.x86_64 0:5.6.33-2.el7 will be obsoleting
--> Finished Dependency Resolution
Error: Package: akonadi-mysql-1.9.2-4.el7.x86_64 (@anaconda)
Requires: mariadb-server
Removing: 1:mariadb-server-5.5.50-1.el7_2.x86_64 (@updates)
mariadb-server = 1:5.5.50-1.el7_2
Obsoleted By: mysql-community-server-5.6.33-2.el7.x86_64 (mysql56-community)
Not found
Available: 1:mariadb-server-5.5.44-2.el7.centos.x86_64 (base)
mariadb-server = 1:5.5.44-2.el7.centos
Available: 1:mariadb-server-5.5.47-1.el7_2.x86_64 (updates)
mariadb-server = 1:5.5.47-1.el7_2
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest

[TrevorH]

You've added the mysql "community" yum repo and this conflicts with the mariadb packages that CentOS supplies.

In common with almost all other distros, CentOS does not ship mysql any more. Instead we ship the fork of mysql that was made by the original mysql authors after the sale of mysql to Sun and then to Oracle. We do not support mysql so if you insist on using their packages you will need to ask for support from the people that maintain the mysql-community packages.

Why do you think you need mysql anyway? Mariadb is mysql in all but name...

[110V8]

Tried to install Sysaid for education purposes, Sysaid doesn't support mariadb

https://www.sysaid.com/support/system-requirements

according to this site it should be possible:

https://www.linode.com/docs/databases/m ... n-centos-7

But... as said, just trying for education, trying to make IT-students more enthousiast about Linux instead of always using Microsoft products.

[TrevorH]

Just ignore that, use mariadb - it won't be able to tell the difference. It has the same API, the same SQL and to all intents and purposes it is mysql.

[110V8]

I'll try. Thanks

[wilburunion]

For others that come along . . .

What causes that result above are the differences in the libs and the attempts of "yum" at error handling trying to find what might match

This is sadly . . . just a very poor documentation and naming of libs

While "5.5" looks like a php version - or a server version of a really old version of mariadb - it is just poor naming of what are libs

Notice that yum tried to show that Mariadb 5.5 was available - and that is a RATHER old version not like MySQL server 5.6 - Mariadb did some jump numbering => see https://mariadb.com/kb/en/library/maria ... atibility/

Actually EARLY Mariadb 5.5 is EARLY Mariadb 10 - but is actually closer to MySQL 5.6 in features - for instance Drupal 7 will report as thus => OK
Database system version 5.5.5-10.2.11-MariaDB - for Mariadb 10.2.11

For instance this also normally occurs when trying to upgrade the Mariadb server to at this writing version 10.2 FROM 10.1 or MySQL server. You really WANT to upgrade to 10.2.[current] version of MariaDB if possible. See for some reasons why see also https://dba.stackexchange.com/questions ... hour-or-so

Currently to even upgrade a 10.2 server and / or to the next minor version say from 10.2.9 to 10.2.11 => one has to go to http://yum.mariadb.org/10.2/centos7-amd ... common.rpm and do an "rpm -Uvh [filename link] --force" to install that one conflicting file because of a "my.cnf" file conflict even once one gets the Mariadb 10.2 server installed

Then one can yum upgrade the rest once the conflict is forced through and away
Mariadb-libs are obsoleted by Percona-Server-shared-56-5.6.37-rel82.2.el7.x86_64 which provides
/etc/my.cnf
/usr/lib64/libmysqlclient.so.18.1.0
/usr/lib64/libmysqlclient_r.so.18.1.0

See also https://bugs.launchpad.net/percona-server/+bug/1558435

The issue is the current mariadb-libs-5.5.56-2.el7 RPM for x86_64 - for CentOS 7.4.1708 for x86_64 / Packages which provides:
mariadb-libs
config(mariadb-libs)
libmysqlclient.so.18()(64bit)
libmysqlclient.so.18(libmysqlclient_16)(64bit)
libmysqlclient.so.18(libmysqlclient_18)(64bit)
mariadb-libs(x86-64)
mysql-libs
mysql-libs(x86-64)

comes up stating it is OBSELETED by Percona-server shared 56 - which in reality ARE only the new libs - a.k.a. = the needed "mariadb-libs" - if one READS this Chinese site link below the issue is shown that happens when trying to upgrade to 10.2 and results in a forced result to the Percona-server 56 which are really just two lib files => SEE AGAIN https://translate.google.com/translate? ... rev=search

the final result is one must use Percona-server-shared 56 - which are just the lib files - not actually Percona server - the server

NOTE the difference is of libmysqlclient.so.18.1.0 versus libmysqlclient.so.18 - revision lib version 18.1.0 versus the early version 18 - or also called 18.0

The files are just really poorly named because 5.5 and 5.6 or 56 means too many things right now with php 5.6 also prevalent in relation to MySQL

NOTE Percona-server 55 provides

/etc/my.cnf
/usr/lib64/libmysqlclient.so
/usr/lib64/libmysqlclient.so.18.0.0
/usr/lib64/libmysqlclient_r.so
/usr/lib64/libmysqlclient_r.so.18.0.0

which is similar to mariadb-libs-5.5 version 18 - NOT version 18.1 - so it will throw the same error

TrevorH is largely right - except you WILL have a FASTER better running MySQL server if you upgrade from 10.1 Mariadb to 10.2 - and do not try to "downgrade" to install MySQL 5.6 or 5.7 server - actually if you install Mariadb 10.2 and up - you will have a faster server and a smaller SQL server memory launch and running footprint because in part it has Dynamic Innodb Buffer pooling available if you set it up it will do more with less memory than 10.1 mariadb