Home » Tutorial » How to Install MariaDB on Ubuntu 19.04 Linux Operating System

How to Install MariaDB on Ubuntu 19.04 Linux Operating System

MariaDB is a multi-thread, open-source relational database management system, a perfect replacement of MySQL database system. 

MariaDB maintained and developed by the MariaDB Foundation, including some of the MySQL developers. 

Ubuntu new release is coming with MariaDB default database system which is replacement of MySQL. 

In this tutorial article, we will learn the methods to install MariaDB into Ubuntu 19.04 operating system. 

There are two methods to install MariaDB into Ubuntu machine; one is use to directly install to Ubuntu repository and another to use MariaDB repository to install the latest MariaDB package.

Prerequisites

Before starting MariaDB install into Ubuntu machine, make sure you have a Ubuntu 19.04 running machine and a user to login into the system with sudo privileges.

Install MariaDB on Ubuntu 19.04 Server

You should follow below steps for MariaDB installation process on Ubuntu 19.04 Server:

Step 1 – Update Ubuntu 19.04 Repository

Before installing any new package on Ubuntu 19.04 operating system first need to update the repository package list, which is performed by the following command:

$ sudo apt update
Step 2 – Install MariaDB
 
Once the repositories package list updated in your system, you can start the MariaDB installation using below command:
$ sudo apt install mariadb-server
  • Facebook
  • Twitter
  • reddit
  • LinkedIn
Step 3 – Verify MariaDB Installation
 
You can verify MariaDB installation by checking the status of MariaDB service, as shown below:
$ sudo systemctl status mariadb

If MariaDB is installed and running properly, you will get output with Active and running status like below image.

  • Facebook
  • Twitter
  • reddit
  • LinkedIn

MariaDB Install on Ubuntu 19.04 using MariaDB Repository

If you want to install MariaDB latest version into your Ubuntu 19.04 system which not released into default Ubuntu 19.04 repositories, you can use MariaDB repository directly to install Latest MariaDB.

To install the Latest release of MariaDB on Ubuntu 19.04 using MariaDB repository follow below steps:

Step 1 – Enable MariaDB Repository
 
To install MariaDB using MariaDB repository first need to enable MariaDB repository and import repository key by using the following command:
$ sudo apt install software-properties-common dirmngr
$ sudo apt-key adv --recv-keys --keyserver http://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
$ sudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] http://mirrors.dotsrc.org/mariadb/repo/16/ubuntu stretch main'
Step 2 – Update package List and install MariaDB
 
After enabling MariaDB repository need to update repository packages and install MariaDB server by using the following command:
$ sudo apt update
$ sudo apt install mariadb-server
Step 3 – Verify MariaDB Installation
 
Once MariaDB gets installed it services automatically get started, you can verify it by checking MariaDB service, as shown below:
$ sudo systemctl status mariadb

If MariaDB is running correctly you will get the screen with Active and running status as below image:

  • Facebook
  • Twitter
  • reddit
  • LinkedIn

MariaDB Secure Installation

You need to run mysql_secure_installation script to secure MariaDB installation as shown below:
$ sudo mysql_secure_installation

This script will ask you to set the root user password, restrict root access to localhost, remove anonymous users, and remove the test database.

  • Facebook
  • Twitter
  • reddit
  • LinkedIn
  • Facebook
  • Twitter
  • reddit
  • LinkedIn

After completion of the script, it will reload privilege tables, and all the changes take effect immediately.

MariaDB Connection through CLI

To connect the MariaDB server through terminal or command-line interface, you should use mysql command as shown below:
$ mysql –u root –p

The above command will connect with MariaDB shell using the root user. The next screen will appear to enter the password for user root. Once you get the connection with MariaDB shell you will get the screen as shown below image:

  • Facebook
  • Twitter
  • reddit
  • LinkedIn

Conclusion

Now, we learned how to install MariaDB into Ubuntu 19.04 machine. We also learned to install MariaDB directly from MariaDB repository, how to secure MariaDB installation and connect process from CLI. 

If you have any doubt or issue 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 *

20 − nineteen =

Shares