{"id":252,"date":"2019-05-30T22:40:40","date_gmt":"2019-05-30T22:40:40","guid":{"rendered":"https:\/\/howto.ciscoar.com\/?page_id=252"},"modified":"2020-02-23T00:37:15","modified_gmt":"2020-02-23T00:37:15","slug":"installing-mysql","status":"publish","type":"page","link":"https:\/\/lamp.ciscoar.com\/?page_id=252","title":{"rendered":"Installing MySQL"},"content":{"rendered":"\n\n\n<h2 class=\"wp-block-heading\">Installing MariaDB on CentOS 7<\/h2>\n\n\n\n<p>The installation of MariaDB is quite similar to the installation of MySQL you&#8217;ll find that the CLI commands are almost the same, just with a few small differences.<\/p>\n\n\n\n<p>You can install MariaDB using the root account or another user with &#8220;sudo&#8221; privileges<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"vim\" class=\"language-vim\">yum -y install mariadb-server mariadb<\/code><\/pre>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"504\" src=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/linux-centos7-MariaDB(MySQL)-installation.gif\" alt=\"\" class=\"wp-image-3427\"\/><figcaption>Installing MariaDB (MySQL) in CentOS 7<\/figcaption><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">MariaDB Installation Log<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"rest\" class=\"language-rest\">Loaded plugins: fastestmirror\nLoading mirror speeds from cached hostfile\n * base: mirror-centos-jpa.hostdime.com.br\n * extras: mirror-centos-jpa.hostdime.com.br\n * updates: mirror.ci.ifes.edu.br\nbase                                                     | 3.6 kB     00:00     \nextras                                                   | 2.9 kB     00:00     \nupdates                                                  | 2.9 kB     00:00     \nupdates\/7\/x86_64\/primary_db                                | 6.7 MB   00:16     \nResolving Dependencies\n--> Running transaction check\n---> Package mariadb.x86_64 1:5.5.64-1.el7 will be installed\n--> Processing Dependency: perl(Sys::Hostname) for package: 1:mariadb-5.5.64-1.el7.x86_64\n--> Processing Dependency: perl(IPC::Open3) for package: 1:mariadb-5.5.64-1.el7.x86_64\n--> Processing Dependency: perl(Getopt::Long) for package: 1:mariadb-5.5.64-1.el7.x86_64\n--> Processing Dependency: perl(File::Temp) for package: 1:mariadb-5.5.64-1.el7.x86_64\n--> Processing Dependency: perl(Fcntl) for package: 1:mariadb-5.5.64-1.el7.x86_64\n--> Processing Dependency: perl(Exporter) for package: 1:mariadb-5.5.64-1.el7.x86_64\n--> Processing Dependency: \/usr\/bin\/perl for package: 1:mariadb-5.5.64-1.el7.x86_64\n---> Package mariadb-server.x86_64 1:5.5.64-1.el7 will be installed\n--> Processing Dependency: perl-DBI for package: 1:mariadb-server-5.5.64-1.el7.x86_64\n--> Processing Dependency: perl-DBD-MySQL for package: 1:mariadb-server-5.5.64-1.el7.x86_64\n--> Processing Dependency: perl(File::Path) for package: 1:mariadb-server-5.5.64-1.el7.x86_64\n--> Processing Dependency: perl(Data::Dumper) for package: 1:mariadb-server-5.5.64-1.el7.x86_64\n--> Processing Dependency: perl(DBI) for package: 1:mariadb-server-5.5.64-1.el7.x86_64\n--> Running transaction check\n---> Package perl.x86_64 4:5.16.3-294.el7_6 will be installed\n--> Processing Dependency: perl-libs = 4:5.16.3-294.el7_6 for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl(Socket) >= 1.3 for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl(Scalar::Util) >= 1.10 for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl-macros for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl-libs for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl(threads::shared) for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl(threads) for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl(constant) for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl(Time::Local) for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl(Time::HiRes) for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl(Storable) for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl(Socket) for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl(Scalar::Util) for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl(Pod::Simple::XHTML) for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl(Pod::Simple::Search) for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl(Filter::Util::Call) for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl(File::Spec::Unix) for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl(File::Spec::Functions) for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl(File::Spec) for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl(Cwd) for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: perl(Carp) for package: 4:perl-5.16.3-294.el7_6.x86_64\n--> Processing Dependency: libperl.so()(64bit) for package: 4:perl-5.16.3-294.el7_6.x86_64\n---> Package perl-DBD-MySQL.x86_64 0:4.023-6.el7 will be installed\n---> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed\n--> Processing Dependency: perl(RPC::PlServer) >= 0.2001 for package: perl-DBI-1.627-4.el7.x86_64\n--> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64\n---> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed\n---> Package perl-Exporter.noarch 0:5.68-3.el7 will be installed\n---> Package perl-File-Path.noarch 0:2.09-2.el7 will be installed\n---> Package perl-File-Temp.noarch 0:0.23.01-3.el7 will be installed\n---> Package perl-Getopt-Long.noarch 0:2.40-3.el7 will be installed\n--> Processing Dependency: perl(Pod::Usage) >= 1.14 for package: perl-Getopt-Long-2.40-3.el7.noarch\n--> Processing Dependency: perl(Text::ParseWords) for package: perl-Getopt-Long-2.40-3.el7.noarch\n--> Running transaction check\n---> Package perl-Carp.noarch 0:1.26-244.el7 will be installed\n---> Package perl-Filter.x86_64 0:1.49-3.el7 will be installed\n---> Package perl-PathTools.x86_64 0:3.40-5.el7 will be installed\n---> Package perl-PlRPC.noarch 0:0.2020-14.el7 will be installed\n--> Processing Dependency: perl(Net::Daemon) >= 0.13 for package: perl-PlRPC-0.2020-14.el7.noarch\n--> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.el7.noarch\n--> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.el7.noarch\n--> Processing Dependency: perl(Compress::Zlib) for package: perl-PlRPC-0.2020-14.el7.noarch\n---> Package perl-Pod-Simple.noarch 1:3.28-4.el7 will be installed\n--> Processing Dependency: perl(Pod::Escapes) >= 1.04 for package: 1:perl-Pod-Simple-3.28-4.el7.noarch\n--> Processing Dependency: perl(Encode) for package: 1:perl-Pod-Simple-3.28-4.el7.noarch\n---> Package perl-Pod-Usage.noarch 0:1.63-3.el7 will be installed\n--> Processing Dependency: perl(Pod::Text) >= 3.15 for package: perl-Pod-Usage-1.63-3.el7.noarch\n--> Processing Dependency: perl-Pod-Perldoc for package: perl-Pod-Usage-1.63-3.el7.noarch\n---> Package perl-Scalar-List-Utils.x86_64 0:1.27-248.el7 will be installed\n---> Package perl-Socket.x86_64 0:2.010-4.el7 will be installed\n---> Package perl-Storable.x86_64 0:2.45-3.el7 will be installed\n---> Package perl-Text-ParseWords.noarch 0:3.29-4.el7 will be installed\n---> Package perl-Time-HiRes.x86_64 4:1.9725-3.el7 will be installed\n---> Package perl-Time-Local.noarch 0:1.2300-2.el7 will be installed\n---> Package perl-constant.noarch 0:1.27-2.el7 will be installed\n---> Package perl-libs.x86_64 4:5.16.3-294.el7_6 will be installed\n---> Package perl-macros.x86_64 4:5.16.3-294.el7_6 will be installed\n---> Package perl-threads.x86_64 0:1.87-4.el7 will be installed\n---> Package perl-threads-shared.x86_64 0:1.43-6.el7 will be installed\n--> Running transaction check\n---> Package perl-Encode.x86_64 0:2.51-7.el7 will be installed\n---> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed\n--> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch\n--> Processing Dependency: perl(Compress::Raw::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch\n---> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed\n---> Package perl-Pod-Escapes.noarch 1:1.04-294.el7_6 will be installed\n---> Package perl-Pod-Perldoc.noarch 0:3.20-4.el7 will be installed\n--> Processing Dependency: perl(parent) for package: perl-Pod-Perldoc-3.20-4.el7.noarch\n--> Processing Dependency: perl(HTTP::Tiny) for package: perl-Pod-Perldoc-3.20-4.el7.noarch\n---> Package perl-podlators.noarch 0:2.5.1-3.el7 will be installed\n--> Running transaction check\n---> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed\n---> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed\n---> Package perl-HTTP-Tiny.noarch 0:0.033-3.el7 will be installed\n---> Package perl-parent.noarch 1:0.225-244.el7 will be installed\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n================================================================================\n Package                     Arch       Version                  Repository\n                                                                           Size\n================================================================================\nInstalling:\n mariadb                     x86_64     1:5.5.64-1.el7           base     8.7 M\n mariadb-server              x86_64     1:5.5.64-1.el7           base      11 M\nInstalling for dependencies:\n perl                        x86_64     4:5.16.3-294.el7_6       base     8.0 M\n perl-Carp                   noarch     1.26-244.el7             base      19 k\n perl-Compress-Raw-Bzip2     x86_64     2.061-3.el7              base      32 k\n perl-Compress-Raw-Zlib      x86_64     1:2.061-4.el7            base      57 k\n perl-DBD-MySQL              x86_64     4.023-6.el7              base     140 k\n perl-DBI                    x86_64     1.627-4.el7              base     802 k\n perl-Data-Dumper            x86_64     2.145-3.el7              base      47 k\n perl-Encode                 x86_64     2.51-7.el7               base     1.5 M\n perl-Exporter               noarch     5.68-3.el7               base      28 k\n perl-File-Path              noarch     2.09-2.el7               base      26 k\n perl-File-Temp              noarch     0.23.01-3.el7            base      56 k\n perl-Filter                 x86_64     1.49-3.el7               base      76 k\n perl-Getopt-Long            noarch     2.40-3.el7               base      56 k\n perl-HTTP-Tiny              noarch     0.033-3.el7              base      38 k\n perl-IO-Compress            noarch     2.061-2.el7              base     260 k\n perl-Net-Daemon             noarch     0.48-5.el7               base      51 k\n perl-PathTools              x86_64     3.40-5.el7               base      82 k\n perl-PlRPC                  noarch     0.2020-14.el7            base      36 k\n perl-Pod-Escapes            noarch     1:1.04-294.el7_6         base      51 k\n perl-Pod-Perldoc            noarch     3.20-4.el7               base      87 k\n perl-Pod-Simple             noarch     1:3.28-4.el7             base     216 k\n perl-Pod-Usage              noarch     1.63-3.el7               base      27 k\n perl-Scalar-List-Utils      x86_64     1.27-248.el7             base      36 k\n perl-Socket                 x86_64     2.010-4.el7              base      49 k\n perl-Storable               x86_64     2.45-3.el7               base      77 k\n perl-Text-ParseWords        noarch     3.29-4.el7               base      14 k\n perl-Time-HiRes             x86_64     4:1.9725-3.el7           base      45 k\n perl-Time-Local             noarch     1.2300-2.el7             base      24 k\n perl-constant               noarch     1.27-2.el7               base      19 k\n perl-libs                   x86_64     4:5.16.3-294.el7_6       base     688 k\n perl-macros                 x86_64     4:5.16.3-294.el7_6       base      44 k\n perl-parent                 noarch     1:0.225-244.el7          base      12 k\n perl-podlators              noarch     2.5.1-3.el7              base     112 k\n perl-threads                x86_64     1.87-4.el7               base      49 k\n perl-threads-shared         x86_64     1.43-6.el7               base      39 k\n\nTransaction Summary\n================================================================================\nInstall  2 Packages (+35 Dependent packages)\n\nTotal download size: 33 M\nInstalled size: 147 M\nDownloading packages:\n(1\/37): mariadb-5.5.64-1.el7.x86_64.rpm                    | 8.7 MB   00:17     \n(2\/37): mariadb-server-5.5.64-1.el7.x86_64.rpm             |  11 MB   00:19     \n(3\/37): perl-Carp-1.26-244.el7.noarch.rpm                  |  19 kB   00:00     \n(4\/37): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm     |  32 kB   00:00     \n(5\/37): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm      |  57 kB   00:00     \n(6\/37): perl-DBD-MySQL-4.023-6.el7.x86_64.rpm              | 140 kB   00:00     \n(7\/37): perl-5.16.3-294.el7_6.x86_64.rpm                   | 8.0 MB   00:02     \n(8\/37): perl-DBI-1.627-4.el7.x86_64.rpm                    | 802 kB   00:00     \n(9\/37): perl-Data-Dumper-2.145-3.el7.x86_64.rpm            |  47 kB   00:00     \n(10\/37): perl-Exporter-5.68-3.el7.noarch.rpm               |  28 kB   00:00     \n(11\/37): perl-File-Path-2.09-2.el7.noarch.rpm              |  26 kB   00:00     \n(12\/37): perl-File-Temp-0.23.01-3.el7.noarch.rpm           |  56 kB   00:00     \n(13\/37): perl-Filter-1.49-3.el7.x86_64.rpm                 |  76 kB   00:00     \n(14\/37): perl-Getopt-Long-2.40-3.el7.noarch.rpm            |  56 kB   00:00     \n(15\/37): perl-Encode-2.51-7.el7.x86_64.rpm                 | 1.5 MB   00:00     \n(16\/37): perl-HTTP-Tiny-0.033-3.el7.noarch.rpm             |  38 kB   00:00     \n(17\/37): perl-IO-Compress-2.061-2.el7.noarch.rpm           | 260 kB   00:00     \n(18\/37): perl-Net-Daemon-0.48-5.el7.noarch.rpm             |  51 kB   00:00     \n(19\/37): perl-PlRPC-0.2020-14.el7.noarch.rpm               |  36 kB   00:00     \n(20\/37): perl-PathTools-3.40-5.el7.x86_64.rpm              |  82 kB   00:00     \n(21\/37): perl-Pod-Escapes-1.04-294.el7_6.noarch.rpm        |  51 kB   00:00     \n(22\/37): perl-Pod-Perldoc-3.20-4.el7.noarch.rpm            |  87 kB   00:00     \n(23\/37): perl-Pod-Usage-1.63-3.el7.noarch.rpm              |  27 kB   00:00     \n(24\/37): perl-Pod-Simple-3.28-4.el7.noarch.rpm             | 216 kB   00:00     \n(25\/37): perl-Scalar-List-Utils-1.27-248.el7.x86_64.rpm    |  36 kB   00:00     \n(26\/37): perl-Socket-2.010-4.el7.x86_64.rpm                |  49 kB   00:00     \n(27\/37): perl-Storable-2.45-3.el7.x86_64.rpm               |  77 kB   00:00     \n(28\/37): perl-Text-ParseWords-3.29-4.el7.noarch.rpm        |  14 kB   00:00     \n(29\/37): perl-Time-HiRes-1.9725-3.el7.x86_64.rpm           |  45 kB   00:00     \n(30\/37): perl-Time-Local-1.2300-2.el7.noarch.rpm           |  24 kB   00:00     \n(31\/37): perl-constant-1.27-2.el7.noarch.rpm               |  19 kB   00:00     \n(32\/37): perl-macros-5.16.3-294.el7_6.x86_64.rpm           |  44 kB   00:00     \n(33\/37): perl-libs-5.16.3-294.el7_6.x86_64.rpm             | 688 kB   00:00     \n(34\/37): perl-parent-0.225-244.el7.noarch.rpm              |  12 kB   00:00     \n(35\/37): perl-podlators-2.5.1-3.el7.noarch.rpm             | 112 kB   00:00     \n(36\/37): perl-threads-1.87-4.el7.x86_64.rpm                |  49 kB   00:00     \n(37\/37): perl-threads-shared-1.43-6.el7.x86_64.rpm         |  39 kB   00:00     \n--------------------------------------------------------------------------------\nTotal                                              1.6 MB\/s |  33 MB  00:20     \nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n  Installing : 1:perl-parent-0.225-244.el7.noarch                          1\/37 \n  Installing : perl-HTTP-Tiny-0.033-3.el7.noarch                           2\/37 \n  Installing : perl-podlators-2.5.1-3.el7.noarch                           3\/37 \n  Installing : perl-Pod-Perldoc-3.20-4.el7.noarch                          4\/37 \n  Installing : 1:perl-Pod-Escapes-1.04-294.el7_6.noarch                    5\/37 \n  Installing : perl-Encode-2.51-7.el7.x86_64                               6\/37 \n  Installing : perl-Text-ParseWords-3.29-4.el7.noarch                      7\/37 \n  Installing : perl-Pod-Usage-1.63-3.el7.noarch                            8\/37 \n  Installing : 4:perl-libs-5.16.3-294.el7_6.x86_64                         9\/37 \n  Installing : 4:perl-macros-5.16.3-294.el7_6.x86_64                      10\/37 \n  Installing : perl-Storable-2.45-3.el7.x86_64                            11\/37 \n  Installing : perl-Exporter-5.68-3.el7.noarch                            12\/37 \n  Installing : perl-constant-1.27-2.el7.noarch                            13\/37 \n  Installing : perl-Time-Local-1.2300-2.el7.noarch                        14\/37 \n  Installing : perl-Socket-2.010-4.el7.x86_64                             15\/37 \n  Installing : perl-Carp-1.26-244.el7.noarch                              16\/37 \n  Installing : 4:perl-Time-HiRes-1.9725-3.el7.x86_64                      17\/37 \n  Installing : perl-PathTools-3.40-5.el7.x86_64                           18\/37 \n  Installing : perl-Scalar-List-Utils-1.27-248.el7.x86_64                 19\/37 \n  Installing : 1:perl-Pod-Simple-3.28-4.el7.noarch                        20\/37 \n  Installing : perl-File-Temp-0.23.01-3.el7.noarch                        21\/37 \n  Installing : perl-File-Path-2.09-2.el7.noarch                           22\/37 \n  Installing : perl-threads-shared-1.43-6.el7.x86_64                      23\/37 \n  Installing : perl-threads-1.87-4.el7.x86_64                             24\/37 \n  Installing : perl-Filter-1.49-3.el7.x86_64                              25\/37 \n  Installing : perl-Getopt-Long-2.40-3.el7.noarch                         26\/37 \n  Installing : 4:perl-5.16.3-294.el7_6.x86_64                             27\/37 \n  Installing : perl-Data-Dumper-2.145-3.el7.x86_64                        28\/37 \n  Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                 29\/37 \n  Installing : perl-Net-Daemon-0.48-5.el7.noarch                          30\/37 \n  Installing : 1:mariadb-5.5.64-1.el7.x86_64                              31\/37 \n  Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                32\/37 \n  Installing : perl-IO-Compress-2.061-2.el7.noarch                        33\/37 \n  Installing : perl-PlRPC-0.2020-14.el7.noarch                            34\/37 \n  Installing : perl-DBI-1.627-4.el7.x86_64                                35\/37 \n  Installing : perl-DBD-MySQL-4.023-6.el7.x86_64                          36\/37 \n  Installing : 1:mariadb-server-5.5.64-1.el7.x86_64                       37\/37 \n  Verifying  : perl-HTTP-Tiny-0.033-3.el7.noarch                           1\/37 \n  Verifying  : perl-threads-shared-1.43-6.el7.x86_64                       2\/37 \n  Verifying  : perl-Storable-2.45-3.el7.x86_64                             3\/37 \n  Verifying  : 1:perl-Pod-Escapes-1.04-294.el7_6.noarch                    4\/37 \n  Verifying  : perl-DBD-MySQL-4.023-6.el7.x86_64                           5\/37 \n  Verifying  : perl-Exporter-5.68-3.el7.noarch                             6\/37 \n  Verifying  : perl-constant-1.27-2.el7.noarch                             7\/37 \n  Verifying  : perl-PathTools-3.40-5.el7.x86_64                            8\/37 \n  Verifying  : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                  9\/37 \n  Verifying  : 1:perl-parent-0.225-244.el7.noarch                         10\/37 \n  Verifying  : perl-Net-Daemon-0.48-5.el7.noarch                          11\/37 \n  Verifying  : 1:mariadb-5.5.64-1.el7.x86_64                              12\/37 \n  Verifying  : 4:perl-libs-5.16.3-294.el7_6.x86_64                        13\/37 \n  Verifying  : perl-File-Temp-0.23.01-3.el7.noarch                        14\/37 \n  Verifying  : 1:perl-Pod-Simple-3.28-4.el7.noarch                        15\/37 \n  Verifying  : perl-Time-Local-1.2300-2.el7.noarch                        16\/37 \n  Verifying  : perl-DBI-1.627-4.el7.x86_64                                17\/37 \n  Verifying  : 4:perl-macros-5.16.3-294.el7_6.x86_64                      18\/37 \n  Verifying  : perl-Socket-2.010-4.el7.x86_64                             19\/37 \n  Verifying  : perl-Carp-1.26-244.el7.noarch                              20\/37 \n  Verifying  : perl-Data-Dumper-2.145-3.el7.x86_64                        21\/37 \n  Verifying  : 4:perl-Time-HiRes-1.9725-3.el7.x86_64                      22\/37 \n  Verifying  : perl-Scalar-List-Utils-1.27-248.el7.x86_64                 23\/37 \n  Verifying  : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                24\/37 \n  Verifying  : perl-IO-Compress-2.061-2.el7.noarch                        25\/37 \n  Verifying  : perl-Pod-Usage-1.63-3.el7.noarch                           26\/37 \n  Verifying  : perl-PlRPC-0.2020-14.el7.noarch                            27\/37 \n  Verifying  : perl-Encode-2.51-7.el7.x86_64                              28\/37 \n  Verifying  : perl-Pod-Perldoc-3.20-4.el7.noarch                         29\/37 \n  Verifying  : perl-podlators-2.5.1-3.el7.noarch                          30\/37 \n  Verifying  : perl-File-Path-2.09-2.el7.noarch                           31\/37 \n  Verifying  : perl-threads-1.87-4.el7.x86_64                             32\/37 \n  Verifying  : perl-Filter-1.49-3.el7.x86_64                              33\/37 \n  Verifying  : perl-Getopt-Long-2.40-3.el7.noarch                         34\/37 \n  Verifying  : perl-Text-ParseWords-3.29-4.el7.noarch                     35\/37 \n  Verifying  : 4:perl-5.16.3-294.el7_6.x86_64                             36\/37 \n  Verifying  : 1:mariadb-server-5.5.64-1.el7.x86_64                       37\/37 \n\nInstalled:\n  mariadb.x86_64 1:5.5.64-1.el7       mariadb-server.x86_64 1:5.5.64-1.el7      \n\nDependency Installed:\n  perl.x86_64 4:5.16.3-294.el7_6                                                \n  perl-Carp.noarch 0:1.26-244.el7                                               \n  perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7                                  \n  perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7                                   \n  perl-DBD-MySQL.x86_64 0:4.023-6.el7                                           \n  perl-DBI.x86_64 0:1.627-4.el7                                                 \n  perl-Data-Dumper.x86_64 0:2.145-3.el7                                         \n  perl-Encode.x86_64 0:2.51-7.el7                                               \n  perl-Exporter.noarch 0:5.68-3.el7                                             \n  perl-File-Path.noarch 0:2.09-2.el7                                            \n  perl-File-Temp.noarch 0:0.23.01-3.el7                                         \n  perl-Filter.x86_64 0:1.49-3.el7                                               \n  perl-Getopt-Long.noarch 0:2.40-3.el7                                          \n  perl-HTTP-Tiny.noarch 0:0.033-3.el7                                           \n  perl-IO-Compress.noarch 0:2.061-2.el7                                         \n  perl-Net-Daemon.noarch 0:0.48-5.el7                                           \n  perl-PathTools.x86_64 0:3.40-5.el7                                            \n  perl-PlRPC.noarch 0:0.2020-14.el7                                             \n  perl-Pod-Escapes.noarch 1:1.04-294.el7_6                                      \n  perl-Pod-Perldoc.noarch 0:3.20-4.el7                                          \n  perl-Pod-Simple.noarch 1:3.28-4.el7                                           \n  perl-Pod-Usage.noarch 0:1.63-3.el7                                            \n  perl-Scalar-List-Utils.x86_64 0:1.27-248.el7                                  \n  perl-Socket.x86_64 0:2.010-4.el7                                              \n  perl-Storable.x86_64 0:2.45-3.el7                                             \n  perl-Text-ParseWords.noarch 0:3.29-4.el7                                      \n  perl-Time-HiRes.x86_64 4:1.9725-3.el7                                         \n  perl-Time-Local.noarch 0:1.2300-2.el7                                         \n  perl-constant.noarch 0:1.27-2.el7                                             \n  perl-libs.x86_64 4:5.16.3-294.el7_6                                           \n  perl-macros.x86_64 4:5.16.3-294.el7_6                                         \n  perl-parent.noarch 1:0.225-244.el7                                            \n  perl-podlators.noarch 0:2.5.1-3.el7                                           \n  perl-threads.x86_64 0:1.87-4.el7                                              \n  perl-threads-shared.x86_64 0:1.43-6.el7                                       \n\nComplete!\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Verifying installed packages<\/h2>\n\n\n\n<p>If you like to see a list of the installed packages which names begins with &#8220;mariadb&#8221; you can execute the following CLI command.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"vim\" class=\"language-vim\">yum list installed | grep ^mariadb<\/code><\/pre>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-05-list.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-05-list.jpg\" alt=\"\" class=\"wp-image-3593\" width=\"844\" height=\"297\" srcset=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-05-list.jpg 844w, https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-05-list-300x106.jpg 300w, https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-05-list-768x270.jpg 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><figcaption>MariaDB packages<\/figcaption><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Start MariaDB service<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"vim\" class=\"language-vim\">systemctl start mariadb<\/code><\/pre>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-01-start.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"452\" height=\"224\" src=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-01-start.jpg\" alt=\"\" class=\"wp-image-3448\" srcset=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-01-start.jpg 452w, https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-01-start-300x149.jpg 300w\" sizes=\"auto, (max-width: 452px) 100vw, 452px\" \/><\/a><figcaption>Start MariaDB<\/figcaption><\/figure><\/div>\n\n\n\n<p>As you can see in the preceding screenshot, the system doesn&#8217;t give you any feedback about the start of MariaDB, this is something quite common in Linux, in fact there is a very well know saying that goes &#8220;no news is good news&#8221;, anyway if you are like me, you always prefer to double check everything, and for that you can use the next CLI command.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Check MariaDB current status<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"vim\" class=\"language-vim\">systemctl status mariadb<\/code><\/pre>\n\n\n\n<p>If the installation went well you will get the following information when checking the current status.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-02-status.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-02-status.jpg\" alt=\"\" class=\"wp-image-3452\" width=\"687\" height=\"391\" srcset=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-02-status.jpg 916w, https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-02-status-300x171.jpg 300w, https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-02-status-768x437.jpg 768w\" sizes=\"auto, (max-width: 687px) 100vw, 687px\" \/><\/a><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Where it&#8217;s logging to?<\/h2>\n\n\n\n<p>One important thing to notice and why not to take note is where MariaDB is logging, in this case to the following folder:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"rest\" class=\"language-rest\">Logging to '\/var\/log\/mariadb\/mariadb.log'<\/code><\/pre>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-06-where-its-logging-to.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-06-where-its-logging-to-1024x409.jpg\" alt=\"\" class=\"wp-image-3600\" width=\"1024\" height=\"409\" srcset=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-06-where-its-logging-to-1024x409.jpg 1024w, https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-06-where-its-logging-to-300x120.jpg 300w, https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-06-where-its-logging-to-768x307.jpg 768w, https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-06-where-its-logging-to.jpg 1173w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><figcaption>MariaDB Logging file<\/figcaption><\/figure><\/div>\n\n\n\n<p>The first place to go when something is not working as it should with MariDB is the log file &#8220;mariadb.log&#8221;, fortunately the file&#8217;s name is self-explanatory and that is very helpful when troubleshooting MariaDB issues.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Configure MariaDB to start at boot<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"vim\" class=\"language-vim\">systemctl enable mariadb.service<\/code><\/pre>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-03-enable-at-boot.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-03-enable-at-boot.jpg\" alt=\"\" class=\"wp-image-3455\" width=\"687\" height=\"189\" srcset=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-03-enable-at-boot.jpg 916w, https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-03-enable-at-boot-300x83.jpg 300w, https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-03-enable-at-boot-768x211.jpg 768w\" sizes=\"auto, (max-width: 687px) 100vw, 687px\" \/><\/a><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Checking MariaDB installed version<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"vim\" class=\"language-vim\">mysql --version<\/code><\/pre>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-04-version.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"741\" height=\"230\" src=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-04-version.jpg\" alt=\"\" class=\"wp-image-3460\" srcset=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-04-version.jpg 741w, https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/mysql-mariadb-installation-04-version-300x93.jpg 300w\" sizes=\"auto, (max-width: 706px) 89vw, (max-width: 767px) 82vw, 740px\" \/><\/a><figcaption>Checking MariaDB version<\/figcaption><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Remote access and firewalld<\/h2>\n\n\n\n<p>If you are planning to access MariaDB remotely then you&#8217;ll have to add &#8220;mysql&#8221; into &#8220;firewalld&#8221; as an exception, you can use the following CLI commands to permanently add MariaDB service into the firewall.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; highlight: [1,16,18,20]; title: ; notranslate\" title=\"\">\n&#x5B;root@centos7 ~]# firewall-cmd --zone=public --list-all\npublic (active)\n  target: default\n  icmp-block-inversion: no\n  interfaces: enp0s3\n  sources: \n  services: dhcpv6-client http ssh\n  ports: \n  protocols: \n  masquerade: no\n  forward-ports: \n  source-ports: \n  icmp-blocks: \n  rich rules: \n\n&#x5B;root@centos7 ~]# firewall-cmd --zone=public --permanent --add-service=mysql\nsuccess\n&#x5B;root@centos7 ~]# firewall-cmd --reload\nsuccess\n&#x5B;root@centos7 ~]# firewall-cmd --zone=public --list-all\npublic (active)\n  target: default\n  icmp-block-inversion: no\n  interfaces: enp0s3\n  sources: \n  services: dhcpv6-client http mysql ssh\n  ports: \n  protocols: \n  masquerade: no\n  forward-ports: \n  source-ports: \n  icmp-blocks: \n  rich rules: \n\n\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">Firewalld list of services<\/h2>\n\n\n\n<p>In case you want to see a complete list of the available services that can be added into the firewall you can execute the following CLI command.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"vim\" class=\"language-vim\">firewall-cmd --get-services | grep mysql<\/code><\/pre>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/centos7-firewalld-services-list-all.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/centos7-firewalld-services-list-all-1024x354.jpg\" alt=\"\" class=\"wp-image-3609\" width=\"768\" height=\"266\" srcset=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/centos7-firewalld-services-list-all-1024x354.jpg 1024w, https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/centos7-firewalld-services-list-all-300x104.jpg 300w, https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/centos7-firewalld-services-list-all-768x266.jpg 768w, https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/centos7-firewalld-services-list-all.jpg 1173w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><figcaption>Firewall services list<\/figcaption><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL protocol TCP, port 3306<\/h2>\n\n\n\n<p>Let&#8217;s use WinSCP to open the XML file that contains all the information related to MySQL service.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"504\" src=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/firewall-services-list-mysql-tcp-port-3306.gif\" alt=\"\" class=\"wp-image-3628\"\/><\/figure><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"rest\" class=\"language-rest\">\/usr\/lib\/firewalld\/services<\/code><\/pre>\n\n\n\n<p>It is a good idea to bookmark this folder on WinSCP, if don&#8217;t know how to do that you can take a look at <a href=\"\/winscp-bookmarks\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"this article (opens in a new tab)\">this article<\/a>.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/centos7-firewalld-services-list-mysql-TCP-port-3306.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/centos7-firewalld-services-list-mysql-TCP-port-3306.jpg\" alt=\"\" class=\"wp-image-3611\" width=\"671\" height=\"338\" srcset=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/centos7-firewalld-services-list-mysql-TCP-port-3306.jpg 671w, https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/02\/centos7-firewalld-services-list-mysql-TCP-port-3306-300x151.jpg 300w\" sizes=\"auto, (max-width: 671px) 100vw, 671px\" \/><\/a><figcaption>MySQL service &#8211; Protocol TCP &#8211; port 3306<\/figcaption><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Where to go next?<\/h2>\n\n\n\n<p>We\u2019ve successfully installed MariaDB, added it to the firewall, and we also verified MariaDB (mysql) protocol(TCP) and port(3306), the next step is to secure MariaDB a process that will allow us to not only secure the installation but also to set the \u201croot\u201d account password, you can take a look at the following article.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"\/mysql-mariadb-secure-installation\/\">Secure MariaDB installation and setting &#8220;root&#8221; password<\/a><\/li><\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Installing MariaDB on CentOS 7 The installation of MariaDB is quite similar to the installation of MySQL you&#8217;ll find that the CLI commands are almost the same, just with a few small differences. You can install MariaDB using the root account or another user with &#8220;sudo&#8221; privileges MariaDB Installation Log Verifying installed packages If you &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/lamp.ciscoar.com\/?page_id=252\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Installing MySQL&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-252","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/pages\/252","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=252"}],"version-history":[{"count":66,"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/pages\/252\/revisions"}],"predecessor-version":[{"id":3629,"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/pages\/252\/revisions\/3629"}],"wp:attachment":[{"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}