Check this Out!Visit our social network pages for recent updates!

WordPress Beginners – Installing MariaDB on Ubuntu 17.04

Want to install MariaDB on Ubuntu 17.04? This brief tutorial is going to show you the steps to get it done.

MariaDB is a drop-in replacement for MySQL. This means, if you rip out MySQL and install MariaDB, applications and services that depended on MySQL will still function. These application won’t know the difference.

To get MariaDB on Ubuntu, all one has to do is run the commands below:

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

The commands above will install the latest stable version of MariaDB in Ubuntu default repositories.

However, if you want to install the absolute latest of MariaDB, you may have to add its repositories to your system. To do that, run the commands below to add its repository key to Ubuntu

sudo apt-key adv --recv-keys --keyserver hkp:// 0xF1656F24C74CD1D8

Then run the commands below to add MariaDB version repository to your Ubuntu machine. Take notes of the highlighted version number ( 10.2 )in the line code below. Replace the version number appropriately. So, if the latest version number is 11.1, you replace 10.1 with it.

sudo sh -c "echo 'deb '$(lsb_release -cs)' main' > /etc/apt/sources.list.d/MariaDB.list"

After adding the repository, run the commands below to update and install the server

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

When you’re done installing the database server above, run the commands below to secure it with a root password.

sudo mysql_secure_installation

You’ll get prompted to answer the below questions.. use this guide below to answer.

Enter current password for root (enter for none): PRESS ENTER

Set root password? [Y/n] Y

Remove anonymous users? [Y/n] Y
Disallow root login remotely? [Y/n] Y
Remove test database and access to it? [Y/n] Y
Reload privilege tables now? [Y/n] Y

Finally, run the commands below to enable the server to always start up everytime you boot up Ubuntu

sudo systemctl enable mariadb.service

Enjoy and place come back soon

One Comment

Leave a Reply