CentOS7 MariaDB 설치 편집하기

{{다른뜻|CentOS6 MariaDB 설치}}
{{다른뜻|우분투 MariaDB 설치}}
==개요==
{{테스트|CentOS 7.6}}
;리눅스 MariaDB 설치
;CentOS MariaDB 설치 

==repo 설정==
<source lang='console'>
[root@zabbix1 ~]# vi /etc/yum.repos.d/MariaDB.repo
</source>
<source lang='ini'>
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.4/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
</source>

==설치==
<source lang='console'>
[root@zetawiki ~]# yum install MariaDB-server
</source>
<source lang='console'>
===========================================================================================
 Package                     Arch       Version                          Repository   Size
===========================================================================================
Installing:
 MariaDB-client              x86_64     10.1.30-1.el7.centos             mariadb      39 M
 MariaDB-server              x86_64     10.1.30-1.el7.centos             mariadb     104 M
 MariaDB-shared              x86_64     10.1.30-1.el7.centos             mariadb     1.3 M
     replacing  mariadb-libs.x86_64 1:5.5.47-1.el7_2
Installing for dependencies:
 MariaDB-common              x86_64     10.1.30-1.el7.centos             mariadb     123 k
 boost-program-options       x86_64     1.53.0-27.el7                    base        156 k
 galera                      x86_64     25.3.22-1.rhel7.el7.centos       mariadb     8.0 M
 jemalloc                    x86_64     3.6.0-1.el7                      epel        105 k
 lsof                        x86_64     4.87-4.el7                       base        331 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-IO-Compress            noarch     2.061-2.el7                      base        260 k
 perl-Net-Daemon             noarch     0.48-5.el7                       base         51 k
 perl-PlRPC                  noarch     0.2020-14.el7                    base         36 k

Transaction Summary
===========================================================================================
Install  3 Packages (+12 Dependent packages)

Total download size: 155 M
Is this ok [y/d/N]: y
</source>
<source lang='console'>
... (생략)
Installed:
  MariaDB-client.x86_64 0:10.1.30-1.el7.centos                                             
  MariaDB-server.x86_64 0:10.1.30-1.el7.centos                                             
  MariaDB-shared.x86_64 0:10.1.30-1.el7.centos                                             

Dependency Installed:
  MariaDB-common.x86_64 0:10.1.30-1.el7.centos                                             
  boost-program-options.x86_64 0:1.53.0-27.el7                                             
  galera.x86_64 0:25.3.22-1.rhel7.el7.centos                                               
  jemalloc.x86_64 0:3.6.0-1.el7                                                            
  lsof.x86_64 0:4.87-4.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-IO-Compress.noarch 0:2.061-2.el7                                                    
  perl-Net-Daemon.noarch 0:0.48-5.el7                                                      
  perl-PlRPC.noarch 0:0.2020-14.el7                                                        

Replaced:
  mariadb-libs.x86_64 1:5.5.47-1.el7_2                                                     

Complete!
</source>

==확인 ==
<source lang='console'>
[root@zetawiki ~]# rpm -qa | grep MariaDB
MariaDB-compat-10.4.5-1.el7.centos.x86_64
MariaDB-client-10.4.5-1.el7.centos.x86_64
MariaDB-common-10.4.5-1.el7.centos.x86_64
MariaDB-server-10.4.5-1.el7.centos.x86_64
</source>

==DB 시작 / 패스워드 변경==
아까 나왔던 안내대로 DB를 시작하고 패스워드를 바꾼다.
<source lang='console'>
[root@zetawiki ~]# systemctl start mariadb
[root@zetawiki ~]# /usr/bin/mysqladmin -u root password 'P@ssw0rd'
[root@zetawiki ~]# 
</source>
<source lang='console'>
[root@zetawiki ~]# netstat -anp | grep 3306
tcp6       0      0 :::3306                 :::*                    LISTEN      3479/mysqld         
</source>
:포트는 3306, 데몬이름은 mysqld이다.

==접속 확인==
<source lang='console'>
[root@zetawiki ~]# mysql -u root -p
Enter password: P@ssw0rd
</source>
<source lang='console'>
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 5
Server version: 10.1.30-MariaDB MariaDB Server

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

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

MariaDB [(none)]> quit
Bye
[root@zetawiki ~]# 
</source>

==부팅시 자동시작 설정 확인==
기본으로 설정되어 있지만 한번 더 확인
<source lang='console'>
[root@zabbix1 ~]# systemctl is-enabled mariadb

enabled
</source>

==같이 보기==
* [[CentOS6 MariaDB 설치]]
* [[우분투 MariaDB 설치]]
* [[리눅스 MySQL 설치]]
* [[MariaDB]]

==참고==
*https://mariadb.com/kb/en/installing-mariadb-with-yum/

[[분류: MariaDB]]
[[분류: yum install]]
[[분류: CentOS]]
[[분류: CentOS 7]]