How to Install MariaDB on Ubuntu 18.04 – onlinecode

How to Install MariaDB on Ubuntu 18.04 – onlinecode

In this post we will give you information about How to Install MariaDB on Ubuntu 18.04 – onlinecode. Hear we will give you detail about How to Install MariaDB on Ubuntu 18.04 – onlinecodeAnd how to use it also give you demo for it if it is necessary.

Today, We will discuss how to install MariaDB on Ubuntu 18.04. The MariaDB is a database server and it’s an open-source relational database management system, so you can download and use it as much as you want free of charge. There are two ways to install MariaDB. (1) Install from MariaDB mirror and (2) Install from repository

(1) Install from MariaDB mirror

First, find the MariaDB repository file from the official website. after then import the package key and added the repository package on your system.

Ubuntu 18.04 LTS “bionic”

PHP
sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el]  bionic main'

Ubuntu 16.04 LTS “xenial”

PHP
sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
sudo add-apt-repository 'deb [arch=amd64,arm64,i386,ppc64el]  xenial main'

Install from repository

The MariaDB Installing from the Ubuntu default repository is a straightforward way. but you if you want to use below the following command then will be installed the old version of MariaDB.

PHP
sudo apt-get update
sudo apt-get install mariadb-server mariadb-client

During installation, we will ask you root user password and confirmation password.

Mysql Secure Installation

PHP
sudo mysql_secure_installation

Above command run in the command prompt, it will ask you following configuration.

PHP
set root password (if not set in the configuration step above).
disable remote root login
remove test database
remove anonymous users and
reload privileges

After complete installation, we will check a MariaDB connection using the below command.

PHP
mysql -u root -p

If you want to know the server status or you want to start or stop server then you can do using the below command.

PHP
sudo systemctl start mariadb
sudo systemctl enable mariadb
sudo systemctl status mariadb

Please follow and like us:

Hope this code and post will helped you for implement How to Install MariaDB on Ubuntu 18.04 – onlinecode. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs

For More Info See :: laravel And github

Leave a Comment

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

28  +    =  36

We're accepting well-written guest posts and this is a great opportunity to collaborate : Contact US