Installing relational databases with MySQL

In this recipe, we will learn how to install and configure the MySQL database on an Ubuntu server.

Getting ready

You will need access to a root account or an account with sudo privileges.

Make sure that the MySQL default port 3306 is available and not blocked by any firewall.

How to do it…

Follow these steps to install the relational database MySQL:

1. To install the MySQL server, use the following command:

   $ sudo apt-get update
   $ sudo apt-get install mysql-server-5.7
   

   The installation process will download the necessary packages and then prompt you to enter a password for the MySQL root account. Choose a strong password:

   
2. Once the installation process is complete, you can check the server status with the following command. It should return an output similar to the following:

   $ sudo service mysql status
   mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service
     Active: active (running) since Tue 2016-05-10 05:
   

3. Next, create...