MySQL

MySQL is an open-source relational database management system (RDBMS).

Installation

To install it in command line :

$ sudo apt-get install mysql-server

Credentials of the root user

Username : root

Password : devopstask

In order to change some of the less secure default options for things like remote root logins and sample users , we execute the included security script with :

$ mysql_secure_installation

In this process we :

• allow removal of anonymous users

• restrict root user to only connect from localhost

• remove the test database

To test that MySQL is properly installed and run well

$ systemctl status mysql.service

The output would look like

● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: active (running) since Tue 2018-11-13 17:03:23 UTC; 13min ago
 Main PID: 13755 (mysqld)
   CGroup: /system.slice/mysql.service
           └─13755 /usr/sbin/mysqld

Nov 13 17:03:22 ip-172-31-42-151 systemd[1]: Starting MySQL Community Server...
Nov 13 17:03:23 ip-172-31-42-151 systemd[1]: Started MySQL Community Server.