How to Install MariaDB Database on CentOS 7

MariaDB is a popular open-source database and community-developed fork of MySQL. MariaDB database, It is widely used for database management in LAMP stack like servers.
This article describes, how to install MariaDB on CentOS 7.

Step 1. Package installation: Since MariaDB is available in CentOS 7 Base Repository, run the following command to install to install MariaDB packages:

[root@linuxcloudy ~]# yum install mariadb-server Loaded plugins: fastestmirror …………………….. Installed:   mariadb-server.x86_64 1:5.5.60-1.el7_5 Dependency Installed:   mariadb.x86_64 1:5.5.60-1.el7_5                         perl.x86_64 4:5.16.3-294.el7_6                         perl-Carp.noarch 0:1.26-244.el7   perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7            perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7            perl-DBD-MySQL.x86_64 0:4.023-6.el7   perl-DBI.x86_64 0:1.627-4.el7                           perl-Data-Dumper.x86_64 0:2.145-3.el7                  perl-Encode.x86_64 0:2.51-7.el7   perl-Exporter.noarch 0:5.68-3.el7                       perl-File-Path.noarch 0:2.09-2.el7                     perl-File-Temp.noarch 0:0.23.01-3.el7   perl-Filter.x86_64 0:1.49-3.el7                         perl-Getopt-Long.noarch 0:2.40-3.el7                   perl-HTTP-Tiny.noarch 0:0.033-3.el7   perl-IO-Compress.noarch 0:2.061-2.el7                   perl-Net-Daemon.noarch 0:0.48-5.el7                    perl-PathTools.x86_64 0:3.40-5.el7   perl-PlRPC.noarch 0:0.2020-14.el7                       perl-Pod-Escapes.noarch 1:1.04-294.el7_6               perl-Pod-Perldoc.noarch 0:3.20-4.el7   perl-Pod-Simple.noarch 1:3.28-4.el7                     perl-Pod-Usage.noarch 0:1.63-3.el7                     perl-Scalar-List-Utils.x86_64 0:1.27-248.el7   perl-Socket.x86_64 0:2.010-4.el7                        perl-Storable.x86_64 0:2.45-3.el7                      perl-Text-ParseWords.noarch 0:3.29-4.el7   perl-Time-HiRes.x86_64 4:1.9725-3.el7                   perl-Time-Local.noarch 0:1.2300-2.el7                  perl-constant.noarch 0:1.27-2.el7   perl-libs.x86_64 4:5.16.3-294.el7_6                     perl-macros.x86_64 4:5.16.3-294.el7_6                  perl-parent.noarch 1:0.225-244.el7   perl-podlators.noarch 0:2.5.1-3.el7                     perl-threads.x86_64 0:1.87-4.el7                       perl-threads-shared.x86_64 0:1.43-6.el7 Complete! [root@linuxcloudy ~]#

Step 2. Start MariaDB service: Run the following commands to start the server and enable on startup:

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

Step 3. Verify the installation: Check the service status and check MariaDB database by access its interactive interface:

[root@linuxcloudy ~]# systemctl status mariadb ● mariadb.service - MariaDB database server    Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)    Active: active (running) since Sat 2019-08-31 17:23:30 IST; 1min 22s ago  Main PID: 7640 (mysqld_safe)    CGroup: /system.slice/mariadb.service            ├─7640 /bin/sh /usr/bin/mysqld_safe --basedir=/usr            └─7802 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-fil... Aug 31 17:23:27 linuxcloudy mariadb-prepare-db-dir[7562]: strongly recommended for production servers. Aug 31 17:23:27 linuxcloudy mariadb-prepare-db-dir[7562]: See the MariaDB Knowledgebase at http://mariadb.com/kb or the Aug 31 17:23:27 linuxcloudy mariadb-prepare-db-dir[7562]: MySQL manual for more instructions. Aug 31 17:23:27 linuxcloudy mariadb-prepare-db-dir[7562]: Please report any problems at http://mariadb.org/jira Aug 31 17:23:27 linuxcloudy mariadb-prepare-db-dir[7562]: The latest information about MariaDB is available at http://mariadb.org/. Aug 31 17:23:27 linuxcloudy mariadb-prepare-db-dir[7562]: You can find additional information about the MySQL part at: Aug 31 17:23:27 linuxcloudy mariadb-prepare-db-dir[7562]: http://dev.mysql.com Aug 31 17:23:27 linuxcloudy mysqld_safe[7640]: 190831 17:23:27 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'. Aug 31 17:23:27 linuxcloudy mysqld_safe[7640]: 190831 17:23:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Aug 31 17:23:30 linuxcloudy systemd[1]: Started MariaDB database server. [root@linuxcloudy ~]#

Run the following command to enter in MariaDB interface:

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

Done!!! MariaDB Database is installed successfully. Use \q command to exit from the interface.