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

Git Tag Cheat Sheet

Introduction Git tags are an essential feature of version control systems, offering a simple way…

3 months ago

Understanding Web Storage: Cookies, Local Storage

Introduction The methods that browsers employ to store data on a user's device are referred…

4 months ago

Setting up OpenVPN Access Server in Amazon VPC – AWS

Introduction A well-known open-source VPN technology, OpenVPN provides strong protection for both people and businesses.…

4 months ago

Enhance Error Tracking & Monitoring: Integrate Sentry with Node.js & Express.js

Introduction Integrating Sentry into a Node.js, Express.js, and MongoDB backend project significantly enhances error tracking…

4 months ago

Comparing Callbacks, Promises, and Async/Await in JavaScript

Introduction In the world of JavaScript development, efficiently managing asynchronous operations is essential. Asynchronous programming…

6 months ago

How To Secure Nginx with Let’s Encrypt on Ubuntu EC2 Instance

Introduction Let's Encrypt is a Certificate Authority (CA) that makes it simple to obtain and…

8 months ago