MariaDB on Ubuntu Linux

Would you like to learn how to install MariaDB on Ubuntu Linux? In this tutorial, we are going to show you how to install, configure and access the MariaDB database on Ubuntu Linux version 17.

Hardware List:

The following section presents the list of equipment used to create this Ubuntu Linux tutorial.

Every piece of hardware listed above can be found at Amazon website.

Ubuntu Related Tutorial:

On this page, we offer quick access to a list of tutorials related to Ubuntu linux.

Tutorial - MariaDB on Ubuntu Linux

On the Linux console, use the following commands to set the correct timezone.

# dpkg-reconfigure tzdata

Install the Ntpdate package and set the correct date and time immediately.

# apt-get install ntpdate
# ntpdate pool.ntp.br

In our example, the Ntpdate command was used to set the correct date and time using the Brazilian server pool.ntp.br

Let's install the NTP service.

# apt-get install ntp

NTP is the service that will keep our server updated.

Use the command date to check the date and time configured on your Ubuntu Linux.

# date

If the system shown the correct date and time, this means that you followed all the steps correctly.

Use the following commands to install the MariaDB server and client packages.

# apt-get update
# apt-get install software-properties-common
# apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
# add-apt-repository 'deb [arch=amd64,i386] http://nyc2.mirrors.digitalocean.com/mariadb/repo/10.2/ubuntu artful main'
# apt-get update
# apt-get install mariadb-server mariadb-client

The installation wizard will ask you for a password to the root user.

After finishing the installation, use the following command to access the MariaDB database server.

To access the database server, enter the password set on the MariaDB server installation wizard.

# mysql -u root -p