How do I update MySQL 5.7 to the new MySQL 8.0?

Question

How do I update to MySQL 8.0 from the default version (5.7)?

It's important for me for it to make an update and not re-install MySQL so all my data won't be corrupt.

There is not a lot of info regarding this issue since it was only released not long ago with tons of awesome new features!

This is what I have found that seems like it will only update and not destroy my data. I'm not going to proceed until I'm sure.

Answer 1

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. The way i choose is to use APT Repository.

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.16-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.16-1_all.deb

Then you'll get this:

press Enter when you choose mysql server ,then select mysql 8.0.Finally choose like this:

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

Answer 2

I have small appendix to the helpful answer by 请叫我小马哥.

My challenge was to update MySQL client from 5.7 to 8.0. I needed that because I got warnings when tried to export remote 8.0 database with client 5.7 and MySQL Workbench 6.3 at my ubuntu 18.04 machine. I did not have MySQL server installed and I did not intend to do it.

The install command was

sudo apt-get install mysql-community-client

The next step was to install MySQL Workbench Community 8.0 because 6.3 threw mysqldump version error when tried to export. I have done the instalation in lamer's way using ubuntu Software app. This probably saved me connection issues because I could at once apply required commands as detailed in the description:

sudo snap connect mysql-workbench-community:password-manager-service 
sudo snap connect mysql-workbench-community:ssh-keys
sudo snap connect mysql-workbench-community:cups-control

The last one did not work for me, so I skipped it:

sudo snap connect mysql-workbench-community:cups-control

Answer 3

Use Mysql manual https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/#apt-repo-fresh-install

The sequence there is about the same, but it seems that the link to the settings file is changing. I use https://dev.mysql.com/get/mysql-apt-config_0.8.13-1_all.deb