Getting MariaDB Up and Running

Estimated Reading Time: 4 minutes

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
Size
================================================================================
Installing:
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

Installed:
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

Complete!

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

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

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):
Aborting!

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
mysqldumpslow
[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)

MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

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

 

Clap