Home / server / Questions / 1023046
Accepted
JimmyBanks
Asked: 2020-06-27 06:20:45 +0800 CST

Install MySQLDump for MySQL 8.0 on Ubuntu 18.04

  • 772

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?

ubuntu mysql mysqldump mysql8

2 Answers

  1. 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)
    • 9

  2. Forget MySql packages, use MariaDb packages instead:

    sudo apt-get install -y mariadb-client

    https://mariadb.com/kb/en/mysqldump/

    • 8