How to install MySql MariaDb server on linux centos 8
Install mariadb with dnf module install command
[root@analytic ~]# 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.
[root@analytic ~]# 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
[root@analytic ~]# 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!
[root@analytic ~]#
[root@analytic ~]# 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...
[root@analytic ~]#
[root@analytic ~]# service mysql start
Redirecting to /bin/systemctl start mysql.service
Failed to start mysql.service: Unit mysql.service not found.
[root@analytic ~]#
[root@analytic ~]# service mysqld start
Redirecting to /bin/systemctl start mysqld.service
Failed to start mysqld.service: Unit mysqld.service not found.
[root@analytic ~]# 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.
[root@analytic ~]#
[root@analytic ~]# 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.
[root@analytic ~]#
[root@analytic ~]# 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!
[root@analytic ~]#
Tidak ada komentar :
Posting Komentar