Turn Fedora 25 into a powerful Database Server with MariaDB

Its now time to play with Fedora 25 Server. On this tutorial, I will show you how to install the latest version of MariaDB database server on Fedora 25 Server.  The latest stable version of MariaDB 10.1 is available for Fedora 25. We can install it via Terminal. With MariaDB, we can turn our Fedora 25 Server into a powerful SQL database server. As you might know, MariaDB is a fork of MySQL Server which is used by millions users around the world.

Steps to install MariaDB Server on Fedora 25

Open Terminal and execute the following command to install MariaDB as root user.

dnf install mariadb mariadb-server

Start MariaDB server

systemctl start mariadb

Check MariaDB status

systemctl status mariadb

Make sure the status is Running

[root@fedora25 ~]# systemctl status mariadb
● mariadb.service - MariaDB 10.1 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: dis
   Active: active (running) since Sen 2017-01-16 23:13:43 WIT; 2min 25s ago
  Process: 6294 ExecStartPost=/usr/libexec/mysql-check-upgrade (code=exited, status=0/SU
  Process: 6107 ExecStartPre=/usr/libexec/mysql-prepare-db-dir %n (code=exited, status=0
  Process: 6084 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCC
 Main PID: 6266 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 26 (limit: 4915)
   CGroup: /system.slice/mariadb.service
           └─6266 /usr/libexec/mysqld --basedir=/usr

Jan 16 23:13:42 fedora25.test.lan mysql-prepare-db-dir[6107]: Alternatively you can
Jan 16 23:13:42 fedora25.test.lan mysql-prepare-db-dir[6107]: '/usr/bin/mysql_secur
Jan 16 23:13:42 fedora25.test.lan mysql-prepare-db-dir[6107]: which will also give 
Jan 16 23:13:42 fedora25.test.lan mysql-prepare-db-dir[6107]: databases and anonymo
Jan 16 23:13:42 fedora25.test.lan mysql-prepare-db-dir[6107]: strongly recommended 
Jan 16 23:13:42 fedora25.test.lan mysql-prepare-db-dir[6107]: See the MariaDB Knowl
Jan 16 23:13:42 fedora25.test.lan mysql-prepare-db-dir[6107]: MySQL manual for more
Jan 16 23:13:42 fedora25.test.lan mysql-prepare-db-dir[6107]: Please report any pro
Jan 16 23:13:42 fedora25.test.lan mysqld[6266]: 2017-01-16 23:13:42 139958081599680
Jan 16 23:13:43 fedora25.test.lan systemd[1]: Started MariaDB 10.1 database server.
lines 1-22/22 (END)

Start Mariadb upon startup

systemctl enable mariadb

Secure MariaDB installation

mysql_secure_installation

At this point, our MariaDB server is ready for use. Next time I will write more about MySQL or MariaDB management and usage. Cheers..

Admin

Leave a Reply

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