Category:

Tutorial

Duration: 4:23

7,440 views

85

In this video i am going to install mysql 5.7 in ubuntu 20.04.3 LTS.
Steps :


sudo apt update
wget https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.12-1_all.deb
Ubuntu bionic - Mysql server & cluster (currently selected....x) - mysql 5-7 - ok

sudo apt-get update

If you get an error like this :

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


Run this script :
sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 467B942D3A79BD29

sudo apt install -f mysql-client=5.7* mysql-community-server=5.7* mysql-server=5.7*

sudo apt-get update

If you got an error again :
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-community-server (= 5.7.37-1ubuntu18.04); however:
Package mysql-community-server is not configured yet.


fix with this:
vi /etc/apt/preferences.d/mysql

Package: mysql-server
Pin: version 5.7*
Pin-Priority: 1001

Package: mysql-client
Pin: version 5.7*
Pin-Priority: 1001

Clean Setup again:
apt-get remove mysql-client mysql-common mysql-community-client mysql-community-server mysql-server
apt-get purge mysql-client mysql-common mysql-community-client mysql-community-server mysql-server

apt-get update

Install mysql again :
sudo apt install -f mysql-client mysql-community-server mysql-server