Upgrade MySQL from 5.7 to 8 on Ubuntu 18.04 - BRS MEDIA TECHNOLOGIES

Upgrade MySQL from 5.7 to 8 on Ubuntu 18.04

In this article we will upgrade MySQL on Ubuntu 18.04 LTS from version 5.2.27 to 8.x using command line.

Step 1. Add MySQL APT repository

We will download and add the MySQL APT repository to system’s software repository list.Download and Add APT repository

$ wget https://repo.mysql.com//mysql-apt-config_0.8.14-1_all.deb

$ sudo dpkg -i mysql-apt-config_0.8.14-1_all.deb

The latest version of APT config can be found at https://dev.mysql.com/downloads/repo/apt/

The below screen will appear:

mysql 8 1

Select the MySQL Server & Cluster option and hit enter:

mysql 8 2

Now choose MySQL 8 option and press OK

mysql 8 3

Click Ok to finish the setup.

Step 2. Update APT index and install MySQL server

Now we will update thr APT index and install the latest version of MySQL server using the following commands.

$ sudo apt-get update

$ sudo apt-get install mysql-server

Confirm installation:

$ sudo apt policy mysql-server

Step 3. Manage mysql.service

You can use the following commands to manage mysql instance.Start the service

$ sudo systemctl start mysql.service

Stop the service

$ sudo systemctl stop mysql.service

Status of service

$ sudo systemctl status mysql.service

Related Article

file sharing Windows and Linux

File Sharing between Windows and Linux

Contents1 Overview2 Install Samba3 Stop Samba daemon4 Back up Samba config file5 Create new Samba config file6 Create Samba shares […]

install-jenkins-ubuntu

How to Install Jenkins on Ubuntu 22.04 or 20.04 Linux

Learn the steps and commands to install Jenkins software on Ubuntu 22.04 LTS Jammy JellyFish or 20.04 Focal Fossa Linux […]

Linux File & Folder

Linux File/Folder Permissions

sudo chmod -R 777 [Path:/media/folder/files] Explained Command: SuperUserDo ChangeMode -Recursively OwnerGroupUser [Path of File or Directory or Drive] Every file […]