Ubuntu20.04安装MySQL5.7

1. 查看系统版本

cat /etc/lsb-release
或者
hostnamectl

2. 添加MySQL源

sudo vim /etc/apt/sources.list.d/mysql.list

3. 添加如下内容

deb http://repo.mysql.com/apt/ubuntu/ bionic mysql-apt-config
deb http://repo.mysql.com/apt/ubuntu/ bionic mysql-5.7
deb http://repo.mysql.com/apt/ubuntu/ bionic mysql-tools
deb-src http://repo.mysql.com/apt/ubuntu/ bionic mysql-5.7

4. 更新源

sudo apt update

5. 可能会报以下错误

W: GPG error: http://repo.mysql.com/apt/ubuntu bionic InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29
E: The repository 'http://repo.mysql.com/apt/ubuntu bionic InRelease' is not signed.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.

6. 设置key为报错信息中NO_PUBKEY后面的值

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 467B942D3A79BD29

7. 更新源

sudo apt update

8. 查看支持的MySQL版本

sudo apt-cache policy mysql-server

9. 根据自己支持的版本进行安装

sudo apt install mysql-client=5.7.40-1ubuntu18.04
sudo apt install mysql-server=5.7.40-1ubuntu18.04