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.