My SQL

Upgrade MySQL 5.7 to 8. on Ubuntu very easy step

In this article we will learn how to upgrade MySQL 5.7 to 8. on Ubuntu.  Please follow below step it is very easy.

Upgrade MySQL 5.7 to 8. on Ubuntu

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

Once you execute the above command 1 screen will appear. Select Mysql Server and cluster (Currently selected : mysql-8.0) and Hit Enter

Now choose MySQL 8 option and press OK

Click Ok to finish the setup.

Step 2. Update APT index and install MySQL server

Now we will update the 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:

Step 3. Manage mysql.service

You can use the following commands to manage mysql instance.

Start and stop the service using following command

$ sudo systemctl start mysql.service
$ sudo systemctl stop mysql.service

related Articles

The Requested Url /Phpmyadmin/ Was Not Found On This Server

MYSQL Dump File Using Command Prompt ?

PhpMyAdmin Issue With 7.2 [Sql.Lib.Php]

Why All Sites Now Require SSL (Https)

How To Set Session In CodeIgniter With Basic Example
Developer Diary

Share
Published by
Developer Diary
Tags: Ubuntu

Recent Posts

Laravel vs Node Js: Which One Is Good For What?

Introduction In the world of web development, selecting the correct framework is critical. Laravel and…

3 months ago

Docker Cheatsheet: Essential Commands and Explanations

Introduction By enabling containerization, Docker has transformed the way software is built, deployed, and managed.…

7 months ago

Difference between Memcached and REDIS – Secrets of Caching

Introduction Speed and efficiency are critical in the ever-changing world of web development. Effective caching…

8 months ago

How to Revert a Git Commit: A Simple Example

Introduction Git, a popular version control system in software development, enables developers to track changes,…

8 months ago

What is Git Stash and Why Do You Need It

Introduction Are you tired of grappling with tangled changes and unfinished work while using Git?…

8 months ago

Difference between git stash pop and git stash apply

Introduction Version control is essential in software development because it ensures that changes to a…

8 months ago