잔글 (→부팅시 자동시작 설정 확인) |
|||
| (사용자 6명의 중간 판 16개는 보이지 않습니다) | |||
| 1번째 줄: | 1번째 줄: | ||
{{다른뜻|CentOS6 MariaDB 설치}} | {{다른뜻|CentOS6 MariaDB 설치}} | ||
{{다른뜻|우분투 MariaDB 설치}} | {{다른뜻|우분투 MariaDB 설치}} | ||
==개요== | |||
{{테스트|CentOS 7.6}} | |||
;리눅스 MariaDB 설치 | ;리눅스 MariaDB 설치 | ||
;CentOS MariaDB 설치 | ;CentOS MariaDB 설치 | ||
| 11번째 줄: | 13번째 줄: | ||
[mariadb] | [mariadb] | ||
name = MariaDB | name = MariaDB | ||
baseurl = http://yum.mariadb.org/10. | baseurl = http://yum.mariadb.org/10.4/centos7-amd64 | ||
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB | gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB | ||
gpgcheck=1 | gpgcheck=1 | ||
| 18번째 줄: | 20번째 줄: | ||
==설치== | ==설치== | ||
<source lang='console'> | <source lang='console'> | ||
=========================================================================================== | [root@zetawiki ~]# yum install MariaDB | ||
Package | ... (생략) | ||
=========================================================================================== | ============================================================================================= | ||
Package Arch Version Repository Size | |||
============================================================================================= | |||
Installing: | Installing: | ||
MariaDB- | MariaDB-server x86_64 10.4.5-1.el7.centos mariadb 25 M | ||
Installing for dependencies: | Installing for dependencies: | ||
MariaDB-common | MariaDB-client x86_64 10.4.5-1.el7.centos mariadb 12 M | ||
boost-program-options | MariaDB-common x86_64 10.4.5-1.el7.centos mariadb 81 k | ||
galera | MariaDB-compat x86_64 10.4.5-1.el7.centos mariadb 2.8 M | ||
boost-program-options x86_64 1.53.0-27.el7 base 156 k | |||
lsof | galera-4 x86_64 26.4.2-1.rhel7.el7.centos mariadb 9.4 M | ||
perl-Compress-Raw-Bzip2 | groff-base x86_64 1.22.2-8.el7 base 942 k | ||
perl-Compress-Raw-Zlib | iproute x86_64 4.11.0-14.el7_6.2 updates 764 k | ||
perl-DBI | iptables x86_64 1.4.21-28.el7 base 433 k | ||
perl-Data-Dumper | libaio x86_64 0.3.109-13.el7 base 24 k | ||
perl-IO-Compress | libmnl x86_64 1.0.3-7.el7 base 23 k | ||
perl-Net-Daemon | libnetfilter_conntrack x86_64 1.0.6-1.el7_3 base 55 k | ||
perl-PlRPC | libnfnetlink x86_64 1.0.1-4.el7 base 26 k | ||
lsof x86_64 4.87-6.el7 base 331 k | |||
make x86_64 1:3.82-23.el7 base 420 k | |||
openssl x86_64 1:1.0.2k-16.el7_6.1 updates 493 k | |||
perl x86_64 4:5.16.3-294.el7_6 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-294.el7_6 updates 51 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-4.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-294.el7_6 updates 688 k | |||
perl-macros x86_64 4:5.16.3-294.el7_6 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 | |||
rsync x86_64 3.1.2-6.el7_6.1 updates 404 k | |||
Updating for dependencies: | |||
openssl-libs x86_64 1:1.0.2k-16.el7_6.1 updates 1.2 M | |||
Transaction Summary | Transaction Summary | ||
=========================================================================================== | ============================================================================================= | ||
Install | Install 1 Package (+50 Dependent packages) | ||
Upgrade ( 1 Dependent package) | |||
Total download size: | Total download size: 67 M | ||
Is this ok [y/d/N]: y | Is this ok [y/d/N]: y | ||
</source> | </source> | ||
| 50번째 줄: | 92번째 줄: | ||
... (생략) | ... (생략) | ||
Installed: | Installed: | ||
MariaDB-server.x86_64 0:10.4.5-1.el7.centos | |||
MariaDB-server.x86_64 0:10. | |||
Dependency Installed: | Dependency Installed: | ||
MariaDB-common.x86_64 0:10.1. | MariaDB-client.x86_64 0:10.4.5-1.el7.centos MariaDB-common.x86_64 0:10.4.5-1.el7.centos | ||
boost-program-options.x86_64 0:1.53.0-27.el7 | MariaDB-compat.x86_64 0:10.4.5-1.el7.centos boost-program-options.x86_64 0:1.53.0-27.el7 | ||
galera.x86_64 0: | galera-4.x86_64 0:26.4.2-1.rhel7.el7.centos groff-base.x86_64 0:1.22.2-8.el7 | ||
iproute.x86_64 0:4.11.0-14.el7_6.2 iptables.x86_64 0:1.4.21-28.el7 | |||
lsof.x86_64 0:4.87-4. | libaio.x86_64 0:0.3.109-13.el7 libmnl.x86_64 0:1.0.3-7.el7 | ||
perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 | libnetfilter_conntrack.x86_64 0:1.0.6-1.el7_3 libnfnetlink.x86_64 0:1.0.1-4.el7 | ||
perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 | lsof.x86_64 0:4.87-6.el7 make.x86_64 1:3.82-23.el7 | ||
perl-DBI.x86_64 0:1.627-4.el7 | openssl.x86_64 1:1.0.2k-16.el7_6.1 perl.x86_64 4:5.16.3-294.el7_6 | ||
perl-Data-Dumper.x86_64 0:2.145-3.el7 | perl-Carp.noarch 0:1.26-244.el7 perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 | ||
perl-IO-Compress.noarch 0:2.061-2.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-PlRPC.noarch 0:0.2020-14.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-294.el7_6 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-4.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-294.el7_6 | |||
perl-macros.x86_64 4:5.16.3-294.el7_6 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 rsync.x86_64 0:3.1.2-6.el7_6.1 | |||
Dependency Updated: | |||
openssl-libs.x86_64 1:1.0.2k-16.el7_6.1 | |||
Complete! | Complete! | ||
</source> | </source> | ||
==확인 | ==확인 == | ||
<source lang='console'> | <source lang='console'> | ||
[root@zetawiki ~]# rpm -qa | grep MariaDB | [root@zetawiki ~]# rpm -qa | grep MariaDB | ||
MariaDB- | MariaDB-compat-10.4.5-1.el7.centos.x86_64 | ||
MariaDB- | MariaDB-client-10.4.5-1.el7.centos.x86_64 | ||
MariaDB- | MariaDB-common-10.4.5-1.el7.centos.x86_64 | ||
MariaDB- | MariaDB-server-10.4.5-1.el7.centos.x86_64 | ||
</source> | </source> | ||
| 86번째 줄: | 139번째 줄: | ||
아까 나왔던 안내대로 DB를 시작하고 패스워드를 바꾼다. | 아까 나왔던 안내대로 DB를 시작하고 패스워드를 바꾼다. | ||
<source lang='console'> | <source lang='console'> | ||
[root@ | [root@zetawiki ~]# systemctl start mariadb | ||
[root@zetawiki ~]# /usr/bin/mysqladmin -u root password 'P@ssw0rd' | [root@zetawiki ~]# /usr/bin/mysqladmin -u root password 'P@ssw0rd' | ||
[root@ | [root@zetawiki ~]# | ||
</source> | </source> | ||
<source lang='console'> | <source lang='console'> | ||
| 118번째 줄: | 171번째 줄: | ||
기본으로 설정되어 있지만 한번 더 확인 | 기본으로 설정되어 있지만 한번 더 확인 | ||
<source lang='console'> | <source lang='console'> | ||
[root@zabbix1 ~]# | [root@zabbix1 ~]# systemctl is-enabled mariadb | ||
enabled | |||
</source> | </source> | ||
2020년 2월 4일 (화) 21:44 기준 최신판
- 다른 뜻에 대해서는 CentOS6 MariaDB 설치 문서를 참조하십시오.
- 다른 뜻에 대해서는 우분투 MariaDB 설치 문서를 참조하십시오.
1 개요[ | ]
✔️ CentOS 7.6에서 테스트하였습니다.
- 리눅스 MariaDB 설치
- CentOS MariaDB 설치
2 repo 설정[ | ]
[root@zabbix1 ~]# vi /etc/yum.repos.d/MariaDB.repo
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.4/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
3 설치[ | ]
[root@zetawiki ~]# yum install MariaDB
... (생략)
=============================================================================================
Package Arch Version Repository Size
=============================================================================================
Installing:
MariaDB-server x86_64 10.4.5-1.el7.centos mariadb 25 M
Installing for dependencies:
MariaDB-client x86_64 10.4.5-1.el7.centos mariadb 12 M
MariaDB-common x86_64 10.4.5-1.el7.centos mariadb 81 k
MariaDB-compat x86_64 10.4.5-1.el7.centos mariadb 2.8 M
boost-program-options x86_64 1.53.0-27.el7 base 156 k
galera-4 x86_64 26.4.2-1.rhel7.el7.centos mariadb 9.4 M
groff-base x86_64 1.22.2-8.el7 base 942 k
iproute x86_64 4.11.0-14.el7_6.2 updates 764 k
iptables x86_64 1.4.21-28.el7 base 433 k
libaio x86_64 0.3.109-13.el7 base 24 k
libmnl x86_64 1.0.3-7.el7 base 23 k
libnetfilter_conntrack x86_64 1.0.6-1.el7_3 base 55 k
libnfnetlink x86_64 1.0.1-4.el7 base 26 k
lsof x86_64 4.87-6.el7 base 331 k
make x86_64 1:3.82-23.el7 base 420 k
openssl x86_64 1:1.0.2k-16.el7_6.1 updates 493 k
perl x86_64 4:5.16.3-294.el7_6 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-294.el7_6 updates 51 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-4.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-294.el7_6 updates 688 k
perl-macros x86_64 4:5.16.3-294.el7_6 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
rsync x86_64 3.1.2-6.el7_6.1 updates 404 k
Updating for dependencies:
openssl-libs x86_64 1:1.0.2k-16.el7_6.1 updates 1.2 M
Transaction Summary
=============================================================================================
Install 1 Package (+50 Dependent packages)
Upgrade ( 1 Dependent package)
Total download size: 67 M
Is this ok [y/d/N]: y
... (생략)
Installed:
MariaDB-server.x86_64 0:10.4.5-1.el7.centos
Dependency Installed:
MariaDB-client.x86_64 0:10.4.5-1.el7.centos MariaDB-common.x86_64 0:10.4.5-1.el7.centos
MariaDB-compat.x86_64 0:10.4.5-1.el7.centos boost-program-options.x86_64 0:1.53.0-27.el7
galera-4.x86_64 0:26.4.2-1.rhel7.el7.centos groff-base.x86_64 0:1.22.2-8.el7
iproute.x86_64 0:4.11.0-14.el7_6.2 iptables.x86_64 0:1.4.21-28.el7
libaio.x86_64 0:0.3.109-13.el7 libmnl.x86_64 0:1.0.3-7.el7
libnetfilter_conntrack.x86_64 0:1.0.6-1.el7_3 libnfnetlink.x86_64 0:1.0.1-4.el7
lsof.x86_64 0:4.87-6.el7 make.x86_64 1:3.82-23.el7
openssl.x86_64 1:1.0.2k-16.el7_6.1 perl.x86_64 4:5.16.3-294.el7_6
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-294.el7_6 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-4.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-294.el7_6
perl-macros.x86_64 4:5.16.3-294.el7_6 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 rsync.x86_64 0:3.1.2-6.el7_6.1
Dependency Updated:
openssl-libs.x86_64 1:1.0.2k-16.el7_6.1
Complete!
4 확인[ | ]
[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
5 DB 시작 / 패스워드 변경[ | ]
아까 나왔던 안내대로 DB를 시작하고 패스워드를 바꾼다.
[root@zetawiki ~]# systemctl start mariadb
[root@zetawiki ~]# /usr/bin/mysqladmin -u root password 'P@ssw0rd'
[root@zetawiki ~]#
[root@zetawiki ~]# netstat -anp | grep 3306
tcp6 0 0 :::3306 :::* LISTEN 3479/mysqld
- 포트는 3306, 데몬이름은 mysqld이다.
6 접속 확인[ | ]
[root@zetawiki ~]# mysql -u root -p
Enter password: P@ssw0rd
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 ~]#
7 부팅시 자동시작 설정 확인[ | ]
기본으로 설정되어 있지만 한번 더 확인
[root@zabbix1 ~]# systemctl is-enabled mariadb
enabled
8 같이 보기[ | ]
9 참고[ | ]
로그인하시면 댓글을 쓸 수 있습니다.
{{ comment.name }}
{{ comment.created | snstime }}
-
{{comment.page_title}} ―{{comment.name}}