Upgrading MySQL using the MySQL SLES repository

MySQL can be upgraded using the MySQL SLES repository. Let's look at the steps required for this upgrade. By default, the MySQL SLES repository updates MySQL to the latest version in the release series selected by the user during installation.

To update to a different release series, the subrepository for the selected series needs to be disabled. It is recommended to upgrade from one series to the next rather than skipping a series. In-place downgrade of MySQL is not supported when using the MySQL SLES repository.

Upgrade MySQL

Use the following command to upgrade MySQL and its components -

shell> sudo zypper update mysql-community-server

Otherwise, MySQL can be updated by instructing Zypper to update everything on the user's system. This takes more time. This can be done using the following command -

shell> sudo zypper update

MySQL server restarted after Zypper update. Prior to MySQL 8.0.16, run "mysql_upgrade" after a server restart. This will check and resolve any incompatibilities between old data and upgraded software

Listing packages from the SLES repository

Specific components can also be upgraded. First, use the following command to list the installed packages in the MySQL SLES repository.

shell> zypper packages −i | grep mysql−.*community

Once you have selected the package name of the required component, you can update the package using the following command -

shell> sudo zypper update package-name

The above is the detailed content of Upgrading MySQL using the MySQL SLES repository. For more information, please follow other related articles on the PHP Chinese website!