Install MySQLDump for MySQL 8.0 on Ubuntu 18.04

MySQLmysql8mysqldumpUbuntu

I am trying to install mysqldump on a Azure hosted Ubuntu VM.

During the build process I attempt the following command:

sudo apt-get update
sudo apt-get install -y --no-install-recommends mysql-client-8.0

This results in the following error:

Unable to locate package mysql-client-8.0

When I look at the package on packages.ubuntu.com, it is listed under Ubuntu Focal 20.04LTS (https://packages.ubuntu.com/focal/mysql-client-8.0)

If I change the installation command to:

sudo apt-get update
sudo apt-get install -y --no-install-recommends mysql-client

It installed mysql-client-5.7 which isn't running properly. Is the mysql-client version for the appropriate database tied to the Ubuntu server? Should the 5.7 client work correctly with MySQL 8.0?

Best Answer

To get 8.0 client tools (or server) you have to install the official MySQL repo for apt. I recommend to follow this detailed guide.

TLDR;

  1. go to https://dev.mysql.com/downloads/repo/apt/
  2. find the link for the latest deb package (use that in the following steps)
  3. on your server:
  4. wget -c https://dev.mysql.com/get/mysql-apt-config_0.8.16-1_all.deb
  5. sudo dpkg -i mysql-apt-config_0.8.16-1_all.deb
  6. sudo apt-get update
  7. sudo apt-get install mysql-client
  8. mysqldump --version (should say Ver 8.x.x)
Related Topic