Minggu, 29 September 2019

How to install MySql MariaDb server on linux centos 8

  Tidak ada komentar
Install mariadb with dnf module install command
[[email protected] ~]# sudo dnf module install mariadb
LiteSpeed Tech Repository for CentOS 8 - x86_64                                                       747  B/s | 1.1 kB     00:01
LiteSpeed Tech Repository for CentOS 8 - x86_64                                                       768  B/s | 1.1 kB     00:01
Failed to synchronize cache for repo 'litespeed', ignoring this repo.
Failed to synchronize cache for repo 'litespeed-update', ignoring this repo.
Last metadata expiration check: 1:18:02 ago on Fri 27 Sep 2019 02:16:23 PM WIB.
Dependencies resolved.
======================================================================================================================================
 Package                               Arch              Version                                           Repository            Size
======================================================================================================================================
Installing group/module packages:
 mariadb-server                        x86_64            3:10.3.11-2.module_el8.0.0+35+6f2527ed            AppStream             16 M
Installing dependencies:
 mariadb                               x86_64            3:10.3.11-2.module_el8.0.0+35+6f2527ed            AppStream            6.2 M
 mariadb-common                        x86_64            3:10.3.11-2.module_el8.0.0+35+6f2527ed            AppStream             62 k
 mariadb-connector-c                   x86_64            3.0.7-1.el8                                       AppStream            148 k
 mariadb-connector-c-config            noarch            3.0.7-1.el8                                       AppStream             13 k
 mariadb-errmsg                        x86_64            3:10.3.11-2.module_el8.0.0+35+6f2527ed            AppStream            232 k
 perl-DBD-MySQL                        x86_64            4.046-2.module_el8.0.0+72+668237d8                AppStream            156 k
 perl-DBI                              x86_64            1.641-2.module_el8.0.0+66+fe1eca09                AppStream            740 k
 perl-Digest                           noarch            1.17-395.el8                                      AppStream             27 k
 perl-Digest-MD5                       x86_64            2.55-396.el8                                      AppStream             37 k
 perl-Net-SSLeay                       x86_64            1.85-6.el8                                        AppStream            358 k
 perl-URI                              noarch            1.73-3.el8                                        AppStream            116 k
 perl-libnet                           noarch            3.11-3.el8                                        AppStream            121 k
 perl-Carp                             noarch            1.42-396.el8                                      BaseOS                30 k
 perl-Data-Dumper                      x86_64            2.167-399.el8                                     BaseOS                58 k
 perl-Encode                           x86_64            4:2.97-3.el8                                      BaseOS               1.5 M
 perl-Errno                            x86_64            1.28-416.el8                                      BaseOS                76 k
 perl-Exporter                         noarch            5.72-396.el8                                      BaseOS                34 k
 perl-File-Path                        noarch            2.15-2.el8                                        BaseOS                38 k
 perl-File-Temp                        noarch            0.230.600-1.el8                                   BaseOS                63 k
 perl-Getopt-Long                      noarch            1:2.50-4.el8                                      BaseOS                63 k
 perl-HTTP-Tiny                        noarch            0.074-1.el8                                       BaseOS                58 k
 perl-IO                               x86_64            1.38-416.el8                                      BaseOS               141 k
 perl-MIME-Base64                      x86_64            3.15-396.el8                                      BaseOS                31 k
 perl-Math-BigInt                      noarch            1:1.9998.11-5.el8                                 BaseOS               195 k
 perl-Math-Complex                     noarch            1.59-416.el8                                      BaseOS               108 k
 perl-PathTools                        x86_64            3.74-1.el8                                        BaseOS                90 k
 perl-Pod-Escapes                      noarch            1:1.07-395.el8                                    BaseOS                20 k
 perl-Pod-Perldoc                      noarch            3.28-396.el8                                      BaseOS                86 k
 perl-Pod-Simple                       noarch            1:3.35-395.el8                                    BaseOS               213 k
 perl-Pod-Usage                        noarch            4:1.69-395.el8                                    BaseOS                34 k
 perl-Scalar-List-Utils                x86_64            3:1.49-2.el8                                      BaseOS                68 k
 perl-Socket                           x86_64            4:2.027-2.el8                                     BaseOS                59 k
 perl-Storable                         x86_64            1:3.11-3.el8                                      BaseOS                98 k
 perl-Term-ANSIColor                   noarch            4.06-396.el8                                      BaseOS                46 k
 perl-Term-Cap                         noarch            1.17-395.el8                                      BaseOS                23 k
 perl-Text-ParseWords                  noarch            3.30-395.el8                                      BaseOS                18 k
 perl-Text-Tabs+Wrap                   noarch            2013.0523-395.el8                                 BaseOS                24 k
 perl-Time-Local                       noarch            1:1.280-1.el8                                     BaseOS                34 k
 perl-Unicode-Normalize                x86_64            1.25-396.el8                                      BaseOS                82 k
 perl-constant                         noarch            1.33-396.el8                                      BaseOS                25 k
 perl-interpreter                      x86_64            4:5.26.3-416.el8                                  BaseOS               6.3 M
 perl-libs                             x86_64            4:5.26.3-416.el8                                  BaseOS               1.6 M
 perl-macros                           x86_64            4:5.26.3-416.el8                                  BaseOS                72 k
 perl-parent                           noarch            1:0.237-1.el8                                     BaseOS                20 k
 perl-podlators                        noarch            4.11-1.el8                                        BaseOS               118 k
 perl-threads                          x86_64            1:2.21-2.el8                                      BaseOS                61 k
 perl-threads-shared                   x86_64            1.58-2.el8                                        BaseOS                48 k
 psmisc                                x86_64            23.1-3.el8                                        BaseOS               151 k
Installing weak dependencies:
 mariadb-backup                        x86_64            3:10.3.11-2.module_el8.0.0+35+6f2527ed            AppStream            6.2 M
 mariadb-gssapi-server                 x86_64            3:10.3.11-2.module_el8.0.0+35+6f2527ed            AppStream             49 k
 mariadb-server-utils                  x86_64            3:10.3.11-2.module_el8.0.0+35+6f2527ed            AppStream            1.6 M
 perl-IO-Socket-IP                     noarch            0.39-5.el8                                        AppStream             47 k
 perl-IO-Socket-SSL                    noarch            2.060-2.el8                                       AppStream            289 k
 perl-Mozilla-CA                       noarch            20160104-7.el8                                    AppStream             15 k
Installing module profiles:
 mariadb/server
Enabling module streams:
 mariadb                                                 10.3
 perl-DBD-MySQL                                          4.046
 perl-DBI                                                1.641

Transaction Summary
======================================================================================================================================
Install  55 Packages

Total download size: 44 M
Installed size: 201 M
Is this ok [y/N]: ^COperation aborted.
[[email protected] ~]# sudo dnf module install mariadb galera
LiteSpeed Tech Repository for CentOS 8 - x86_64                                                       201  B/s | 1.1 kB     00:05
LiteSpeed Tech Repository for CentOS 8 - x86_64                                                       107  B/s | 1.1 kB     00:10
Failed to synchronize cache for repo 'litespeed', ignoring this repo.
Failed to synchronize cache for repo 'litespeed-update', ignoring this repo.
Last metadata expiration check: 1:19:34 ago on Fri 27 Sep 2019 02:16:23 PM WIB.
Error: Problems in request:
missing groups or modules: galera
[[email protected] ~]# sudo dnf module install mariadb
LiteSpeed Tech Repository for CentOS 8 - x86_64                                                       755  B/s | 1.1 kB     00:01
LiteSpeed Tech Repository for CentOS 8 - x86_64                                                       740  B/s | 1.1 kB     00:01
Failed to synchronize cache for repo 'litespeed', ignoring this repo.
Failed to synchronize cache for repo 'litespeed-update', ignoring this repo.
Last metadata expiration check: 1:20:28 ago on Fri 27 Sep 2019 02:16:23 PM WIB.
Dependencies resolved.
======================================================================================================================================
 Package                               Arch              Version                                           Repository            Size
======================================================================================================================================
Installing group/module packages:
 mariadb-server                        x86_64            3:10.3.11-2.module_el8.0.0+35+6f2527ed            AppStream             16 M
Installing dependencies:
 mariadb                               x86_64            3:10.3.11-2.module_el8.0.0+35+6f2527ed            AppStream            6.2 M
 mariadb-common                        x86_64            3:10.3.11-2.module_el8.0.0+35+6f2527ed            AppStream             62 k
 mariadb-connector-c                   x86_64            3.0.7-1.el8                                       AppStream            148 k
 mariadb-connector-c-config            noarch            3.0.7-1.el8                                       AppStream             13 k
 mariadb-errmsg                        x86_64            3:10.3.11-2.module_el8.0.0+35+6f2527ed            AppStream            232 k
 perl-DBD-MySQL                        x86_64            4.046-2.module_el8.0.0+72+668237d8                AppStream            156 k
 perl-DBI                              x86_64            1.641-2.module_el8.0.0+66+fe1eca09                AppStream            740 k
 perl-Digest                           noarch            1.17-395.el8                                      AppStream             27 k
 perl-Digest-MD5                       x86_64            2.55-396.el8                                      AppStream             37 k
 perl-Net-SSLeay                       x86_64            1.85-6.el8                                        AppStream            358 k
 perl-URI                              noarch            1.73-3.el8                                        AppStream            116 k
 perl-libnet                           noarch            3.11-3.el8                                        AppStream            121 k
 perl-Carp                             noarch            1.42-396.el8                                      BaseOS                30 k
 perl-Data-Dumper                      x86_64            2.167-399.el8                                     BaseOS                58 k
 perl-Encode                           x86_64            4:2.97-3.el8                                      BaseOS               1.5 M
 perl-Errno                            x86_64            1.28-416.el8                                      BaseOS                76 k
 perl-Exporter                         noarch            5.72-396.el8                                      BaseOS                34 k
 perl-File-Path                        noarch            2.15-2.el8                                        BaseOS                38 k
 perl-File-Temp                        noarch            0.230.600-1.el8                                   BaseOS                63 k
 perl-Getopt-Long                      noarch            1:2.50-4.el8                                      BaseOS                63 k
 perl-HTTP-Tiny                        noarch            0.074-1.el8                                       BaseOS                58 k
 perl-IO                               x86_64            1.38-416.el8                                      BaseOS               141 k
 perl-MIME-Base64                      x86_64            3.15-396.el8                                      BaseOS                31 k
 perl-Math-BigInt                      noarch            1:1.9998.11-5.el8                                 BaseOS               195 k
 perl-Math-Complex                     noarch            1.59-416.el8                                      BaseOS               108 k
 perl-PathTools                        x86_64            3.74-1.el8                                        BaseOS                90 k
 perl-Pod-Escapes                      noarch            1:1.07-395.el8                                    BaseOS                20 k
 perl-Pod-Perldoc                      noarch            3.28-396.el8                                      BaseOS                86 k
 perl-Pod-Simple                       noarch            1:3.35-395.el8                                    BaseOS               213 k
 perl-Pod-Usage                        noarch            4:1.69-395.el8                                    BaseOS                34 k
 perl-Scalar-List-Utils                x86_64            3:1.49-2.el8                                      BaseOS                68 k
 perl-Socket                           x86_64            4:2.027-2.el8                                     BaseOS                59 k
 perl-Storable                         x86_64            1:3.11-3.el8                                      BaseOS                98 k
 perl-Term-ANSIColor                   noarch            4.06-396.el8                                      BaseOS                46 k
 perl-Term-Cap                         noarch            1.17-395.el8                                      BaseOS                23 k
 perl-Text-ParseWords                  noarch            3.30-395.el8                                      BaseOS                18 k
 perl-Text-Tabs+Wrap                   noarch            2013.0523-395.el8                                 BaseOS                24 k
 perl-Time-Local                       noarch            1:1.280-1.el8                                     BaseOS                34 k
 perl-Unicode-Normalize                x86_64            1.25-396.el8                                      BaseOS                82 k
 perl-constant                         noarch            1.33-396.el8                                      BaseOS                25 k
 perl-interpreter                      x86_64            4:5.26.3-416.el8                                  BaseOS               6.3 M
 perl-libs                             x86_64            4:5.26.3-416.el8                                  BaseOS               1.6 M
 perl-macros                           x86_64            4:5.26.3-416.el8                                  BaseOS                72 k
 perl-parent                           noarch            1:0.237-1.el8                                     BaseOS                20 k
 perl-podlators                        noarch            4.11-1.el8                                        BaseOS               118 k
 perl-threads                          x86_64            1:2.21-2.el8                                      BaseOS                61 k
 perl-threads-shared                   x86_64            1.58-2.el8                                        BaseOS                48 k
 psmisc                                x86_64            23.1-3.el8                                        BaseOS               151 k
Installing weak dependencies:
 mariadb-backup                        x86_64            3:10.3.11-2.module_el8.0.0+35+6f2527ed            AppStream            6.2 M
 mariadb-gssapi-server                 x86_64            3:10.3.11-2.module_el8.0.0+35+6f2527ed            AppStream             49 k
 mariadb-server-utils                  x86_64            3:10.3.11-2.module_el8.0.0+35+6f2527ed            AppStream            1.6 M
 perl-IO-Socket-IP                     noarch            0.39-5.el8                                        AppStream             47 k
 perl-IO-Socket-SSL                    noarch            2.060-2.el8                                       AppStream            289 k
 perl-Mozilla-CA                       noarch            20160104-7.el8                                    AppStream             15 k
Installing module profiles:
 mariadb/server
Enabling module streams:
 mariadb                                                 10.3
 perl-DBD-MySQL                                          4.046
 perl-DBI                                                1.641

Transaction Summary
======================================================================================================================================
Install  55 Packages

Total download size: 44 M
Installed size: 201 M
Is this ok [y/N]: y
Downloading Packages:
(1/55): mariadb-common-10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64.rpm                                 31 kB/s |  62 kB     00:01
(2/55): mariadb-connector-c-3.0.7-1.el8.x86_64.rpm                                                    346 kB/s | 148 kB     00:00
(3/55): mariadb-connector-c-config-3.0.7-1.el8.noarch.rpm                                             209 kB/s |  13 kB     00:00
(4/55): mariadb-errmsg-10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64.rpm                                321 kB/s | 232 kB     00:00
(5/55): mariadb-gssapi-server-10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64.rpm                         280 kB/s |  49 kB     00:00
(6/55): mariadb-backup-10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64.rpm                                408 kB/s | 6.2 MB     00:15
(7/55): mariadb-10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64.rpm                                       395 kB/s | 6.2 MB     00:16
(8/55): perl-DBD-MySQL-4.046-2.module_el8.0.0+72+668237d8.x86_64.rpm                                  166 kB/s | 156 kB     00:00
(9/55): perl-DBI-1.641-2.module_el8.0.0+66+fe1eca09.x86_64.rpm                                        168 kB/s | 740 kB     00:04
(10/55): perl-Digest-1.17-395.el8.noarch.rpm                                                           95 kB/s |  27 kB     00:00
(11/55): perl-Digest-MD5-2.55-396.el8.x86_64.rpm                                                      142 kB/s |  37 kB     00:00
(12/55): perl-IO-Socket-IP-0.39-5.el8.noarch.rpm                                                      190 kB/s |  47 kB     00:00
(13/55): mariadb-server-utils-10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64.rpm                         230 kB/s | 1.6 MB     00:07
(14/55): perl-Mozilla-CA-20160104-7.el8.noarch.rpm                                                    182 kB/s |  15 kB     00:00
(15/55): perl-IO-Socket-SSL-2.060-2.el8.noarch.rpm                                                    221 kB/s | 289 kB     00:01
(16/55): perl-Net-SSLeay-1.85-6.el8.x86_64.rpm                                                        432 kB/s | 358 kB     00:00
(17/55): perl-URI-1.73-3.el8.noarch.rpm                                                               375 kB/s | 116 kB     00:00
(18/55): perl-libnet-3.11-3.el8.noarch.rpm                                                            511 kB/s | 121 kB     00:00
(19/55): perl-Carp-1.42-396.el8.noarch.rpm                                                            155 kB/s |  30 kB     00:00
(20/55): perl-Data-Dumper-2.167-399.el8.x86_64.rpm                                                    535 kB/s |  58 kB     00:00
(21/55): perl-Errno-1.28-416.el8.x86_64.rpm                                                           708 kB/s |  76 kB     00:00
(22/55): perl-Exporter-5.72-396.el8.noarch.rpm                                                        638 kB/s |  34 kB     00:00
(23/55): perl-File-Path-2.15-2.el8.noarch.rpm                                                         443 kB/s |  38 kB     00:00
(24/55): perl-File-Temp-0.230.600-1.el8.noarch.rpm                                                    579 kB/s |  63 kB     00:00
(25/55): perl-Getopt-Long-2.50-4.el8.noarch.rpm                                                       473 kB/s |  63 kB     00:00
(26/55): perl-HTTP-Tiny-0.074-1.el8.noarch.rpm                                                        682 kB/s |  58 kB     00:00
(27/55): perl-IO-1.38-416.el8.x86_64.rpm                                                              665 kB/s | 141 kB     00:00
(28/55): perl-MIME-Base64-3.15-396.el8.x86_64.rpm                                                     427 kB/s |  31 kB     00:00
(29/55): perl-Math-BigInt-1.9998.11-5.el8.noarch.rpm                                                  971 kB/s | 195 kB     00:00
(30/55): perl-Encode-2.97-3.el8.x86_64.rpm                                                            1.2 MB/s | 1.5 MB     00:01
(31/55): perl-Math-Complex-1.59-416.el8.noarch.rpm                                                    919 kB/s | 108 kB     00:00
(32/55): perl-Pod-Escapes-1.07-395.el8.noarch.rpm                                                     295 kB/s |  20 kB     00:00
(33/55): perl-PathTools-3.74-1.el8.x86_64.rpm                                                         599 kB/s |  90 kB     00:00
(34/55): perl-Pod-Perldoc-3.28-396.el8.noarch.rpm                                                     948 kB/s |  86 kB     00:00
(35/55): perl-Pod-Usage-1.69-395.el8.noarch.rpm                                                       489 kB/s |  34 kB     00:00
(36/55): perl-Scalar-List-Utils-1.49-2.el8.x86_64.rpm                                                 516 kB/s |  68 kB     00:00
(37/55): perl-Pod-Simple-3.35-395.el8.noarch.rpm                                                      757 kB/s | 213 kB     00:00
(38/55): perl-Socket-2.027-2.el8.x86_64.rpm                                                           735 kB/s |  59 kB     00:00
(39/55): perl-Storable-3.11-3.el8.x86_64.rpm                                                          504 kB/s |  98 kB     00:00
(40/55): perl-Term-Cap-1.17-395.el8.noarch.rpm                                                        480 kB/s |  23 kB     00:00
(41/55): perl-Text-ParseWords-3.30-395.el8.noarch.rpm                                                 344 kB/s |  18 kB     00:00
(42/55): perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch.rpm                                             402 kB/s |  24 kB     00:00
(43/55): perl-Time-Local-1.280-1.el8.noarch.rpm                                                       520 kB/s |  34 kB     00:00
(44/55): perl-Term-ANSIColor-4.06-396.el8.noarch.rpm                                                  123 kB/s |  46 kB     00:00
(45/55): perl-constant-1.33-396.el8.noarch.rpm                                                        686 kB/s |  25 kB     00:00
(46/55): perl-Unicode-Normalize-1.25-396.el8.x86_64.rpm                                               937 kB/s |  82 kB     00:00
(47/55): mariadb-server-10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64.rpm                               722 kB/s |  16 MB     00:23
(48/55): perl-macros-5.26.3-416.el8.x86_64.rpm                                                        1.4 MB/s |  72 kB     00:00
(49/55): perl-parent-0.237-1.el8.noarch.rpm                                                           1.1 MB/s |  20 kB     00:00
(50/55): perl-podlators-4.11-1.el8.noarch.rpm                                                         2.2 MB/s | 118 kB     00:00
(51/55): perl-threads-2.21-2.el8.x86_64.rpm                                                           2.0 MB/s |  61 kB     00:00
(52/55): perl-threads-shared-1.58-2.el8.x86_64.rpm                                                    2.1 MB/s |  48 kB     00:00
(53/55): psmisc-23.1-3.el8.x86_64.rpm                                                                 1.8 MB/s | 151 kB     00:00
(54/55): perl-libs-5.26.3-416.el8.x86_64.rpm                                                          1.5 MB/s | 1.6 MB     00:01
(55/55): perl-interpreter-5.26.3-416.el8.x86_64.rpm                                                   1.7 MB/s | 6.3 MB     00:03
--------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                 1.1 MB/s |  44 MB     00:41
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Running scriptlet: mariadb-connector-c-3.0.7-1.el8.x86_64                                                                       1/1
  Preparing        :                                                                                                              1/1
  Installing       : perl-Exporter-5.72-396.el8.noarch                                                                           1/55
  Installing       : perl-libs-4:5.26.3-416.el8.x86_64                                                                           2/55
  Installing       : perl-Carp-1.42-396.el8.noarch                                                                               3/55
  Installing       : perl-Scalar-List-Utils-3:1.49-2.el8.x86_64                                                                  4/55
  Installing       : perl-parent-1:0.237-1.el8.noarch                                                                            5/55
  Installing       : mariadb-connector-c-config-3.0.7-1.el8.noarch                                                               6/55
  Installing       : mariadb-common-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64                                                7/55
  Installing       : mariadb-connector-c-3.0.7-1.el8.x86_64                                                                      8/55
  Installing       : perl-Text-ParseWords-3.30-395.el8.noarch                                                                    9/55
  Installing       : mariadb-errmsg-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64                                               10/55
  Installing       : perl-Term-ANSIColor-4.06-396.el8.noarch                                                                    11/55
  Installing       : perl-macros-4:5.26.3-416.el8.x86_64                                                                        12/55
  Installing       : perl-Errno-1.28-416.el8.x86_64                                                                             13/55
  Installing       : perl-Socket-4:2.027-2.el8.x86_64                                                                           14/55
  Installing       : perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch                                                               15/55
  Installing       : perl-Unicode-Normalize-1.25-396.el8.x86_64                                                                 16/55
  Installing       : perl-File-Path-2.15-2.el8.noarch                                                                           17/55
  Installing       : perl-IO-1.38-416.el8.x86_64                                                                                18/55
  Installing       : perl-PathTools-3.74-1.el8.x86_64                                                                           19/55
  Installing       : perl-constant-1.33-396.el8.noarch                                                                          20/55
  Installing       : perl-threads-1:2.21-2.el8.x86_64                                                                           21/55
  Installing       : perl-threads-shared-1.58-2.el8.x86_64                                                                      22/55
  Installing       : perl-interpreter-4:5.26.3-416.el8.x86_64                                                                   23/55
  Installing       : perl-MIME-Base64-3.15-396.el8.x86_64                                                                       24/55
  Installing       : perl-IO-Socket-IP-0.39-5.el8.noarch                                                                        25/55
  Installing       : perl-Data-Dumper-2.167-399.el8.x86_64                                                                      26/55
  Installing       : perl-File-Temp-0.230.600-1.el8.noarch                                                                      27/55
  Installing       : perl-Storable-1:3.11-3.el8.x86_64                                                                          28/55
  Installing       : perl-Time-Local-1:1.280-1.el8.noarch                                                                       29/55
  Installing       : perl-Digest-1.17-395.el8.noarch                                                                            30/55
  Installing       : perl-Digest-MD5-2.55-396.el8.x86_64                                                                        31/55
  Installing       : perl-Net-SSLeay-1.85-6.el8.x86_64                                                                          32/55
  Installing       : perl-Math-Complex-1.59-416.el8.noarch                                                                      33/55
  Installing       : perl-Math-BigInt-1:1.9998.11-5.el8.noarch                                                                  34/55
  Installing       : perl-Pod-Escapes-1:1.07-395.el8.noarch                                                                     35/55
  Installing       : perl-Term-Cap-1.17-395.el8.noarch                                                                          36/55
  Installing       : perl-Mozilla-CA-20160104-7.el8.noarch                                                                      37/55
  Installing       : perl-Encode-4:2.97-3.el8.x86_64                                                                            38/55
  Installing       : perl-Pod-Simple-1:3.35-395.el8.noarch                                                                      39/55
  Installing       : perl-Getopt-Long-1:2.50-4.el8.noarch                                                                       40/55
  Installing       : perl-podlators-4.11-1.el8.noarch                                                                           41/55
  Installing       : perl-Pod-Usage-4:1.69-395.el8.noarch                                                                       42/55
  Installing       : perl-Pod-Perldoc-3.28-396.el8.noarch                                                                       43/55
  Installing       : perl-HTTP-Tiny-0.074-1.el8.noarch                                                                          44/55
  Installing       : perl-IO-Socket-SSL-2.060-2.el8.noarch                                                                      45/55
  Installing       : perl-libnet-3.11-3.el8.noarch                                                                              46/55
  Installing       : perl-URI-1.73-3.el8.noarch                                                                                 47/55
  Installing       : perl-DBI-1.641-2.module_el8.0.0+66+fe1eca09.x86_64                                                         48/55
  Installing       : perl-DBD-MySQL-4.046-2.module_el8.0.0+72+668237d8.x86_64                                                   49/55
  Installing       : psmisc-23.1-3.el8.x86_64                                                                                   50/55
  Installing       : mariadb-backup-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64                                               51/55
  Installing       : mariadb-gssapi-server-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64                                        52/55
  Installing       : mariadb-server-utils-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64                                         53/55
  Running scriptlet: mariadb-server-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64                                               54/55
  Installing       : mariadb-server-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64                                               54/55
  Running scriptlet: mariadb-server-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64                                               54/55
  Installing       : mariadb-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64                                                      55/55
  Running scriptlet: mariadb-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64                                                      55/55
  Verifying        : mariadb-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64                                                       1/55
  Verifying        : mariadb-backup-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64                                                2/55
  Verifying        : mariadb-common-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64                                                3/55
  Verifying        : mariadb-connector-c-3.0.7-1.el8.x86_64                                                                      4/55
  Verifying        : mariadb-connector-c-config-3.0.7-1.el8.noarch                                                               5/55
  Verifying        : mariadb-errmsg-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64                                                6/55
  Verifying        : mariadb-gssapi-server-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64                                         7/55
  Verifying        : mariadb-server-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64                                                8/55
  Verifying        : mariadb-server-utils-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64                                          9/55
  Verifying        : perl-DBD-MySQL-4.046-2.module_el8.0.0+72+668237d8.x86_64                                                   10/55
  Verifying        : perl-DBI-1.641-2.module_el8.0.0+66+fe1eca09.x86_64                                                         11/55
  Verifying        : perl-Digest-1.17-395.el8.noarch                                                                            12/55
  Verifying        : perl-Digest-MD5-2.55-396.el8.x86_64                                                                        13/55
  Verifying        : perl-IO-Socket-IP-0.39-5.el8.noarch                                                                        14/55
  Verifying        : perl-IO-Socket-SSL-2.060-2.el8.noarch                                                                      15/55
  Verifying        : perl-Mozilla-CA-20160104-7.el8.noarch                                                                      16/55
  Verifying        : perl-Net-SSLeay-1.85-6.el8.x86_64                                                                          17/55
  Verifying        : perl-URI-1.73-3.el8.noarch                                                                                 18/55
  Verifying        : perl-libnet-3.11-3.el8.noarch                                                                              19/55
  Verifying        : perl-Carp-1.42-396.el8.noarch                                                                              20/55
  Verifying        : perl-Data-Dumper-2.167-399.el8.x86_64                                                                      21/55
  Verifying        : perl-Encode-4:2.97-3.el8.x86_64                                                                            22/55
  Verifying        : perl-Errno-1.28-416.el8.x86_64                                                                             23/55
  Verifying        : perl-Exporter-5.72-396.el8.noarch                                                                          24/55
  Verifying        : perl-File-Path-2.15-2.el8.noarch                                                                           25/55
  Verifying        : perl-File-Temp-0.230.600-1.el8.noarch                                                                      26/55
  Verifying        : perl-Getopt-Long-1:2.50-4.el8.noarch                                                                       27/55
  Verifying        : perl-HTTP-Tiny-0.074-1.el8.noarch                                                                          28/55
  Verifying        : perl-IO-1.38-416.el8.x86_64                                                                                29/55
  Verifying        : perl-MIME-Base64-3.15-396.el8.x86_64                                                                       30/55
  Verifying        : perl-Math-BigInt-1:1.9998.11-5.el8.noarch                                                                  31/55
  Verifying        : perl-Math-Complex-1.59-416.el8.noarch                                                                      32/55
  Verifying        : perl-PathTools-3.74-1.el8.x86_64                                                                           33/55
  Verifying        : perl-Pod-Escapes-1:1.07-395.el8.noarch                                                                     34/55
  Verifying        : perl-Pod-Perldoc-3.28-396.el8.noarch                                                                       35/55
  Verifying        : perl-Pod-Simple-1:3.35-395.el8.noarch                                                                      36/55
  Verifying        : perl-Pod-Usage-4:1.69-395.el8.noarch                                                                       37/55
  Verifying        : perl-Scalar-List-Utils-3:1.49-2.el8.x86_64                                                                 38/55
  Verifying        : perl-Socket-4:2.027-2.el8.x86_64                                                                           39/55
  Verifying        : perl-Storable-1:3.11-3.el8.x86_64                                                                          40/55
  Verifying        : perl-Term-ANSIColor-4.06-396.el8.noarch                                                                    41/55
  Verifying        : perl-Term-Cap-1.17-395.el8.noarch                                                                          42/55
  Verifying        : perl-Text-ParseWords-3.30-395.el8.noarch                                                                   43/55
  Verifying        : perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch                                                               44/55
  Verifying        : perl-Time-Local-1:1.280-1.el8.noarch                                                                       45/55
  Verifying        : perl-Unicode-Normalize-1.25-396.el8.x86_64                                                                 46/55
  Verifying        : perl-constant-1.33-396.el8.noarch                                                                          47/55
  Verifying        : perl-interpreter-4:5.26.3-416.el8.x86_64                                                                   48/55
  Verifying        : perl-libs-4:5.26.3-416.el8.x86_64                                                                          49/55
  Verifying        : perl-macros-4:5.26.3-416.el8.x86_64                                                                        50/55
  Verifying        : perl-parent-1:0.237-1.el8.noarch                                                                           51/55
  Verifying        : perl-podlators-4.11-1.el8.noarch                                                                           52/55
  Verifying        : perl-threads-1:2.21-2.el8.x86_64                                                                           53/55
  Verifying        : perl-threads-shared-1.58-2.el8.x86_64                                                                      54/55
  Verifying        : psmisc-23.1-3.el8.x86_64                                                                                   55/55

Installed:
  mariadb-server-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64
  mariadb-backup-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64
  mariadb-gssapi-server-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64
  mariadb-server-utils-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64
  perl-IO-Socket-IP-0.39-5.el8.noarch
  perl-IO-Socket-SSL-2.060-2.el8.noarch
  perl-Mozilla-CA-20160104-7.el8.noarch
  mariadb-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64
  mariadb-common-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64
  mariadb-connector-c-3.0.7-1.el8.x86_64
  mariadb-connector-c-config-3.0.7-1.el8.noarch
  mariadb-errmsg-3:10.3.11-2.module_el8.0.0+35+6f2527ed.x86_64
  perl-DBD-MySQL-4.046-2.module_el8.0.0+72+668237d8.x86_64
  perl-DBI-1.641-2.module_el8.0.0+66+fe1eca09.x86_64
  perl-Digest-1.17-395.el8.noarch
  perl-Digest-MD5-2.55-396.el8.x86_64
  perl-Net-SSLeay-1.85-6.el8.x86_64
  perl-URI-1.73-3.el8.noarch
  perl-libnet-3.11-3.el8.noarch
  perl-Carp-1.42-396.el8.noarch
  perl-Data-Dumper-2.167-399.el8.x86_64
  perl-Encode-4:2.97-3.el8.x86_64
  perl-Errno-1.28-416.el8.x86_64
  perl-Exporter-5.72-396.el8.noarch
  perl-File-Path-2.15-2.el8.noarch
  perl-File-Temp-0.230.600-1.el8.noarch
  perl-Getopt-Long-1:2.50-4.el8.noarch
  perl-HTTP-Tiny-0.074-1.el8.noarch
  perl-IO-1.38-416.el8.x86_64
  perl-MIME-Base64-3.15-396.el8.x86_64
  perl-Math-BigInt-1:1.9998.11-5.el8.noarch
  perl-Math-Complex-1.59-416.el8.noarch
  perl-PathTools-3.74-1.el8.x86_64
  perl-Pod-Escapes-1:1.07-395.el8.noarch
  perl-Pod-Perldoc-3.28-396.el8.noarch
  perl-Pod-Simple-1:3.35-395.el8.noarch
  perl-Pod-Usage-4:1.69-395.el8.noarch
  perl-Scalar-List-Utils-3:1.49-2.el8.x86_64
  perl-Socket-4:2.027-2.el8.x86_64
  perl-Storable-1:3.11-3.el8.x86_64
  perl-Term-ANSIColor-4.06-396.el8.noarch
  perl-Term-Cap-1.17-395.el8.noarch
  perl-Text-ParseWords-3.30-395.el8.noarch
  perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch
  perl-Time-Local-1:1.280-1.el8.noarch
  perl-Unicode-Normalize-1.25-396.el8.x86_64
  perl-constant-1.33-396.el8.noarch
  perl-interpreter-4:5.26.3-416.el8.x86_64
  perl-libs-4:5.26.3-416.el8.x86_64
  perl-macros-4:5.26.3-416.el8.x86_64
  perl-parent-1:0.237-1.el8.noarch
  perl-podlators-4.11-1.el8.noarch
  perl-threads-1:2.21-2.el8.x86_64
  perl-threads-shared-1.58-2.el8.x86_64
  psmisc-23.1-3.el8.x86_64

Complete!
[[email protected] ~]#
[[email protected] ~]# mysql_secure_installation

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 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Enter current password for root (enter for none):
Aborting!

Cleaning up...
[[email protected] ~]#
[[email protected] ~]# service mysql start
Redirecting to /bin/systemctl start mysql.service
Failed to start mysql.service: Unit mysql.service not found.
[[email protected] ~]#
[[email protected] ~]# service mysqld start
Redirecting to /bin/systemctl start mysqld.service
Failed to start mysqld.service: Unit mysqld.service not found.
[[email protected] ~]# sudo systemctl enable --now mariadb
Created symlink /etc/systemd/system/mysql.service → /usr/lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/mysqld.service → /usr/lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /usr/lib/systemd/system/mariadb.service.
[[email protected] ~]#
[[email protected] ~]# service mysqld status
Redirecting to /bin/systemctl status mysqld.service
● mariadb.service - MariaDB 10.3 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: active (running) since Fri 2019-09-27 15:38:54 WIB; 4s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 18416 ExecStartPost=/usr/libexec/mysql-check-upgrade (code=exited, status=0/SUCCESS)
  Process: 18283 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mariadb.service (code=exited, status=0/SUCCESS)
  Process: 18258 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
 Main PID: 18385 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 30 (limit: 26213)
   Memory: 87.2M
   CGroup: /system.slice/mariadb.service
           └─18385 /usr/libexec/mysqld --basedir=/usr

Sep 27 15:38:54 analytic mysql-prepare-db-dir[18283]: Please report any problems at http://mariadb.org/jira
Sep 27 15:38:54 analytic mysql-prepare-db-dir[18283]: The latest information about MariaDB is available at http://mariadb.org/.
Sep 27 15:38:54 analytic mysql-prepare-db-dir[18283]: You can find additional information about the MySQL part at:
Sep 27 15:38:54 analytic mysql-prepare-db-dir[18283]: http://dev.mysql.com
Sep 27 15:38:54 analytic mysql-prepare-db-dir[18283]: Consider joining MariaDB's strong and vibrant community:
Sep 27 15:38:54 analytic mysql-prepare-db-dir[18283]: https://mariadb.org/get-involved/
Sep 27 15:38:54 analytic mysqld[18385]: 2019-09-27 15:38:54 0 [Note] /usr/libexec/mysqld (mysqld 10.3.11-MariaDB) starting as process>
Sep 27 15:38:54 analytic mysqld[18385]: 2019-09-27 15:38:54 0 [Warning] Could not increase number of max_open_files to more than 1024>
Sep 27 15:38:54 analytic mysqld[18385]: 2019-09-27 15:38:54 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (w>
Sep 27 15:38:54 analytic systemd[1]: Started MariaDB 10.3 database server.

[[email protected] ~]#
[[email protected] ~]# mysql_secure_installation

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):
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.

Set root password? [Y/n] Y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] Y
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] Y
 ... Success!

By default, MariaDB comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] Y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] Y
 ... Success!

Cleaning up...

All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!
[[email protected] ~]#
       

Tidak ada komentar :

Posting Komentar