Linux入門　MariaDBインストール

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

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

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

１．MariaDBをインストールします。

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
[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!

２．サービスを開始します。

1
[root@wordpress chatora]# systemctl start mariadb

３．自動起動を有効にします。

1
2
3
4
[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.

４．初期設定を行います。

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
[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]の下の行に、文字コードの設定を追加します。

1
2
3
[root@wordpress chatora]# vi /etc/my.cnf.d/mariadb-server.cnf
 
character-set-server = utf8mb4

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

1
2
3
[root@wordpress chatora]# vi /etc/my.cnf.d/client.cnf
 
character-set-server = utf8mb4

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

1
[root@wordpress chatora]# systemctl restart mariadb
タイトルとURLをコピーしました