Linux入門 MariaDBインストール

WordPressを利用するにはデータベースが必要だにょろ

データベースは知らないけど、キャットベースで遊ぶのは楽しいにゃ

それも関係ないにょろ!


データベースとはデータの集まりです。
サーバの中で効率的にデータを管理するため、データベースを利用します。
そのデータベースを管理するためのソフトウェアをデータベース管理システムと呼びますが、日常的にはソフトウェアの事もデータベースと呼んでいます。

WordPressを利用するにはデータベースが必要になりますので、ここでは、MariaDB(マリアデービー)というデータベースソフトをインストールします。

MariaDB(マリアデービー)とは
MySQLから派生したデータベース管理システムです。
MySQLがOracleに買収されて以降、代替として利用されることが多くなりました。

1.MariaDBをインストールします。

[root@wordpress chatora]#  dnf install -y mariadb-server
Last metadata expiration check: 2:30:01 ago on Mon 23 Nov 2020 10:43:01 AM UTC.
Dependencies resolved.
================================================================================
 Package                    Arch   Version                      Repo       Size
================================================================================
Installing:
 mariadb-server             x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6
                                                                AppStream  16 M
Installing dependencies:
 libaio                     x86_64 0.3.112-1.el8                BaseOS     33 k
 mariadb                    x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6
                                                                AppStream 6.1 M
 mariadb-common             x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6
                                                                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.17-1.module_el8.1.0+257+48736ea6
                                                                AppStream 232 k
 perl-Carp                  noarch 1.42-396.el8                 BaseOS     30 k
 perl-DBD-MySQL             x86_64 4.046-3.module_el8.1.0+203+e45423dc
                                                                AppStream 156 k
 perl-DBI                   x86_64 1.641-3.module_el8.1.0+199+8f0a6bbd
                                                                AppStream 740 k
 perl-Data-Dumper           x86_64 2.167-399.el8                BaseOS     58 k
 perl-Digest                noarch 1.17-395.el8                 AppStream  27 k
 perl-Digest-MD5            x86_64 2.55-396.el8                 AppStream  37 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-7.el8            BaseOS    196 k
 perl-Math-Complex          noarch 1.59-416.el8                 BaseOS    108 k
 perl-Net-SSLeay            x86_64 1.88-1.el8                   AppStream 379 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-3.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-URI                   noarch 1.73-3.el8                   AppStream 116 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-libnet                noarch 3.11-3.el8                   AppStream 121 k
 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-4.el8                   BaseOS    150 k
Installing weak dependencies:
 mariadb-backup             x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6
                                                                AppStream 6.0 M
 mariadb-gssapi-server      x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6
                                                                AppStream  49 k
 mariadb-server-utils       x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6
                                                                AppStream 1.6 M
 perl-IO-Socket-IP          noarch 0.39-5.el8                   AppStream  47 k
 perl-IO-Socket-SSL         noarch 2.066-4.el8                  AppStream 297 k
 perl-Mozilla-CA            noarch 20160104-7.el8               AppStream  15 k
Enabling module streams:
 mariadb                           10.3
 perl                              5.26
 perl-DBD-MySQL                    4.046
 perl-DBI                          1.641

Transaction Summary
================================================================================
Install  56 Packages

Total download size: 44 M
Installed size: 209 M
Downloading Packages:
(1/56): mariadb-common-10.3.17-1.module_el8.1.0 246 kB/s |  62 kB     00:00
(2/56): mariadb-connector-c-3.0.7-1.el8.x86_64. 1.2 MB/s | 148 kB     00:00
(3/56): mariadb-connector-c-config-3.0.7-1.el8. 231 kB/s |  13 kB     00:00
(4/56): mariadb-errmsg-10.3.17-1.module_el8.1.0 1.9 MB/s | 232 kB     00:00
(5/56): mariadb-gssapi-server-10.3.17-1.module_ 835 kB/s |  49 kB     00:00
(6/56): mariadb-10.3.17-1.module_el8.1.0+257+48 8.7 MB/s | 6.1 MB     00:00
(7/56): mariadb-backup-10.3.17-1.module_el8.1.0 8.3 MB/s | 6.0 MB     00:00
(8/56): mariadb-server-utils-10.3.17-1.module_e  20 MB/s | 1.6 MB     00:00
(9/56): perl-DBD-MySQL-4.046-3.module_el8.1.0+2 2.4 MB/s | 156 kB     00:00
(10/56): perl-DBI-1.641-3.module_el8.1.0+199+8f  10 MB/s | 740 kB     00:00
(11/56): perl-Digest-1.17-395.el8.noarch.rpm    439 kB/s |  27 kB     00:00
(12/56): perl-Digest-MD5-2.55-396.el8.x86_64.rp 617 kB/s |  37 kB     00:00
(13/56): perl-IO-Socket-IP-0.39-5.el8.noarch.rp 759 kB/s |  47 kB     00:00
(14/56): perl-IO-Socket-SSL-2.066-4.el8.noarch. 4.5 MB/s | 297 kB     00:00
(15/56): perl-Mozilla-CA-20160104-7.el8.noarch. 247 kB/s |  15 kB     00:00
(16/56): perl-URI-1.73-3.el8.noarch.rpm         1.8 MB/s | 116 kB     00:00
(17/56): perl-Net-SSLeay-1.88-1.el8.x86_64.rpm  5.0 MB/s | 379 kB     00:00
(18/56): perl-libnet-3.11-3.el8.noarch.rpm      1.9 MB/s | 121 kB     00:00
(19/56): libaio-0.3.112-1.el8.x86_64.rpm        552 kB/s |  33 kB     00:00
(20/56): perl-Carp-1.42-396.el8.noarch.rpm      496 kB/s |  30 kB     00:00
(21/56): perl-Data-Dumper-2.167-399.el8.x86_64. 974 kB/s |  58 kB     00:00
(22/56): perl-Errno-1.28-416.el8.x86_64.rpm     1.2 MB/s |  76 kB     00:00
(23/56): perl-Encode-2.97-3.el8.x86_64.rpm       19 MB/s | 1.5 MB     00:00
(24/56): mariadb-server-10.3.17-1.module_el8.1.  23 MB/s |  16 MB     00:00
(25/56): perl-Exporter-5.72-396.el8.noarch.rpm  449 kB/s |  34 kB     00:00
(26/56): perl-File-Path-2.15-2.el8.noarch.rpm   616 kB/s |  38 kB     00:00
(27/56): perl-File-Temp-0.230.600-1.el8.noarch. 1.0 MB/s |  63 kB     00:00
(28/56): perl-Getopt-Long-2.50-4.el8.noarch.rpm 1.0 MB/s |  63 kB     00:00
(29/56): perl-HTTP-Tiny-0.074-1.el8.noarch.rpm  948 kB/s |  58 kB     00:00
(30/56): perl-IO-1.38-416.el8.x86_64.rpm        2.3 MB/s | 141 kB     00:00
(31/56): perl-MIME-Base64-3.15-396.el8.x86_64.r 519 kB/s |  31 kB     00:00
(32/56): perl-Math-BigInt-1.9998.11-7.el8.noarc 3.0 MB/s | 196 kB     00:00
(33/56): perl-Math-Complex-1.59-416.el8.noarch. 1.8 MB/s | 108 kB     00:00
(34/56): perl-PathTools-3.74-1.el8.x86_64.rpm   1.5 MB/s |  90 kB     00:00
(35/56): perl-Pod-Escapes-1.07-395.el8.noarch.r 338 kB/s |  20 kB     00:00
(36/56): perl-Pod-Perldoc-3.28-396.el8.noarch.r 1.4 MB/s |  86 kB     00:00
(37/56): perl-Pod-Simple-3.35-395.el8.noarch.rp 3.4 MB/s | 213 kB     00:00
(38/56): perl-Pod-Usage-1.69-395.el8.noarch.rpm 566 kB/s |  34 kB     00:00
(39/56): perl-Scalar-List-Utils-1.49-2.el8.x86_ 1.1 MB/s |  68 kB     00:00
(40/56): perl-Socket-2.027-3.el8.x86_64.rpm     987 kB/s |  59 kB     00:00
(41/56): perl-Storable-3.11-3.el8.x86_64.rpm    1.6 MB/s |  98 kB     00:00
(42/56): perl-Term-ANSIColor-4.06-396.el8.noarc 790 kB/s |  46 kB     00:00
(43/56): perl-Term-Cap-1.17-395.el8.noarch.rpm  386 kB/s |  23 kB     00:00
(44/56): perl-Text-ParseWords-3.30-395.el8.noar 295 kB/s |  18 kB     00:00
(45/56): perl-Text-Tabs+Wrap-2013.0523-395.el8. 415 kB/s |  24 kB     00:00
(46/56): perl-Time-Local-1.280-1.el8.noarch.rpm 567 kB/s |  34 kB     00:00
(47/56): perl-Unicode-Normalize-1.25-396.el8.x8 1.3 MB/s |  82 kB     00:00
(48/56): perl-constant-1.33-396.el8.noarch.rpm  434 kB/s |  25 kB     00:00
(49/56): perl-libs-5.26.3-416.el8.x86_64.rpm     18 MB/s | 1.6 MB     00:00
(50/56): perl-macros-5.26.3-416.el8.x86_64.rpm  1.2 MB/s |  72 kB     00:00
(51/56): perl-parent-0.237-1.el8.noarch.rpm     306 kB/s |  20 kB     00:00
(52/56): perl-podlators-4.11-1.el8.noarch.rpm   2.0 MB/s | 118 kB     00:00
(53/56): perl-threads-2.21-2.el8.x86_64.rpm     1.0 MB/s |  61 kB     00:00
(54/56): perl-threads-shared-1.58-2.el8.x86_64. 816 kB/s |  48 kB     00:00
(55/56): perl-interpreter-5.26.3-416.el8.x86_64  24 MB/s | 6.3 MB     00:00
(56/56): psmisc-23.1-4.el8.x86_64.rpm           2.4 MB/s | 150 kB     00:00
--------------------------------------------------------------------------------
Total                                            19 MB/s |  44 MB     00:02
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/56
  Installing       : perl-libs-4:5.26.3-416.el8.x86_64                     2/56
  Installing       : perl-Carp-1.42-396.el8.noarch                         3/56
  Installing       : perl-Scalar-List-Utils-3:1.49-2.el8.x86_64            4/56
  Installing       : perl-parent-1:0.237-1.el8.noarch                      5/56
  Installing       : mariadb-connector-c-config-3.0.7-1.el8.noarch         6/56
  Installing       : mariadb-common-3:10.3.17-1.module_el8.1.0+257+4873    7/56
  Installing       : mariadb-connector-c-3.0.7-1.el8.x86_64                8/56
  Installing       : perl-Text-ParseWords-3.30-395.el8.noarch              9/56
  Installing       : libaio-0.3.112-1.el8.x86_64                          10/56
  Installing       : mariadb-errmsg-3:10.3.17-1.module_el8.1.0+257+4873   11/56
  Installing       : perl-Term-ANSIColor-4.06-396.el8.noarch              12/56
  Installing       : perl-macros-4:5.26.3-416.el8.x86_64                  13/56
  Installing       : perl-Errno-1.28-416.el8.x86_64                       14/56
  Installing       : perl-Socket-4:2.027-3.el8.x86_64                     15/56
  Installing       : perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch         16/56
  Installing       : perl-Unicode-Normalize-1.25-396.el8.x86_64           17/56
  Installing       : perl-File-Path-2.15-2.el8.noarch                     18/56
  Installing       : perl-IO-1.38-416.el8.x86_64                          19/56
  Installing       : perl-PathTools-3.74-1.el8.x86_64                     20/56
  Installing       : perl-constant-1.33-396.el8.noarch                    21/56
  Installing       : perl-threads-1:2.21-2.el8.x86_64                     22/56
  Installing       : perl-threads-shared-1.58-2.el8.x86_64                23/56
  Installing       : perl-interpreter-4:5.26.3-416.el8.x86_64             24/56
  Installing       : perl-MIME-Base64-3.15-396.el8.x86_64                 25/56
  Installing       : perl-IO-Socket-IP-0.39-5.el8.noarch                  26/56
  Installing       : perl-Data-Dumper-2.167-399.el8.x86_64                27/56
  Installing       : perl-File-Temp-0.230.600-1.el8.noarch                28/56
  Installing       : perl-Storable-1:3.11-3.el8.x86_64                    29/56
  Installing       : perl-Time-Local-1:1.280-1.el8.noarch                 30/56
  Installing       : perl-Digest-1.17-395.el8.noarch                      31/56
  Installing       : perl-Digest-MD5-2.55-396.el8.x86_64                  32/56
  Installing       : perl-Net-SSLeay-1.88-1.el8.x86_64                    33/56
  Installing       : perl-Math-Complex-1.59-416.el8.noarch                34/56
  Installing       : perl-Math-BigInt-1:1.9998.11-7.el8.noarch            35/56
  Installing       : perl-Pod-Escapes-1:1.07-395.el8.noarch               36/56
  Installing       : perl-Term-Cap-1.17-395.el8.noarch                    37/56
  Installing       : perl-Mozilla-CA-20160104-7.el8.noarch                38/56
  Installing       : perl-Encode-4:2.97-3.el8.x86_64                      39/56
  Installing       : perl-Pod-Simple-1:3.35-395.el8.noarch                40/56
  Installing       : perl-Getopt-Long-1:2.50-4.el8.noarch                 41/56
  Installing       : perl-podlators-4.11-1.el8.noarch                     42/56
  Installing       : perl-Pod-Usage-4:1.69-395.el8.noarch                 43/56
  Installing       : perl-Pod-Perldoc-3.28-396.el8.noarch                 44/56
  Installing       : perl-HTTP-Tiny-0.074-1.el8.noarch                    45/56
  Installing       : perl-IO-Socket-SSL-2.066-4.el8.noarch                46/56
  Installing       : perl-libnet-3.11-3.el8.noarch                        47/56
  Installing       : perl-URI-1.73-3.el8.noarch                           48/56
  Installing       : perl-DBI-1.641-3.module_el8.1.0+199+8f0a6bbd.x86_6   49/56
  Installing       : perl-DBD-MySQL-4.046-3.module_el8.1.0+203+e45423dc   50/56
  Installing       : psmisc-23.1-4.el8.x86_64                             51/56
  Installing       : mariadb-backup-3:10.3.17-1.module_el8.1.0+257+4873   52/56
  Installing       : mariadb-gssapi-server-3:10.3.17-1.module_el8.1.0+2   53/56
  Installing       : mariadb-server-utils-3:10.3.17-1.module_el8.1.0+25   54/56
  Running scriptlet: mariadb-server-3:10.3.17-1.module_el8.1.0+257+4873   55/56
  Installing       : mariadb-server-3:10.3.17-1.module_el8.1.0+257+4873   55/56
  Running scriptlet: mariadb-server-3:10.3.17-1.module_el8.1.0+257+4873   55/56
  Installing       : mariadb-3:10.3.17-1.module_el8.1.0+257+48736ea6.x8   56/56
  Running scriptlet: mariadb-3:10.3.17-1.module_el8.1.0+257+48736ea6.x8   56/56
  Verifying        : mariadb-3:10.3.17-1.module_el8.1.0+257+48736ea6.x8    1/56
  Verifying        : mariadb-backup-3:10.3.17-1.module_el8.1.0+257+4873    2/56
  Verifying        : mariadb-common-3:10.3.17-1.module_el8.1.0+257+4873    3/56
  Verifying        : mariadb-connector-c-3.0.7-1.el8.x86_64                4/56
  Verifying        : mariadb-connector-c-config-3.0.7-1.el8.noarch         5/56
  Verifying        : mariadb-errmsg-3:10.3.17-1.module_el8.1.0+257+4873    6/56
  Verifying        : mariadb-gssapi-server-3:10.3.17-1.module_el8.1.0+2    7/56
  Verifying        : mariadb-server-3:10.3.17-1.module_el8.1.0+257+4873    8/56
  Verifying        : mariadb-server-utils-3:10.3.17-1.module_el8.1.0+25    9/56
  Verifying        : perl-DBD-MySQL-4.046-3.module_el8.1.0+203+e45423dc   10/56
  Verifying        : perl-DBI-1.641-3.module_el8.1.0+199+8f0a6bbd.x86_6   11/56
  Verifying        : perl-Digest-1.17-395.el8.noarch                      12/56
  Verifying        : perl-Digest-MD5-2.55-396.el8.x86_64                  13/56
  Verifying        : perl-IO-Socket-IP-0.39-5.el8.noarch                  14/56
  Verifying        : perl-IO-Socket-SSL-2.066-4.el8.noarch                15/56
  Verifying        : perl-Mozilla-CA-20160104-7.el8.noarch                16/56
  Verifying        : perl-Net-SSLeay-1.88-1.el8.x86_64                    17/56
  Verifying        : perl-URI-1.73-3.el8.noarch                           18/56
  Verifying        : perl-libnet-3.11-3.el8.noarch                        19/56
  Verifying        : libaio-0.3.112-1.el8.x86_64                          20/56
  Verifying        : perl-Carp-1.42-396.el8.noarch                        21/56
  Verifying        : perl-Data-Dumper-2.167-399.el8.x86_64                22/56
  Verifying        : perl-Encode-4:2.97-3.el8.x86_64                      23/56
  Verifying        : perl-Errno-1.28-416.el8.x86_64                       24/56
  Verifying        : perl-Exporter-5.72-396.el8.noarch                    25/56
  Verifying        : perl-File-Path-2.15-2.el8.noarch                     26/56
  Verifying        : perl-File-Temp-0.230.600-1.el8.noarch                27/56
  Verifying        : perl-Getopt-Long-1:2.50-4.el8.noarch                 28/56
  Verifying        : perl-HTTP-Tiny-0.074-1.el8.noarch                    29/56
  Verifying        : perl-IO-1.38-416.el8.x86_64                          30/56
  Verifying        : perl-MIME-Base64-3.15-396.el8.x86_64                 31/56
  Verifying        : perl-Math-BigInt-1:1.9998.11-7.el8.noarch            32/56
  Verifying        : perl-Math-Complex-1.59-416.el8.noarch                33/56
  Verifying        : perl-PathTools-3.74-1.el8.x86_64                     34/56
  Verifying        : perl-Pod-Escapes-1:1.07-395.el8.noarch               35/56
  Verifying        : perl-Pod-Perldoc-3.28-396.el8.noarch                 36/56
  Verifying        : perl-Pod-Simple-1:3.35-395.el8.noarch                37/56
  Verifying        : perl-Pod-Usage-4:1.69-395.el8.noarch                 38/56
  Verifying        : perl-Scalar-List-Utils-3:1.49-2.el8.x86_64           39/56
  Verifying        : perl-Socket-4:2.027-3.el8.x86_64                     40/56
  Verifying        : perl-Storable-1:3.11-3.el8.x86_64                    41/56
  Verifying        : perl-Term-ANSIColor-4.06-396.el8.noarch              42/56
  Verifying        : perl-Term-Cap-1.17-395.el8.noarch                    43/56
  Verifying        : perl-Text-ParseWords-3.30-395.el8.noarch             44/56
  Verifying        : perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch         45/56
  Verifying        : perl-Time-Local-1:1.280-1.el8.noarch                 46/56
  Verifying        : perl-Unicode-Normalize-1.25-396.el8.x86_64           47/56
  Verifying        : perl-constant-1.33-396.el8.noarch                    48/56
  Verifying        : perl-interpreter-4:5.26.3-416.el8.x86_64             49/56
  Verifying        : perl-libs-4:5.26.3-416.el8.x86_64                    50/56
  Verifying        : perl-macros-4:5.26.3-416.el8.x86_64                  51/56
  Verifying        : perl-parent-1:0.237-1.el8.noarch                     52/56
  Verifying        : perl-podlators-4.11-1.el8.noarch                     53/56
  Verifying        : perl-threads-1:2.21-2.el8.x86_64                     54/56
  Verifying        : perl-threads-shared-1.58-2.el8.x86_64                55/56
  Verifying        : psmisc-23.1-4.el8.x86_64                             56/56

Installed:
  libaio-0.3.112-1.el8.x86_64
  mariadb-3:10.3.17-1.module_el8.1.0+257+48736ea6.x86_64
  mariadb-backup-3:10.3.17-1.module_el8.1.0+257+48736ea6.x86_64
  mariadb-common-3:10.3.17-1.module_el8.1.0+257+48736ea6.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.17-1.module_el8.1.0+257+48736ea6.x86_64
  mariadb-gssapi-server-3:10.3.17-1.module_el8.1.0+257+48736ea6.x86_64
  mariadb-server-3:10.3.17-1.module_el8.1.0+257+48736ea6.x86_64
  mariadb-server-utils-3:10.3.17-1.module_el8.1.0+257+48736ea6.x86_64
  perl-Carp-1.42-396.el8.noarch
  perl-DBD-MySQL-4.046-3.module_el8.1.0+203+e45423dc.x86_64
  perl-DBI-1.641-3.module_el8.1.0+199+8f0a6bbd.x86_64
  perl-Data-Dumper-2.167-399.el8.x86_64
  perl-Digest-1.17-395.el8.noarch
  perl-Digest-MD5-2.55-396.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-IO-Socket-IP-0.39-5.el8.noarch
  perl-IO-Socket-SSL-2.066-4.el8.noarch
  perl-MIME-Base64-3.15-396.el8.x86_64
  perl-Math-BigInt-1:1.9998.11-7.el8.noarch
  perl-Math-Complex-1.59-416.el8.noarch
  perl-Mozilla-CA-20160104-7.el8.noarch
  perl-Net-SSLeay-1.88-1.el8.x86_64
  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-3.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-URI-1.73-3.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-libnet-3.11-3.el8.noarch
  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-4.el8.x86_64

Complete!

2.サービスを開始します。

[root@wordpress chatora]# systemctl start mariadb

3.自動起動を有効にします。

[root@wordpress chatora]# systemctl enable 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.

4.初期設定を行います。

[root@wordpress chatora]# 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]
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]
 ... 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]
 ... 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]
 - 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]
 ... 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!

5.データベースで日本語を利用するため、文字コードを設定します。
17行目付近、[mysqld]の下の行に、文字コードの設定を追加します。

[root@wordpress chatora]# vi /etc/my.cnf.d/mariadb-server.cnf

character-set-server = utf8mb4

13行目付近、[client-mariadb]の下の行に、文字コードの設定を追加します。

[root@wordpress chatora]# vi /etc/my.cnf.d/client.cnf

character-set-server = utf8mb4

6.設定を反映させるため、再起動します。

[root@wordpress chatora]# systemctl restart mariadb

MariaDBの名前は、開発者の次女の名前からつけられたにょろ

コメントを残す

メールアドレスが公開されることはありません。 * が付いている欄は必須項目です