On the test I will install MariaDB in Ubuntu 16.04.
First of all, let’s look at the required repository at https://downloads.mariadb.org/mariadb/repositories/
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://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
sudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] http://mirror.ehv.weppel.nl/mariadb/repo/10.2/ubuntu 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
See also my article:
Installing and configuring MySQL server on Ubuntu