Ubuntu 20.04 comes with MySQL 8.0 as the default package. But, sometimes, you need MySQL 5.7 for your legacy apps that don't support MySQL 8.0 yet. This tutorial explains how to add MySQL 5.7 package and install it on Ubuntu 20.04.
Before you begin, you should :
Deploy a fully updated Ubuntu 20.04 server.
Because Ubuntu 20.04 only has MySQL 8.0 in the APT repository, you need to add MySQL 5.7 repository first before installing it. Download MySQL repository using the following commands :
$ wget https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_all.deb
Once it's downloaded, install the repository :
$ sudo dpkg -i mysql-apt-config_0.8.12-1_all.deb
In the prompt, choose the Ubuntu Bionic. And then select the MySQL Server & Cluster option. After that, choose mysql-5.7 and then select ok.
After it's finished, update the APT repository :
$ sudo apt update
If you encounter the "signature couldn't be verified" error like this :
The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29
You need to import the missing gpg key with the following command :
$ sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 467B942D3A79BD29
After that, rerun the apt update :
$ sudo apt update
Check if MySQL 5.7 repository is successfully installed by using this command :
$ sudo apt-cache policy mysql-server
You should see MySQL 5.7 repository appearing at the bottom of the list.
mysql-server:
Installed: (none)
Candidate: 8.0.27-0ubuntu0.20.04.1
Version table:
8.0.27-0ubuntu0.20.04.1 500
500 http://us.archive.ubuntu.com/ubuntu focal-updates/main amd64 Packages
500 http://us.archive.ubuntu.com/ubuntu focal-security/main amd64 Packages
8.0.19-0ubuntu5 500
500 http://us.archive.ubuntu.com/ubuntu focal/main amd64 Packages
5.7.37-1ubuntu18.04 500
500 http://repo.mysql.com/apt/ubuntu bionic/mysql-5.7 amd64 Packages
After you have MySQL 5.7 repository in your system, you can install it using the apt install :
$ sudo apt install -f mysql-client=5.7* mysql-community-server=5.7* mysql-server=5.7*
Press the Y key to start the installation and set the root password when prompted.
Reading package lists... Done
Building dependency tree
Reading state information... Done
Selected version '5.7.37-1ubuntu18.04' (MySQL:repo.mysql.com [amd64]) for 'mysql-client'
Selected version '5.7.37-1ubuntu18.04' (MySQL:repo.mysql.com [amd64]) for 'mysql-community-server'
Selected version '5.7.37-1ubuntu18.04' (MySQL:repo.mysql.com [amd64]) for 'mysql-server'
The following additional packages will be installed:
libmecab2 libtinfo5 mysql-common mysql-community-client
The following NEW packages will be installed:
libmecab2 libtinfo5 mysql-client mysql-common mysql-community-client mysql-community-server mysql-server
0 upgraded, 7 newly installed, 0 to remove and 1 not upgraded.
Need to get 51.6 MB of archives.
After this operation, 315 MB of additional disk space will be used.
Do you want to continue? [Y/n]
Before using MySQL 5.7 in production, you should secure it first. You can do that by running this command :
$ sudo mysql_secure_installation
Enter your MySQL root password and answer all of the security questions.
To check whether or not you installed the correct MySQL version. First, connect to MySQL with the root password that you set earlier.
$ mysql -u root -p
And then run this command :
SELECT VERSION();
You should see your installed MySQL version.
+-----------+
| VERSION() |
+-----------+
| 5.7.37 |
+-----------+
1 row in set (0.00 sec)
Congratulation, you have successfully installed MySQL 5.7 on your Ubuntu 20.04 server.