본문 바로가기
Linux/서버구축 1.2.3...

(10) 워드프레스를 위한 리눅스 서버 구축 - MariaDB의 설치

by aegypius 2021. 4. 20.
728x90
반응형

MariaDB 10.4 설치


간만에 mariadb.org에 접속해보니 10.5.9까지 나왔다. 홈페이지의 개편도 있었는지 새롭다. CentOS 7의 기본설정으로는 5.5 버전이 설치되는데, 현재 워드프레스(버전 5.7.1)의 시스템 요구사항이 MySQL은 5.6 이상, MariaDB는 10.1 이상이다. 기존에 문제없이 사용했었던 버전(10.3과 10.4) 중에서 10.4를 설치하기로 했다.

첫 페이지에서 최상단의 메뉴에서 Download 혹은 조금 아래의 Download를 선택한 후 아래의 MariaDB Repositories가 보이는 곳 까지 화면을 내려보자. yum으로 설치하기 위함이다.

서버의 환경에 맞춰서 위와같이 설정을 했다. 안내된 텍스트를 /etc/yum.repos.d 에 MairaDB.repo로 저장하자. 내용은 아래와 같다.

# MariaDB 10.4 CentOS repository list - created 2021-04-19 16:20 UTC
# https://mariadb.org/download/
[mariadb]
name = MariaDB
baseurl = https://mirror.yongbok.net/mariadb/yum/10.4/centos7-amd64
gpgkey=https://mirror.yongbok.net/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1

 

MariaDB-server와 MariaDB-client를 설치하자.

[root@webpress /]# yum install mariadb-server mariadb-client
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.cat.net
 * elrepo: ftp.ne.jp
 * extras: mirrors.cat.net
 * updates: mirrors.cat.net
Package mariadb-server is obsoleted by MariaDB-server, trying to install MariaDB-server-10.4.18-1.el7.centos.x86_64 instead
No package mariadb-client available.
  * Maybe you meant: MariaDB-client
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-server.x86_64 0:10.4.18-1.el7.centos will be installed
--> Processing Dependency: MariaDB-client for package: MariaDB-server-10.4.18-1.el7.centos.x86_64
--> Processing Dependency: perl(File::Temp) for package: MariaDB-server-10.4.18-1.el7.centos.x86_64
--> Processing Dependency: perl(POSIX) for package: MariaDB-server-10.4.18-1.el7.centos.x86_64
--> Processing Dependency: perl(DBI) for package: MariaDB-server-10.4.18-1.el7.centos.x86_64
--> Processing Dependency: perl(Data::Dumper) for package: MariaDB-server-10.4.18-1.el7.centos.x86_64
--> Processing Dependency: perl(File::Basename) for package: MariaDB-server-10.4.18-1.el7.centos.x86_64
--> Processing Dependency: perl(Sys::Hostname) for package: MariaDB-server-10.4.18-1.el7.centos.x86_64
--> Processing Dependency: galera-4 for package: MariaDB-server-10.4.18-1.el7.centos.x86_64
--> Processing Dependency: perl(File::Path) for package: MariaDB-server-10.4.18-1.el7.centos.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: MariaDB-server-10.4.18-1.el7.centos.x86_64
--> Processing Dependency: /usr/bin/perl for package: MariaDB-server-10.4.18-1.el7.centos.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: MariaDB-server-10.4.18-1.el7.centos.x86_64
--> Processing Dependency: perl(Getopt::Long) for package: MariaDB-server-10.4.18-1.el7.centos.x86_64
--> Processing Dependency: MariaDB-common for package: MariaDB-server-10.4.18-1.el7.centos.x86_64
--> Processing Dependency: lsof for package: MariaDB-server-10.4.18-1.el7.centos.x86_64
--> Processing Dependency: perl(File::Copy) for package: MariaDB-server-10.4.18-1.el7.centos.x86_64
--> Processing Dependency: perl(strict) for package: MariaDB-server-10.4.18-1.el7.centos.x86_64
--> Processing Dependency: perl(vars) for package: MariaDB-server-10.4.18-1.el7.centos.x86_64
--> Processing Dependency: libaio.so.1()(64bit) for package: MariaDB-server-10.4.18-1.el7.centos.x86_64
--> Running transaction check
---> Package MariaDB-client.x86_64 0:10.4.18-1.el7.centos will be installed
--> Processing Dependency: perl(Exporter) for package: MariaDB-client-10.4.18-1.el7.centos.x86_64
---> Package MariaDB-common.x86_64 0:10.4.18-1.el7.centos will be installed
--> Processing Dependency: MariaDB-compat for package: MariaDB-common-10.4.18-1.el7.centos.x86_64
---> Package galera-4.x86_64 0:26.4.7-1.el7.centos will be installed
--> Processing Dependency: socat for package: galera-4-26.4.7-1.el7.centos.x86_64
--> Processing Dependency: libboost_program_options-mt.so.1.53.0()(64bit) for package: galera-4-26.4.7-1.el7.centos.x86_64
---> Package libaio.x86_64 0:0.3.109-13.el7 will be installed
---> Package lsof.x86_64 0:4.87-6.el7 will be installed
---> Package perl.x86_64 4:5.16.3-299.el7_9 will be installed
--> Processing Dependency: perl-libs = 4:5.16.3-299.el7_9 for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Socket) >= 1.3 for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Scalar::Util) >= 1.10 for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl-macros for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl-libs for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(threads::shared) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(threads) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(constant) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Time::Local) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Time::HiRes) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Storable) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Socket) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Scalar::Util) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Pod::Simple::XHTML) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Pod::Simple::Search) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Filter::Util::Call) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(File::Spec::Unix) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(File::Spec::Functions) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(File::Spec) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Cwd) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Carp) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: libperl.so()(64bit) for package: 4:perl-5.16.3-299.el7_9.x86_64
---> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed
--> Processing Dependency: perl(RPC::PlServer) >= 0.2001 for package: perl-DBI-1.627-4.el7.x86_64
--> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64
---> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed
---> Package perl-File-Path.noarch 0:2.09-2.el7 will be installed
---> Package perl-File-Temp.noarch 0:0.23.01-3.el7 will be installed
---> Package perl-Getopt-Long.noarch 0:2.40-3.el7 will be installed
--> Processing Dependency: perl(Pod::Usage) >= 1.14 for package: perl-Getopt-Long-2.40-3.el7.noarch
--> Processing Dependency: perl(Text::ParseWords) for package: perl-Getopt-Long-2.40-3.el7.noarch
--> Running transaction check
---> Package MariaDB-compat.x86_64 0:10.4.18-1.el7.centos will be obsoleting
---> Package boost-program-options.x86_64 0:1.53.0-28.el7 will be installed
---> Package mariadb-libs.x86_64 1:5.5.68-1.el7 will be obsoleted
---> Package perl-Carp.noarch 0:1.26-244.el7 will be installed
---> Package perl-Exporter.noarch 0:5.68-3.el7 will be installed
---> Package perl-Filter.x86_64 0:1.49-3.el7 will be installed
---> Package perl-PathTools.x86_64 0:3.40-5.el7 will be installed
---> Package perl-PlRPC.noarch 0:0.2020-14.el7 will be installed
--> Processing Dependency: perl(Net::Daemon) >= 0.13 for package: perl-PlRPC-0.2020-14.el7.noarch
--> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.el7.noarch
--> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.el7.noarch
--> Processing Dependency: perl(Compress::Zlib) for package: perl-PlRPC-0.2020-14.el7.noarch
---> Package perl-Pod-Simple.noarch 1:3.28-4.el7 will be installed
--> Processing Dependency: perl(Pod::Escapes) >= 1.04 for package: 1:perl-Pod-Simple-3.28-4.el7.noarch
--> Processing Dependency: perl(Encode) for package: 1:perl-Pod-Simple-3.28-4.el7.noarch
---> Package perl-Pod-Usage.noarch 0:1.63-3.el7 will be installed
--> Processing Dependency: perl(Pod::Text) >= 3.15 for package: perl-Pod-Usage-1.63-3.el7.noarch
--> Processing Dependency: perl-Pod-Perldoc for package: perl-Pod-Usage-1.63-3.el7.noarch
---> Package perl-Scalar-List-Utils.x86_64 0:1.27-248.el7 will be installed
---> Package perl-Socket.x86_64 0:2.010-5.el7 will be installed
---> Package perl-Storable.x86_64 0:2.45-3.el7 will be installed
---> Package perl-Text-ParseWords.noarch 0:3.29-4.el7 will be installed
---> Package perl-Time-HiRes.x86_64 4:1.9725-3.el7 will be installed
---> Package perl-Time-Local.noarch 0:1.2300-2.el7 will be installed
---> Package perl-constant.noarch 0:1.27-2.el7 will be installed
---> Package perl-libs.x86_64 4:5.16.3-299.el7_9 will be installed
---> Package perl-macros.x86_64 4:5.16.3-299.el7_9 will be installed
---> Package perl-threads.x86_64 0:1.87-4.el7 will be installed
---> Package perl-threads-shared.x86_64 0:1.43-6.el7 will be installed
---> Package socat.x86_64 0:1.7.3.2-2.el7 will be installed
--> Running transaction check
---> Package perl-Encode.x86_64 0:2.51-7.el7 will be installed
---> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed
--> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
--> Processing Dependency: perl(Compress::Raw::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
---> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed
---> Package perl-Pod-Escapes.noarch 1:1.04-299.el7_9 will be installed
---> Package perl-Pod-Perldoc.noarch 0:3.20-4.el7 will be installed
--> Processing Dependency: perl(parent) for package: perl-Pod-Perldoc-3.20-4.el7.noarch
--> Processing Dependency: perl(HTTP::Tiny) for package: perl-Pod-Perldoc-3.20-4.el7.noarch
---> Package perl-podlators.noarch 0:2.5.1-3.el7 will be installed
--> Running transaction check
---> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed
---> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed
---> Package perl-HTTP-Tiny.noarch 0:0.033-3.el7 will be installed
---> Package perl-parent.noarch 1:0.225-244.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================================================
 Package                         Arch           Version                        Repository       Size
=====================================================================================================
Installing:
 MariaDB-compat                  x86_64         10.4.18-1.el7.centos           mariadb         2.2 M
     replacing  mariadb-libs.x86_64 1:5.5.68-1.el7
 MariaDB-server                  x86_64         10.4.18-1.el7.centos           mariadb          26 M
Installing for dependencies:
 MariaDB-client                  x86_64         10.4.18-1.el7.centos           mariadb          12 M
 MariaDB-common                  x86_64         10.4.18-1.el7.centos           mariadb          81 k
 boost-program-options           x86_64         1.53.0-28.el7                  base            156 k
 galera-4                        x86_64         26.4.7-1.el7.centos            mariadb         9.1 M
 libaio                          x86_64         0.3.109-13.el7                 base             24 k
 lsof                            x86_64         4.87-6.el7                     base            331 k
 perl                            x86_64         4:5.16.3-299.el7_9             updates         8.0 M
 perl-Carp                       noarch         1.26-244.el7                   base             19 k
 perl-Compress-Raw-Bzip2         x86_64         2.061-3.el7                    base             32 k
 perl-Compress-Raw-Zlib          x86_64         1:2.061-4.el7                  base             57 k
 perl-DBI                        x86_64         1.627-4.el7                    base            802 k
 perl-Data-Dumper                x86_64         2.145-3.el7                    base             47 k
 perl-Encode                     x86_64         2.51-7.el7                     base            1.5 M
 perl-Exporter                   noarch         5.68-3.el7                     base             28 k
 perl-File-Path                  noarch         2.09-2.el7                     base             26 k
 perl-File-Temp                  noarch         0.23.01-3.el7                  base             56 k
 perl-Filter                     x86_64         1.49-3.el7                     base             76 k
 perl-Getopt-Long                noarch         2.40-3.el7                     base             56 k
 perl-HTTP-Tiny                  noarch         0.033-3.el7                    base             38 k
 perl-IO-Compress                noarch         2.061-2.el7                    base            260 k
 perl-Net-Daemon                 noarch         0.48-5.el7                     base             51 k
 perl-PathTools                  x86_64         3.40-5.el7                     base             82 k
 perl-PlRPC                      noarch         0.2020-14.el7                  base             36 k
 perl-Pod-Escapes                noarch         1:1.04-299.el7_9               updates          52 k
 perl-Pod-Perldoc                noarch         3.20-4.el7                     base             87 k
 perl-Pod-Simple                 noarch         1:3.28-4.el7                   base            216 k
 perl-Pod-Usage                  noarch         1.63-3.el7                     base             27 k
 perl-Scalar-List-Utils          x86_64         1.27-248.el7                   base             36 k
 perl-Socket                     x86_64         2.010-5.el7                    base             49 k
 perl-Storable                   x86_64         2.45-3.el7                     base             77 k
 perl-Text-ParseWords            noarch         3.29-4.el7                     base             14 k
 perl-Time-HiRes                 x86_64         4:1.9725-3.el7                 base             45 k
 perl-Time-Local                 noarch         1.2300-2.el7                   base             24 k
 perl-constant                   noarch         1.27-2.el7                     base             19 k
 perl-libs                       x86_64         4:5.16.3-299.el7_9             updates         690 k
 perl-macros                     x86_64         4:5.16.3-299.el7_9             updates          44 k
 perl-parent                     noarch         1:0.225-244.el7                base             12 k
 perl-podlators                  noarch         2.5.1-3.el7                    base            112 k
 perl-threads                    x86_64         1.87-4.el7                     base             49 k
 perl-threads-shared             x86_64         1.43-6.el7                     base             39 k
 socat                           x86_64         1.7.3.2-2.el7                  base            290 k

Transaction Summary
=====================================================================================================
Install  2 Packages (+41 Dependent packages)

Total download size: 62 M
Is this ok [y/d/N]: y
Downloading packages:
warning: /var/cache/yum/x86_64/7/mariadb/packages/MariaDB-common-10.4.18-1.el7.centos.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
Public key for MariaDB-common-10.4.18-1.el7.centos.x86_64.rpm is not installed
(1/43): MariaDB-common-10.4.18-1.el7.centos.x86_64.rpm                        |  81 kB  00:00:00
(2/43): MariaDB-compat-10.4.18-1.el7.centos.x86_64.rpm                        | 2.2 MB  00:00:00
(3/43): boost-program-options-1.53.0-28.el7.x86_64.rpm                        | 156 kB  00:00:00
(4/43): MariaDB-client-10.4.18-1.el7.centos.x86_64.rpm                        |  12 MB  00:00:02
(5/43): libaio-0.3.109-13.el7.x86_64.rpm                                      |  24 kB  00:00:00
(6/43): perl-Carp-1.26-244.el7.noarch.rpm                                     |  19 kB  00:00:00
(7/43): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm                        |  32 kB  00:00:00
(8/43): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm                         |  57 kB  00:00:00
(9/43): lsof-4.87-6.el7.x86_64.rpm                                            | 331 kB  00:00:00
(10/43): perl-Data-Dumper-2.145-3.el7.x86_64.rpm                              |  47 kB  00:00:00
(11/43): perl-DBI-1.627-4.el7.x86_64.rpm                                      | 802 kB  00:00:00
(12/43): perl-Exporter-5.68-3.el7.noarch.rpm                                  |  28 kB  00:00:00
(13/43): perl-File-Path-2.09-2.el7.noarch.rpm                                 |  26 kB  00:00:00
(14/43): perl-Encode-2.51-7.el7.x86_64.rpm                                    | 1.5 MB  00:00:00
(15/43): perl-File-Temp-0.23.01-3.el7.noarch.rpm                              |  56 kB  00:00:00
(16/43): perl-Filter-1.49-3.el7.x86_64.rpm                                    |  76 kB  00:00:00
(17/43): perl-Getopt-Long-2.40-3.el7.noarch.rpm                               |  56 kB  00:00:00
(18/43): perl-5.16.3-299.el7_9.x86_64.rpm                                     | 8.0 MB  00:00:00
(19/43): perl-HTTP-Tiny-0.033-3.el7.noarch.rpm                                |  38 kB  00:00:00
(20/43): perl-IO-Compress-2.061-2.el7.noarch.rpm                              | 260 kB  00:00:00
(21/43): perl-Net-Daemon-0.48-5.el7.noarch.rpm                                |  51 kB  00:00:00
(22/43): perl-PathTools-3.40-5.el7.x86_64.rpm                                 |  82 kB  00:00:00
(23/43): perl-PlRPC-0.2020-14.el7.noarch.rpm                                  |  36 kB  00:00:00
(24/43): perl-Pod-Perldoc-3.20-4.el7.noarch.rpm                               |  87 kB  00:00:00
(25/43): perl-Pod-Simple-3.28-4.el7.noarch.rpm                                | 216 kB  00:00:00
(26/43): perl-Scalar-List-Utils-1.27-248.el7.x86_64.rpm                       |  36 kB  00:00:00
(27/43): perl-Pod-Usage-1.63-3.el7.noarch.rpm                                 |  27 kB  00:00:00
(28/43): perl-Socket-2.010-5.el7.x86_64.rpm                                   |  49 kB  00:00:00
(29/43): perl-Storable-2.45-3.el7.x86_64.rpm                                  |  77 kB  00:00:00
(30/43): perl-Text-ParseWords-3.29-4.el7.noarch.rpm                           |  14 kB  00:00:00
(31/43): perl-Pod-Escapes-1.04-299.el7_9.noarch.rpm                           |  52 kB  00:00:00
(32/43): perl-Time-HiRes-1.9725-3.el7.x86_64.rpm                              |  45 kB  00:00:00
(33/43): perl-Time-Local-1.2300-2.el7.noarch.rpm                              |  24 kB  00:00:00
(34/43): perl-constant-1.27-2.el7.noarch.rpm                                  |  19 kB  00:00:00
(35/43): perl-macros-5.16.3-299.el7_9.x86_64.rpm                              |  44 kB  00:00:00
(36/43): perl-parent-0.225-244.el7.noarch.rpm                                 |  12 kB  00:00:00
(37/43): perl-podlators-2.5.1-3.el7.noarch.rpm                                | 112 kB  00:00:00
(38/43): perl-threads-shared-1.43-6.el7.x86_64.rpm                            |  39 kB  00:00:00
(39/43): perl-threads-1.87-4.el7.x86_64.rpm                                   |  49 kB  00:00:00
(40/43): socat-1.7.3.2-2.el7.x86_64.rpm                                       | 290 kB  00:00:00
(41/43): galera-4-26.4.7-1.el7.centos.x86_64.rpm                              | 9.1 MB  00:00:01
(42/43): perl-libs-5.16.3-299.el7_9.x86_64.rpm                                | 690 kB  00:00:00
(43/43): MariaDB-server-10.4.18-1.el7.centos.x86_64.rpm                       |  26 MB  00:00:03
-----------------------------------------------------------------------------------------------------
Total                                                                 13 MB/s |  62 MB  00:00:04
Retrieving key from https://mirror.yongbok.net/mariadb/yum/RPM-GPG-KEY-MariaDB
Importing GPG key 0x1BB943DB:
 Userid     : "MariaDB Package Signing Key <package-signing-key@mariadb.org>"
 Fingerprint: 1993 69e5 404b d5fc 7d2f e43b cbcb 082a 1bb9 43db
 From       : https://mirror.yongbok.net/mariadb/yum/RPM-GPG-KEY-MariaDB
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : libaio-0.3.109-13.el7.x86_64                                                     1/44
  Installing : lsof-4.87-6.el7.x86_64                                                           2/44
  Installing : MariaDB-common-10.4.18-1.el7.centos.x86_64                                       3/44
  Installing : MariaDB-compat-10.4.18-1.el7.centos.x86_64                                       4/44
  Installing : 1:perl-parent-0.225-244.el7.noarch                                               5/44
  Installing : perl-HTTP-Tiny-0.033-3.el7.noarch                                                6/44
  Installing : perl-podlators-2.5.1-3.el7.noarch                                                7/44
  Installing : perl-Pod-Perldoc-3.20-4.el7.noarch                                               8/44
  Installing : 1:perl-Pod-Escapes-1.04-299.el7_9.noarch                                         9/44
  Installing : perl-Encode-2.51-7.el7.x86_64                                                   10/44
  Installing : perl-Text-ParseWords-3.29-4.el7.noarch                                          11/44
  Installing : perl-Pod-Usage-1.63-3.el7.noarch                                                12/44
  Installing : 4:perl-macros-5.16.3-299.el7_9.x86_64                                           13/44
  Installing : 4:perl-Time-HiRes-1.9725-3.el7.x86_64                                           14/44
  Installing : perl-Exporter-5.68-3.el7.noarch                                                 15/44
  Installing : perl-constant-1.27-2.el7.noarch                                                 16/44
  Installing : perl-Socket-2.010-5.el7.x86_64                                                  17/44
  Installing : perl-Time-Local-1.2300-2.el7.noarch                                             18/44
  Installing : perl-Carp-1.26-244.el7.noarch                                                   19/44
  Installing : perl-Storable-2.45-3.el7.x86_64                                                 20/44
  Installing : perl-PathTools-3.40-5.el7.x86_64                                                21/44
  Installing : perl-Scalar-List-Utils-1.27-248.el7.x86_64                                      22/44
  Installing : 1:perl-Pod-Simple-3.28-4.el7.noarch                                             23/44
  Installing : perl-File-Temp-0.23.01-3.el7.noarch                                             24/44
  Installing : perl-File-Path-2.09-2.el7.noarch                                                25/44
  Installing : perl-threads-shared-1.43-6.el7.x86_64                                           26/44
  Installing : perl-threads-1.87-4.el7.x86_64                                                  27/44
  Installing : perl-Filter-1.49-3.el7.x86_64                                                   28/44
  Installing : 4:perl-libs-5.16.3-299.el7_9.x86_64                                             29/44
  Installing : perl-Getopt-Long-2.40-3.el7.noarch                                              30/44
  Installing : 4:perl-5.16.3-299.el7_9.x86_64                                                  31/44
  Installing : perl-Data-Dumper-2.145-3.el7.x86_64                                             32/44
  Installing : MariaDB-client-10.4.18-1.el7.centos.x86_64                                      33/44
  Installing : perl-Net-Daemon-0.48-5.el7.noarch                                               34/44
  Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                                      35/44
  Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                                     36/44
  Installing : perl-IO-Compress-2.061-2.el7.noarch                                             37/44
  Installing : perl-PlRPC-0.2020-14.el7.noarch                                                 38/44
  Installing : perl-DBI-1.627-4.el7.x86_64                                                     39/44
  Installing : socat-1.7.3.2-2.el7.x86_64                                                      40/44
  Installing : boost-program-options-1.53.0-28.el7.x86_64                                      41/44
  Installing : galera-4-26.4.7-1.el7.centos.x86_64                                             42/44
  Installing : MariaDB-server-10.4.18-1.el7.centos.x86_64                                      43/44


Two all-privilege accounts were created.
One is root@localhost, it has no password, but you need to
be system 'root' user to connect. Use, for example, sudo mysql
The second is mysql@localhost, it has no password either, but
you need to be the system 'mysql' user to connect.
After connecting you can set the password, if you would need to be
able to connect as any of these users with a password and without sudo

See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.

Please report any problems at http://mariadb.org/jira

The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/

  Erasing    : 1:mariadb-libs-5.5.68-1.el7.x86_64                                              44/44
  Verifying  : perl-HTTP-Tiny-0.033-3.el7.noarch                                                1/44
  Verifying  : boost-program-options-1.53.0-28.el7.x86_64                                       2/44
  Verifying  : perl-threads-shared-1.43-6.el7.x86_64                                            3/44
  Verifying  : 4:perl-Time-HiRes-1.9725-3.el7.x86_64                                            4/44
  Verifying  : lsof-4.87-6.el7.x86_64                                                           5/44
  Verifying  : perl-Exporter-5.68-3.el7.noarch                                                  6/44
  Verifying  : perl-constant-1.27-2.el7.noarch                                                  7/44
  Verifying  : perl-PathTools-3.40-5.el7.x86_64                                                 8/44
  Verifying  : MariaDB-client-10.4.18-1.el7.centos.x86_64                                       9/44
  Verifying  : 4:perl-macros-5.16.3-299.el7_9.x86_64                                           10/44
  Verifying  : MariaDB-compat-10.4.18-1.el7.centos.x86_64                                      11/44
  Verifying  : 1:perl-parent-0.225-244.el7.noarch                                              12/44
  Verifying  : perl-Socket-2.010-5.el7.x86_64                                                  13/44
  Verifying  : perl-Net-Daemon-0.48-5.el7.noarch                                               14/44
  Verifying  : perl-Pod-Usage-1.63-3.el7.noarch                                                15/44
  Verifying  : perl-File-Temp-0.23.01-3.el7.noarch                                             16/44
  Verifying  : 1:perl-Pod-Simple-3.28-4.el7.noarch                                             17/44
  Verifying  : perl-Time-Local-1.2300-2.el7.noarch                                             18/44
  Verifying  : 1:perl-Pod-Escapes-1.04-299.el7_9.noarch                                        19/44
  Verifying  : perl-DBI-1.627-4.el7.x86_64                                                     20/44
  Verifying  : libaio-0.3.109-13.el7.x86_64                                                    21/44
  Verifying  : perl-Carp-1.26-244.el7.noarch                                                   22/44
  Verifying  : perl-Data-Dumper-2.145-3.el7.x86_64                                             23/44
  Verifying  : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                                      24/44
  Verifying  : perl-Storable-2.45-3.el7.x86_64                                                 25/44
  Verifying  : perl-Scalar-List-Utils-1.27-248.el7.x86_64                                      26/44
  Verifying  : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                                     27/44
  Verifying  : MariaDB-common-10.4.18-1.el7.centos.x86_64                                      28/44
  Verifying  : perl-IO-Compress-2.061-2.el7.noarch                                             29/44
  Verifying  : galera-4-26.4.7-1.el7.centos.x86_64                                             30/44
  Verifying  : perl-PlRPC-0.2020-14.el7.noarch                                                 31/44
  Verifying  : perl-Encode-2.51-7.el7.x86_64                                                   32/44
  Verifying  : perl-Pod-Perldoc-3.20-4.el7.noarch                                              33/44
  Verifying  : perl-podlators-2.5.1-3.el7.noarch                                               34/44
  Verifying  : MariaDB-server-10.4.18-1.el7.centos.x86_64                                      35/44
  Verifying  : 4:perl-5.16.3-299.el7_9.x86_64                                                  36/44
  Verifying  : perl-File-Path-2.09-2.el7.noarch                                                37/44
  Verifying  : perl-threads-1.87-4.el7.x86_64                                                  38/44
  Verifying  : perl-Filter-1.49-3.el7.x86_64                                                   39/44
  Verifying  : perl-Getopt-Long-2.40-3.el7.noarch                                              40/44
  Verifying  : perl-Text-ParseWords-3.29-4.el7.noarch                                          41/44
  Verifying  : 4:perl-libs-5.16.3-299.el7_9.x86_64                                             42/44
  Verifying  : socat-1.7.3.2-2.el7.x86_64                                                      43/44
  Verifying  : 1:mariadb-libs-5.5.68-1.el7.x86_64                                              44/44

Installed:
  MariaDB-compat.x86_64 0:10.4.18-1.el7.centos      MariaDB-server.x86_64 0:10.4.18-1.el7.centos

Dependency Installed:
  MariaDB-client.x86_64 0:10.4.18-1.el7.centos      MariaDB-common.x86_64 0:10.4.18-1.el7.centos
  boost-program-options.x86_64 0:1.53.0-28.el7      galera-4.x86_64 0:26.4.7-1.el7.centos
  libaio.x86_64 0:0.3.109-13.el7                    lsof.x86_64 0:4.87-6.el7
  perl.x86_64 4:5.16.3-299.el7_9                    perl-Carp.noarch 0:1.26-244.el7
  perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7      perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7
  perl-DBI.x86_64 0:1.627-4.el7                     perl-Data-Dumper.x86_64 0:2.145-3.el7
  perl-Encode.x86_64 0:2.51-7.el7                   perl-Exporter.noarch 0:5.68-3.el7
  perl-File-Path.noarch 0:2.09-2.el7                perl-File-Temp.noarch 0:0.23.01-3.el7
  perl-Filter.x86_64 0:1.49-3.el7                   perl-Getopt-Long.noarch 0:2.40-3.el7
  perl-HTTP-Tiny.noarch 0:0.033-3.el7               perl-IO-Compress.noarch 0:2.061-2.el7
  perl-Net-Daemon.noarch 0:0.48-5.el7               perl-PathTools.x86_64 0:3.40-5.el7
  perl-PlRPC.noarch 0:0.2020-14.el7                 perl-Pod-Escapes.noarch 1:1.04-299.el7_9
  perl-Pod-Perldoc.noarch 0:3.20-4.el7              perl-Pod-Simple.noarch 1:3.28-4.el7
  perl-Pod-Usage.noarch 0:1.63-3.el7                perl-Scalar-List-Utils.x86_64 0:1.27-248.el7
  perl-Socket.x86_64 0:2.010-5.el7                  perl-Storable.x86_64 0:2.45-3.el7
  perl-Text-ParseWords.noarch 0:3.29-4.el7          perl-Time-HiRes.x86_64 4:1.9725-3.el7
  perl-Time-Local.noarch 0:1.2300-2.el7             perl-constant.noarch 0:1.27-2.el7
  perl-libs.x86_64 4:5.16.3-299.el7_9               perl-macros.x86_64 4:5.16.3-299.el7_9
  perl-parent.noarch 1:0.225-244.el7                perl-podlators.noarch 0:2.5.1-3.el7
  perl-threads.x86_64 0:1.87-4.el7                  perl-threads-shared.x86_64 0:1.43-6.el7
  socat.x86_64 0:1.7.3.2-2.el7

Replaced:
  mariadb-libs.x86_64 1:5.5.68-1.el7

Complete!
[root@webpress /]#

 

정상적으로 설치되었다면 mariadb 데몬을 가동시킨 후 실행해보자.

[root@webpress /]# systemctl start mariadb
[root@webpress /]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 10.4.18-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

 

그리고 지난번 글에서와 마찬가지로 10.4 이후버전 부터 새로바뀐 로그인 정책을 그대로 사용해 보기로 했다. 예전 방식의 로그인 암호입력과 원격접속이 필요하다면 전에 작성했던 글을 참고하자.

2020.06.04 - [Linux/APM] - [CentOS7] MariaDB 10.4 설치, 비밀번호 변경, 포트변경, 원격접속

 

[CentOS7] MariaDB 10.4 설치, 비밀번호 변경, 포트변경, 원격접속

[MariaDB 10.4] 설치, 비밀번호 변경, 포트변경, 원격접속 대략 3개월 이상 방치하고 있는 서버가 한 대 있다. 몇 가지 테스트 해 볼 것들이 생겨서 bind와 httpd, php, mariadb를 다시 설치하고 테스트

aegypius.tistory.com

 

728x90
반응형

댓글