How to Install MySQL on Ubuntu 16.04 LTS?

Introduction

MySQL is a relational database that is used to store data. It is most widely used database provides set of advance features, management tools, technical support, scalability and security.

It is a product of Oracle Corporation and first released on 23 may 1995.

In this tutorial, we will install MySQL on Ubuntu 16.04 LTS. This whole process includes the following steps.

Prerequisites

• Ubuntu
• login as a root user in terminal

MySQL Installation

We can use following command to install MySQL.

Configuration

At the time of configuration, it will prompt for MySQL credentials.

Provide password

Confirm entered password.

Login into MySQL

use the following command to login into MySQL.

Well, we have successfully installed and logged in to MySQL.

Extra Info

We can use following commands to manage MySQL database.

MySQL Status

Use the following command to check running status of MySQL.

Start MySQL

Use the following command to start MySQL database.

Stop MySQL

Use the following command to stop MySQL database.

Restart MySQL

Use the following command to restart MySQL database.

Remove MySQL

Use the following command to remove MySQL database.

Use the following command to remove all packages that were installed automatically while installing MySQL database.