How To Install MariaDB On Ubuntu 18.04

Linux Tutorials VPS

April 7, 2020 by Harry

How To Install MariaDB On Ubuntu 18.04

MariaDB Database is a free and open-source database management system which is a distribution of MySQL and this is a developed project, led by the main developers of MySQL.MariaDB is currently used in very large and well-known companies such as Google, Craigslist, Wikipedia, archlinux, RedHat, CentOS, and Fedora and is very popular on the Linux operating system. Maria DB is written in C ++, Perl and Bash and supported in Microsoft Windows, Linux, OS X, FreeBSD, OpenBSD, Solaris operating systems.
In short, MariaDB can be called the optimized version of Mysql because it is much more efficient in performance and also has better security and is faster in responding to queries. Those who host a large number of websites will be very welcome. Usually, sites that work well with Mysql 5.6 and above will work well with Maria DB, and there is no need to worry about incompatibility issues after upgrading to MariaDB, and you can safely do so.

In this article, we are going to explain how to install the MariaDB database on Ubuntu 18.04. You can simply run this database on an online Linux VPS and access it from anywhere!

Instructions to Install MariaDB on Ubuntu

First, we install the MariaDB database with the following command.

sudo apt install mariadb-server mariadb-client

After installation, MariaDB services should start automatically, to make sure it is up and running, check its status as below.

sudo systemctl status mysql

MariaDB has no security by default, you need to run the security script below to secure it. The root password will then ask you to make sure that not everyone is able to login to the MariaDB database.

sudo mysql_secure_installation

MariaDB On Ubuntu18

When you run the script, it will ask you to enter the current root password. (do not enter anything and press Enter).
Then enter yes / y to answer the security questions below.

Set a root password? [Y/n]: y
Remove anonymous users? (Press y|Y for Yes, any other key for No) : y
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y
Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y

Helpful

About the Author Harry

I like to learn and to teach to make things easier

Leave a Reply

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