Resolved Upgrade MySQL 5.5 to 5.6/5.7 on Linux

[NicolasP.]

Hello.

Server Details:
OS: ‪CentOS Linux 7.3.1611 (Core)‬
Product: Plesk Onyx Version 17.5.3 Update #19
Mariadb: 5.5.52-MariaDB

I am trying to upgrade mysql using this link
How to upgrade MySQL 5.5 to 5.6/5.7 on Linux
but I am getting this error when I run "yum install mariadb"

Error: Package: 1:mariadb-bench-5.5.52-1.el7.x86_64 (installed)
Requires: mariadb(x86-64) = 1:5.5.52-1.el7
Removing: 1:mariadb-5.5.52-1.el7.x86_64 (installed)
mariadb(x86-64) = 1:5.5.52-1.el7
Obsoleted By: MariaDB-client-10.1.26-1.el7.centos.x86_64 (mariadb10.1)
mariadb(x86-64) = 1:10.1.26-1.el7.centos
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest​

How can I fix it and update mysql?

 

[NicolasP.]

Is there anyone that he can help me?

 

[UFHH01]

Hi NicolasP.,

you manually installed an additional MariaDB - benchmark - tool ( for what ever reason ) and exprience now, that you can't update/upgrade to another MySQL / MariaDB - version, if you don't remove this tool in the first place, because this package comes with several dependencies to other current packages.

yum remove mariadb-bench

Afterwards, pls. go back to your initial found KB - article and follow the suggested steps to upgrade your MySQL / MariaDB - version.

Pls. don't forget to use as well the command:

mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`

... to finalize your update/upgrade process.

 

[NicolasP.]

Hi NicolasP.,

you manually installed an additional MariaDB - benchmark - tool ( for what ever reason ) and exprience now, that you can't update/upgrade to another MySQL / MariaDB - version, if you don't remove this tool in the first place, because this package comes with several dependencies to other current packages.

yum remove mariadb-bench

Afterwards, pls. go back to your initial found KB - article and follow the suggested steps to upgrade your MySQL / MariaDB - version.

Pls. don't forget to use as well the command:

mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`

... to finalize your update/upgrade process.

Thank you.

It worked.

My VPS is from HostEurope and mariadb-bench is installed by default.

So do i need to run this command to start mysql "service mysql start" or this "service mariadb start"?

Or is the same?

Thank you