Installing MariaDB in Ubuntu

On the test I will install MariaDB in Ubuntu 16.04.
First of all, let’s look at the required repository at
There is also an instruction for their addition.

Since I install in Ubuntu 16.04, the commands for adding the repository will be as follows:

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

After that, install MariaDB server and client:

sudo apt-get install mariadb-server mariadb-client

After installation, we will perform several security tips (remove the test base, disallow the root user remote access, etc.):

sudo mysql_secure_installation

You can connect to MariaDB server as follows:

sudo mysql -u root -p

To view the status, stop, start the MariaDB server, you can use the commands:

sudo systemctl status mariadb
sudo systemctl stop mariadb
sudo systemctl start mariadb

If you need to uninstall MariaDB, then do:

sudo apt-get autoremove mariadb-server mariadb-client

Leave a Reply