MySQL upgrade from 5.7 to 8.x using YUM repository

 

Do the following steps to upgrade the Mysql from 5.7 to 8.

1. Stop the existing Mysql service

        systemctl stop mysqld

2. Remove the existing Mysql 5.7 yum repository

        To check the package name execute below command

             yum list installed|grep mysql

        

        Now remove the 5.7 version repository

             yum remove mysql57-community-release.noarch

3. Download and Install Mysql 8 version repository

        To download

            wget https://dev.mysql.com/get/mysql80-community-release-el9-1.noarch.rpm

        To install

            rpm -Uvh mysql80-community-release-el9-1.noarch.rpm

    

        Now you can verify.

             yum list installed|grep mysql

         

4. Do Mysql upgrade

        yum update mysql-community-server

        

        Once upgrade done, you can verify once again. 

5. Start the Mysql service and verify the Mysql version. You can notice that Mysql upgraded to                 5.7.42 to 8.0.32 version.

    systemctl start mysqld

Thank you all !