Spread the love


RHEL 7 comes with MariaDB by default. Don’t get surprised if you don’t see MySQL server specific packages being displayed through YUM search utility. While most of your applications still uses MySQL in older generation of RHEL 6 or CentOS 6, migrating to newer RHEL 7 or CentOS 7 might require MariaDB configuration. This post will help you get started with MariaDB Up and Running.

Installing MariaDB:

[root@collabnix ~]# yum install mariadb mariadb-server
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* base: centos-hcm.viettelidc.com.vn
* epel: epel.mirror.net.in
* extras: centos-hn.viettelidc.com.vn
* updates: centos-hcm.viettelidc.com.vn
Package 1:mariadb-5.5.44-2.el7.centos.x86_64 already installed and latest version
Resolving Dependencies
–> Running transaction check
—> Package mariadb-server.x86_64 1:5.5.44-2.el7.centos will be installed
–> Processing Dependency: perl-DBI for package: 1:mariadb-server-5.5.44-2.el7.centos.x86_64
–> Processing Dependency: perl-DBD-MySQL for package: 1:mariadb-server-5.5.44-2.el7.centos.x86_64
–> Processing Dependency: perl(DBI) for package: 1:mariadb-server-5.5.44-2.el7.centos.x86_64
–> Running transaction check
—> Package perl-DBD-MySQL.x86_64 0:4.023-5.el7 will be installed
—> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed
–> Processing Dependency: perl(RPC::PlServer) >= 0.2001 for package: perl-DBI-1.627-4.el7.x86_64
–> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64
–> Running transaction check
—> Package perl-PlRPC.noarch 0:0.2020-14.el7 will be installed
–> Processing Dependency: perl(Net::Daemon) >= 0.13 for package: perl-PlRPC-0.2020-14.el7.noarch
–> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.el7.noarch
–> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.el7.noarch
–> Processing Dependency: perl(Compress::Zlib) for package: perl-PlRPC-0.2020-14.el7.noarch
–> Running transaction check
—> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed
–> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
–> Processing Dependency: perl(Compress::Raw::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
—> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed
–> Running transaction check
—> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed
—> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed
–> Finished Dependency Resolution

Dependencies Resolved

Package                    Arch      Version                     Repository
mariadb-server             x86_64    1:5.5.44-2.el7.centos       base     11 M
Installing for dependencies:
perl-Compress-Raw-Bzip2    x86_64    2.061-3.el7                 base     32 k
perl-Compress-Raw-Zlib     x86_64    1:2.061-4.el7               base     57 k
perl-DBD-MySQL             x86_64    4.023-5.el7                 base    140 k
perl-DBI                   x86_64    1.627-4.el7                 base    802 k
perl-IO-Compress           noarch    2.061-2.el7                 base    260 k
perl-Net-Daemon            noarch    0.48-5.el7                  base     51 k
perl-PlRPC                 noarch    0.2020-14.el7               base     36 k

Transaction Summary
Install  1 Package (+7 Dependent packages)

Total download size: 12 M
Installed size: 59 M
Is this ok [y/d/N]: y
Downloading packages:
(1/8): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm      |  32 kB   00:01
(2/8): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm       |  57 kB   00:00
(3/8): perl-DBD-MySQL-4.023-5.el7.x86_64.rpm               | 140 kB   00:00
(4/8): perl-DBI-1.627-4.el7.x86_64.rpm                     | 802 kB   00:01
(5/8): perl-IO-Compress-2.061-2.el7.noarch.rpm             | 260 kB   00:00
(6/8): perl-PlRPC-0.2020-14.el7.noarch.rpm                 |  36 kB   00:00
(7/8): perl-Net-Daemon-0.48-5.el7.noarch.rpm               |  51 kB   00:00
(8/8): mariadb-server-5.5.44-2.el7.centos.x86_64.rpm       |  11 MB   00:19
Total                                              627 kB/s |  12 MB  00:19
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                   1/8
Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                  2/8
Installing : perl-IO-Compress-2.061-2.el7.noarch                          3/8
Installing : perl-Net-Daemon-0.48-5.el7.noarch                            4/8
Installing : perl-PlRPC-0.2020-14.el7.noarch                              5/8
Installing : perl-DBI-1.627-4.el7.x86_64                                  6/8
Installing : perl-DBD-MySQL-4.023-5.el7.x86_64                            7/8
Installing : 1:mariadb-server-5.5.44-2.el7.centos.x86_64                  8/8
Verifying  : perl-Net-Daemon-0.48-5.el7.noarch                            1/8
Verifying  : 1:mariadb-server-5.5.44-2.el7.centos.x86_64                  2/8
Verifying  : perl-IO-Compress-2.061-2.el7.noarch                          3/8
Verifying  : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                  4/8
Verifying  : perl-PlRPC-0.2020-14.el7.noarch                              5/8
Verifying  : perl-DBI-1.627-4.el7.x86_64                                  6/8
Verifying  : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                   7/8
Verifying  : perl-DBD-MySQL-4.023-5.el7.x86_64                            8/8

mariadb-server.x86_64 1:5.5.44-2.el7.centos

Dependency Installed:
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-5.el7
perl-DBI.x86_64 0:1.627-4.el7
perl-IO-Compress.noarch 0:2.061-2.el7
perl-Net-Daemon.noarch 0:0.48-5.el7
perl-PlRPC.noarch 0:0.2020-14.el7


Enabling MariaDB services:

[root@collabnix ~]# systemctl start mariadb.service
[root@collabnix ~]# systemctl enable mariadb.service
Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.
[root@collabnix ~]# /usr/bin/mysql_secure_installation
/usr/bin/mysql_secure_installation: line 379: find_mysql_client: command not found


In order to log into MariaDB to secure it, we’ll need the current
password for the root user.  If you’ve just installed MariaDB, and
you haven’t set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
Enter current password for root (enter for none):

Cleaning up…
[root@collabnix ~]# /usr/bin/my
myisamchk                   mysql_find_rows
myisam_ftdump               mysql_fix_extensions
myisamlog                   mysqlhotcopy
myisampack                  mysqlimport
my_print_defaults           mysql_install_db
mysql                       mysql_plugin
mysqlaccess                 mysql_secure_installation
mysqladmin                  mysql_setpermission
mysqlbinlog                 mysqlshow
mysqlbug                    mysqlslap
mysqlcheck                  mysqltest
mysql_convert_table_format  mysql_tzinfo_to_sql
mysqld_multi                mysql_upgrade
mysqld_safe                 mysql_waitpid
mysqldump                   mysql_zap
[root@collabnix ~]# /usr/bin/mysqladmin -u root password ‘mysql123’
[root@collabnix ~]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 5.5.44-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.

MariaDB [(none)]>

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [(none)]> create database my_wiki;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> GRANT INDEX, CREATE, SELECT, INSERT, UPDATE, DELETE, ALTER, LOCK TABLES ON my_wiki.* TO ‘root’@’localhost’ IDENTIFIED BY ‘password’;
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> exit
[root@collabnix ~]#



Spread the love
Categories: Docker

Ajeet Raina

My name is Ajeet Singh Raina and I am an author of this blogging site. I am a Docker Captain, ARM Innovator & Docker Bangalore Community Leader. I bagged 2 special awards last year(2019): Firstly, “The Tip of Captain’s Hat Award” at Dockercon 2019, San Francisco, and secondly, “2019 Docker Community Award“. I run Collabnix Community Slack with over 5300+ audience . I have built popular GITHUB repositories like DockerLabs, KubeLabs, Kubetools, RedisPlanet Terraform etc. with the support of Collabnix Community. Currently working as Developer Relations Manager at Redis Labs where I help customers and community members adopt Redis. With over 12,000+ followers over LinkedIn & close to 5100+ twitter followers, I like sharing Docker and Kubernetes related content . You can follow me on Twitter(@ajeetsraina) & GitHub(@ajeetraina)


Leave a Reply

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

Join Collabnix SlackIt's 100% FREE!

Get chance to chat with 5500+ DevOps Engineers !