データベースとはデータの集まりです。
サーバの中で効率的にデータを管理するため、データベースを利用します。
そのデータベースを管理するためのソフトウェアをデータベース管理システムと呼びますが、日常的にはソフトウェアの事もデータベースと呼んでいます。
WordPressを利用するにはデータベースが必要になりますので、ここでは、MariaDB(マリアデービー)というデータベースソフトをインストールします。
MariaDB（マリアデービー）とは
MySQLから派生したデータベース管理システムです。
MySQLがOracleに買収されて以降、代替として利用されることが多くなりました。
１．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!
２．サービスを開始します。
[root@wordpress chatora]# systemctl start mariadb
３．自動起動を有効にします。
[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.
４．初期設定を行います。
[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!
５．データベースで日本語を利用するため、文字コードを設定します。
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
６．設定を反映させるため、再起動します。
[root@wordpress chatora]# systemctl restart mariadb
