Install Mariadb 10.1 – Ubuntu 16.04

Installing the latest stable version of Mariadb, v. 10.1, is pretty straight forward.

Start off by heading over to the repo configurator and getting the links for your version of Ubuntu: LINK

For us the commands were as follows, enter them at terminal:

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://ftp.ubuntu-tw.org/mirror/mariadb/repo/10.1/ubuntu xenial main'

Now to install MariaDB,

sudo apt update
sudo apt install mariadb-server

The setup will ask you to set a password and that’s it. To access the Mysql shell via terminal do the following:

mysql -u root(Or any other user in mysql) -p

A prompt will show up asking you for the password, enter that and hit Enter.