Articles in this section

See more

How to upgrade MySQL from 5.1 to 5.5 on Plesk for Linux?

Avatar
Renan Moreira
Updated
Follow
Plesk for Linux kb: how-to ABT: Group A

Applicable to:

  • Plesk for Linux

Question

How to upgrade MySQL from the version 5.1 to 5.5 on Linux?

Answer

Plesk Installer gets packages from base repositories of an operating system installed.

If MySQL 5.5 is not listed in the base repository, it is not available in Plesk Installer.

In that case, in order to upgrade MySQL version to 5.5, it is needed to configure a third-party repository.

Note: Upgrade can be performed in a command-line interface with the instructions below at your own risk. This task is supposed to be performed by a system administrator.

Note: PHP package can also be upgraded during this procedure. Oracle MySQL yum repository is supported only by Plesk Onyx. Also, it is required to have an SSH connection to the server with administrative privileges.

For CentOS/RHEL/CloudLinux systems Atomic repository can be used: (click to expand)

  1. Install the Atomicorp repository:

    # wget -q -O - https://www.atomicorp.com/installers/atomic | sh

  2. Upgrade MySQL:

    # yum upgrade mysql

  3. Restart the MySQL service:

    # service mysqld restart

  1. Upgrade MySQL databases:

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

  2. Execute this command to update the package version inside Plesk:

    # plesk bin service_node --update local

For Debian/Ubuntu systems MySQL 5.5 should be available from default repositories: (click to expand)

  1. Update all system packages:

    # apt-get update

  2. Upgrade MySQL:

    # apt-get upgrade mysql-server

  3. Restart the MySQL service:

    # service mysql restart

  4. Upgrade MySQL databases:

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

  5. Execute this command to update the package version inside Plesk:

    # plesk bin service_node --update local

 

Additional information

Comments

26 comments

Sort by Date Votes
  • Avatar
    Greg Sims

    I am running RHEL 6.  This process will not work using sudo -- you must be root.  Issue "sudo su" prior to issuing the commands above.

    0
    Comment actions Permalink
  • Avatar
    Anton Maslov

    @Greg,

     

    In general articles are written considering that all the commands will be invoked with root privileges since we do not know how exactly our customers work on the server (under root or not).

    Thank you for the comment - I believe it will be useful for other Pleskians :)

     

    1
    Comment actions Permalink
  • Avatar
    kanenses

    Do not working, or better do not upgrading, getting:

    Loaded plugins: presto
    Setting up Upgrade Process
    No Packages marked for Update

    But, sql server are on 5.1.73

    1
    Comment actions Permalink
  • Avatar
    Bulat Tsydenov

    @David, Hi! 

    As I understand you receive that output when running `yum upgrade mysql`

    Please, provide me with the following information:

    - OS version

    - the output of `yum repolist` command

    - the output of `rpm -qa | grep mysql` command

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello @Sistem, this command is fine and tested. 

    Usually, it does not have output but it is ok.

    Could you share which exact issue do you have when upgrading MySQL?

    0
    Comment actions Permalink
  • Avatar
    Unknown User

    Hi I would like to know is this procedure will be the same to upgrad mysql from 5.5 to 5.7?

    0
    Comment actions Permalink
  • Avatar
    Anzhelika Khapaknysh

    Hi @tesshsu!

    The procedure is a bit different. Check this article for details.

    0
    Comment actions Permalink
  • Avatar
    Unknown User

    got it, thank you @Anzhelika Khapaknysh

    0
    Comment actions Permalink
  • Avatar
    Anatoly Kirsanov

    How to use Oracle MySQL yum repository in this procedure? I use Plesk Onyx on CentOS 6.10.

    0
    Comment actions Permalink
  • Avatar
    Alexandr Redikultsev

    Hi @Anatoly Kirsanov,

    You can try to configure them manually at /etc/yum.repos.d/custom.repo file. Then execute `yum update` to update the repository information.

    0
    Comment actions Permalink
  • Avatar
    Anatoly Kirsanov

    What is the best choice repository in this procedure - Atomic or MySQL-community repository (Oracle)?

    I plane to upgrade 5.5. to 5.7 afterwards.

    0
    Comment actions Permalink
  • Avatar
    Jorge Salazar

    Hi There,

    I tried to do this process on Plesk with CentOS 6.1 and it didn't work.

    The first command is not downloading anything from Atomicorp (wget -q -O - http://www.atomicorp.com/installers/atomic | sh) so when you pipe this to execute sh it des not add and install the repo.

    Could someone from Plesk update this information, please?

    Thanks.

    0
    Comment actions Permalink
  • Avatar
    Tom Cozzie

    Ran the commands to upgrade mySQL from 5.1.73 to 5.5 on Centos as root. When I ran mysql-upgrade I received a "failed while fetching server version! could be due to unauthorized access" message and upgrade failed. How do I ensure access to complete this command?

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello @Jorge Salazar,

    Please, check the network configuration for this server.

    I have checked the command on a test server (CentOS 6), it is correct:

    # wget -q -O - http://www.atomicorp.com/installers/atomic | sh

    Atomic Free Unsupported Archive installer, version 4.1

    BY INSTALLING THIS SOFTWARE AND BY USING ANY AND ALL SOFTWARE
    PROVIDED BY ATOMICORP LIMITED YOU ACKNOWLEDGE AND AGREE:
    ...

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello @Tom,

    Could you let me know the exact command you have used? Was it as in this article or modified somehow?

    Please, check this forum topic devoted to similar issue:

    https://talk.plesk.com/threads/mysql-upgrade.343566/

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    @Jorge,

    If my above suggestion would not help, try this steps:

    1. Create the atomic.repo file manually in /etc/yum.repos.d/ and add the following content:

    # Name: Atomic Rocket Turtle RPM Repository for CentOS / Red Hat Enterprise Linux 6 -
    # URL: http://www.atomicrocketturtle.com/
    [atomic]
    name = CentOS / Red Hat Enterprise Linux $releasever - atomic
    mirrorlist = http://updates.atomicorp.com/channels/mirrorlist/atomic/centos-$releasever-$basearch
    enabled = 1
    protect = 0
    gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY.art.txt
            file:///etc/pki/rpm-gpg/RPM-GPG-KEY.atomicorp.txt
    gpgcheck = 1


    # Almost Stable, release candidates for [atomic]
    [atomic-testing]
    name = CentOS / Red Hat Enterprise Linux $releasever - atomic - (Testing)
    mirrorlist = http://updates.atomicorp.com/channels/mirrorlist/atomic-testing/centos-$releasever-$basearch
    enabled = 0
    protect = 0
    gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY.art.txt
            file:///etc/pki/rpm-gpg/RPM-GPG-KEY.atomicorp.txt
    gpgcheck = 1

    2. Run "yum update"

    3. Download the content from http://www.atomicorp.com/installers/atomic: 

    # wget http://www.atomicorp.com/installers/atomic

    4. execute the file with sh:

    # sh atomic

    That should install the atomic gpg keys and then you may proceeded with the article steps.

    1
    Comment actions Permalink
  • Avatar
    Jorge Salazar

    Hi @Ivan Postnikov

    Yes, by doing it manually it worked!.

    Thanks for this.

    Regards,

    Jorge

    0
    Comment actions Permalink
  • Avatar
    Tom Cozzie

    @Ivan,

    I used the exact commands posted, also broke up the mysql-upgrade command to enter the password location separately at the prompt, still got the "failed while fetching Server version! could be due to unauthorized access."

    0
    Comment actions Permalink
  • Avatar
    Denis Bykov

    @Jorge,

    Most likely, the issue was caused by the incorrect repository link. From my side, I see the following:

    http://www.atomicorp.com/installers/atomic - shows error 404
    https://www.atomicorp.com/installers/atomic - works as expected. I corrected it in the article.

    0
    Comment actions Permalink
  • Avatar
    Denis Bykov

    @Tom Cozzie

    Try resetting 'admin' password using the solution from the following article - https://support.plesk.com/hc/en-us/articles/213364309.
    After that proceed with mysql_upgrade as described here.

    If it will not help, I'd suggest submitting a ticket to regular Plesk support.

    0
    Comment actions Permalink
  • Avatar
    John Shaw

    Sorry for the 'Noob' question, but I'm temporarily taking over the maintenance of a Plesk/linux server running CentOS6.10 / Onyx 17.8.11 / and MYSQL 5.1.73

    The server runs our company websites + a couple of test domains, all in WordPress.

    My question is:

    I need to install Magento for another project which needs to use MySQL 5.6 min, but I'm worried that upgrading will cause issues with the existing WordPress DBs. Is it possible to create a second MySQL Server and upgrade this to the latest?

    Apologies if this should have had it's own post - but thought it was an appropriate start point.

    Thanks

    0
    Comment actions Permalink
  • Avatar
    Anton Maslov

    @John Shaw

    There are two options:

    1. You register remote(installed somewhere else) MySQL server 5.6 to Plesk

    2. If your server support, you may add Docker extension and run another MySQL server as a Docoker container

    0
    Comment actions Permalink
  • Avatar
    John Shaw

    @Anton Maslov

    Thanks!

    I think an external may need to be the option we go for as I've just checked the Docker extension specs and it needs CentOS7 which opens up a separate set of complexities.

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello @John,

    I agree with you. Remote MySQL server looks like the easiest solution.

    0
    Comment actions Permalink
  • Avatar
    do4a (Edited )

    Hi. 

    Then I run "yum upgrade mysql" I get "no packages marked for update". 



    Ver 15.1 Distrib 10.2.32-MariaDB, for Linux (x86_64) using readline 5.1

    Product version: Plesk Obsidian 18.0.27.1
    OS version: CentOS 7.8.2003 x86_64
    Build date: 2020/05/22 12:00

    Tried yum clean all and yum update, but it seems not not help either :(

    This is want I get for replist https://pastebin.com/HJtvNN6n

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello do4a

    In your case, it's required to follow this guide: https://support.plesk.com/hc/en-us/articles/213403429

    Looks like the correct repository wasn't set.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles