How To Install MySQL/MariaDB on Fedora 23

Posted on by dpepper
Reading Time: < 1 minute

MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easily integrated into most MySQL deployments. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), and OQGRAPH.

Pre-Flight Check

  • These instructions are intended for installing MariaDB on a single Fedora 23 node.
  • We’ll be working as root on a Liquid Web Self Managed Fedora 23 server.
  • If you have any questions about compatibility, you can find answers at: MariaDB versus MySQL – Compatibility.

Step #1: Install MariaDB

As always, we’ll first ensure that our existing packages are up to date:

dnf -y update

MariaDB can be installed with one command:

dnf -y install mysql-server mysql

Step #2: Start MySQL/MariaDB

Start MySQL (now MariaDB) with the following command:

systemctl start mariadb

To ensure that MySQL/MariaDB starts at boot, run the following command:

systemctl enable mariadb

That should produce output similar to the following:

[root@host ~]# systemctl enable mariadb
Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.

You can check the status of MySQL/MariaDB with:

systemctl status mariadb

Step #3: Using MySQL/MariaDB

You connect to MySQL/MariaDB with the following command:

mysql

That should produce output similar to the following:

[root@host ~]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 5
Server version: 10.0.21-MariaDB MariaDB Server
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

To exit and return to your command prompt, simply execute the following command:

exit

About the Author: dpepper

Have Some Questions?

Our Sales and Support teams are available 24 hours by phone or e-mail to assist.

1.800.580.4985
1.517.322.0434

Latest Articles

How to Use Material-UI in React

Read Article

Cloning an Existing Virtual Machine with VMware

Read Article

Five Steps to Create a Robots.txt File for Your Website

Read Article

Premium Business Email Pricing FAQ

Read Article

Microsoft Exchange Server Security Update

Read Article