upgrade mysql 5.7 to 8 ubuntu 18.04

November 28, 2019 210 views
MySQL

upgrade mysql 5.7 to 8 ubuntu 18.04

1 Answer

Hi @admin5f22619f891220d4d6936,

You can find answer in mysql doc. It has full details about how to upgrade. Make sure to back up data before upgrading.

There are tons of ways to upgrade in the docs. Let’s try using the APT Repository in this example.

You should do the following things:

First, add the MySQL APT repository to your system’s software repository list. The details in docs are a little abstract , i’ll give a example:

wget https://repo.mysql.com//mysql-apt-config_0.8.10-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.10-1_all.deb

It will show you a prompt, press Enter when you choose** mysql server ,then select mysql 8.0**.

Once the repo has been added, update apt index and install mysql-server:

sudo apt-get update
sudo apt-get install mysql-server

Now if you don’t get any error messages, you have already upgraded successfully. You can confirm by:

apt policy mysql-server

You will get output like this:

$ apt policy mysql-server
  mysql-server:
      Installed: 8.0.13-1ubuntu18.04
      Candidate: 8.0.13-1ubuntu18.04

Please note you’ll need to do some research before actually updating MySQL.

  1. Make sure your application(wordpress) actually supports MySQL 8
  2. Make sure to have a working backup of your MySQL databases in case anything goes wrong.

Regards,
KDSys

Have another answer? Share your knowledge.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!