Maria DB Server on Debian Jessie

As Database server, I chose MariaDB instead of MySQL because it is a database management system (DBMS) that has emerged from the derivation of MySQL with GNU GPL (GNU General Public License), in Spanish Free Software License. This license guarantees freedom of use. In fact, it gives you the freedom to study the software, update it and share it with other users.Firstly, we have to install the “python-software-properties” package which is a package to manage the repositories.

# apt-get install software-properties-common

Now, let’s add a key which will allow us to read the repository of MariaDB Servers. Execute the next line:

# apt-key adv --recv-keys --keyserver 0xcbcb082a1bb943db

\r\nNow we have the key, we have to add the repository.  For that, we will execute the next line:\r\n

# add-apt-repository 'deb [arch=amd64,i386] jessie main'

\r\nWe will update our list of repositories and then we will install the package MariaDB. For this, we will execute  following lines:

# apt-get update 
# apt-get install mariadb-server

The installation will ask us to put in a password for the database’s root. Once we have installed everything, we will check that everything works by executing the next line:

# mysql -u root -p


We now know that the installation was successful. The next step is to do a simple configuration. For that, we have to execute the next line:

# mysql_secure_installation

The installation will be asking you different things and you just have to write yes or no. Here is a screenshot with responses as an example.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.