• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Resolved Upgrade MySQL 5.5 to 5.6/5.7 on Linux

NicolasP.

Regular Pleskian
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?
 
Last edited:
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.

Code:
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:
Code:
mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`
... to finalize your update/upgrade process. ;)
 
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.

Code:
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:
Code:
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
 
Back
Top