Javatpoint Logo
Javatpoint Logo

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.

Software MySql 1

Configuration

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

Software MySql 2

Provide password

Software MySql 3

Confirm entered password.

Software MySql 4

Login into MySQL

use the following command to login into MySQL.

Software MySql 5

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.

Software MySql 6

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.

Software MySql 7

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






Help Others, Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA