Home » Tutorial » How to Install MySQL 8 on Ubuntu 17.04 Linux Operating System

How to Install MySQL 8 on Ubuntu 17.04 Linux Operating System

Update on:
Jun 21, 2019

MySQL is the most popular and highly used Open source relational database management system; it is no more available with the default repository of Ubuntu Operating system after releasing of version 8.

Now MariaDB has become the default database management system for new Ubuntu Operating system, and it is backward compatible and perfect replacement of MySQL Database System.

In this tutorial, the article will show you how to install MySQL Server into the Ubuntu 17.04 Operating system using MySQL APT Repository.

I suggest you if your application has specific requirement of MySQL database then only install MySQL server otherwise you can stick with MariaDB the default database management system in Ubuntu 17.04.

Prerequisites

Before following the below steps to install MySQL, make sure you have Ubuntu 17.04 installed a system with a user who has sudo privileges.

Install MySQL

To install MySQL on Ubuntu 17.04 machine, follow below procedure:

Step 1 – MySQL Repository Configuration

To install MySQL into Ubuntu 17.04 Operating System, you need to add MySQL APT repository, to install the latest repository need to go to the MySQL repository download page and download the latest release package by using the following command:

$ wget http://repo.mysql.com/mysql-apt-config_0.8.13-1_all.deb

After completing the download, install the release package with the following command:

$ sudo dpkg -i mysql-apt-config_0.8.13-1_all.deb

You will get the below configuration menu to select MySQL version you want to install.

MySQL 8.0 is pre-selected for this repository, if you want to install another version of MySQL, choose MySQL Server & Cluster (Currently selected: mysql-8.0) and select your preferred version of MySQL.

As we are going to install MySQL with version 8.0, Select the last option OK and press Enter to save the configuration.

Step 2 – MySQL Installation

To install MySQL on Ubuntu 17.04 Operating system first update the repositories package list by using the following command:

$ sudo apt update

After updating the package, you can start the MySQL installation by using the following command:

$ sudo apt install mysql-server
  • Facebook
  • Twitter
  • reddit
  • LinkedIn

The installation process will prompt you to enter the MySQL root password, don’t set password right now we will do it in next session.

Now, you will get a new screen for authentication plugin message for MySQL 8, before selecting the default MySQL 8 authentication to make sure your application is supporting it or not.

Step 3 – MySQL Verification
 
Once the MySQL installation process completed, the MySQL service will automatically start.

You can check the MySQL service status by using the following command:

$ sudo systemctl status mysql
  • Facebook
  • Twitter
  • reddit
  • LinkedIn
Step 4 – Securing MySQL
 
To secure the MySQL database system run the mysql_secure_installation command, it will help you to set the root password and to improve newly installed MySQL security.
$ sudo mysql_secure_installation
  • Facebook
  • Twitter
  • reddit
  • LinkedIn

The screen will have asked you to configure the VALIDATE PASSWORD PLUGIN, which is use to check the MySQL password strength. It defines the password policy validation in three levels low, medium, and strong. If you don’t want to set the validate password plugin press the Enter button.

Next screen will ask you to set the root password:

  • Facebook
  • Twitter
  • reddit
  • LinkedIn

Once root password is set the script will ask you to remove the anonymous user, restrict root access to the localhost and remove test database, and you should answer Y (yes) for all the question to secure the MySQL.

  • Facebook
  • Twitter
  • reddit
  • LinkedIn
Step 5 – Connect MySQL through CLI
 
To connect with MySQL server, you need to first login into the MySQL Server through Command-line interface by using the following command:
$ mysql –u root –p

Now you will get the screen to enter the root password which you had set when the mysql_secure_installation script was running.

After entering the password you will get into the MySQL shell, and your screen will like below image:

  • Facebook
  • Twitter
  • reddit
  • LinkedIn

Conclusion

Now you learned the process to install MySQL server on Ubuntu 17.04 Operating system. You also know how to get into the MySQL shell to perform database commands and operations.

If you have any doubt or issue related with installation, feel free to leave comment below.

Related Posts

How to Install CouchDB on Ubuntu 21.04 Linux Operating System

How to Install CouchDB on Ubuntu 21.04 Linux Operating System

The CouchDB is an open-source database system, managed by the Apache Software Foundation. It is fault-tolerant, and schema-free NoSQL database management system.   CouchDB store data in document or files with JSON data structure. Each document contains fields and...

How to add swap space on Ubuntu 21.04 Operating System

How to add swap space on Ubuntu 21.04 Operating System

The swap space is a unique space on the disk that is used by the system when Physical RAM is full. When a Linux machine runout the RAM it use swap space to move inactive pages from RAM. Swap space can be created into Linux system in two ways, one we can create a...

How to Install Nginx on Ubuntu 21.04 Server

How to Install Nginx on Ubuntu 21.04 Server

Nginx is the most potent, open-source, and a high-performance Web server. It can work as a reverse proxy server also, nowadays, is used by most of the most significant websites on the internet. People pronounced “engine x” for Nginx; it is the hot choice for every...

How to Install VirtualBox on Ubuntu 21.04 Linux

How to Install VirtualBox on Ubuntu 21.04 Linux

VirtualBox is an Open Source tool, known as a cross-platform virtualization application or software. It used to run multiple operating systems or virtual machines simultaneously on a single hardware. In this VirtualBox installation tutorial, we will explain the...

Follow Us

Our Communities

More on Ubuntu

The Ultimate Managed Hosting Platform
Load WordPress Sites in as fast as 37ms!

0 Comments

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

19 − four =

Shares