반응형
1. 확인
[root@goni9071 ~]# rpm -qa | grep MariaDB |
2. 저장소 추가
[root@goni9071 ~]# vi /etc/yum.repos.d/MariaDB.repo |
[mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.2/centos6-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 |
2-1. 저장소 확인
[root@goni9071 ~]# yum repolist |
repo id repo name status HP-mcp HP Management Component Pack for ProLiant 5 HP-spp HP Service Pack for ProLiant 1,335 base CentOS-6 - Base 6,704+9 epel Extra Packages for Enterprise Linux 6 - x86_64 12,497 extras CentOS-6 - Extras 33 mariadb MariaDB 59 rpmforge RHEL 6 - RPMforge.net - dag 4,717+1 updates CentOS-6 - Updates 198+27 repolist: 25,548 |
3. 설치
[root@goni9071 ~]# yum install MariaDB-server |
Dependencies Resolved ================================================================================================================================== Package Arch Version Repository Size ================================================================================================================================== Installing: MariaDB-server x86_64 10.2.18-1.el6 mariadb 111 M Installing for dependencies: MariaDB-client x86_64 10.2.18-1.el6 mariadb 48 M MariaDB-common x86_64 10.2.18-1.el6 mariadb 154 k MariaDB-compat x86_64 10.2.18-1.el6 mariadb 4.0 M boost-program-options x86_64 1.41.0-28.el6 base 108 k galera x86_64 25.3.24-1.rhel6.el6 mariadb 8.8 M libaio x86_64 0.3.107-10.el6 base 21 k perl-DBI x86_64 1.609-4.el6 base 705 k Transaction Summary ================================================================================================================================== Install 8 Package(s) Total download size: 173 M Installed size: 730 M Is this ok [y/N]: |
Downloading Packages: (1/8): MariaDB-10.2.18-centos6-x86_64-client.rpm | 48 MB 00:30 (2/8): MariaDB-10.2.18-centos6-x86_64-common.rpm | 154 kB 00:00 (3/8): MariaDB-10.2.18-centos6-x86_64-compat.rpm | 4.0 MB 00:01 (4/8): MariaDB-10.2.18-centos6-x86_64-server.rpm | 111 MB 00:36 (5/8): boost-program-options-1.41.0-28.el6.x86_64.rpm | 108 kB 00:00 (6/8): galera-25.3.24-1.rhel6.el6.x86_64.rpm | 8.8 MB 00:06 (7/8): libaio-0.3.107-10.el6.x86_64.rpm | 21 kB 00:00 (8/8): perl-DBI-1.609-4.el6.x86_64.rpm | 705 kB 00:00 ---------------------------------------------------------------------------------------------------------------------------------- Total 2.2 MB/s | 173 MB 01:17 warning: rpmts_HdrFromFdno: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY Retrieving key from https://yum.mariadb.org/RPM-GPG-KEY-MariaDB Importing GPG key 0x1BB943DB: Userid: "MariaDB Package Signing Key <package-signing-key@mariadb.org>" From : https://yum.mariadb.org/RPM-GPG-KEY-MariaDB Is this ok [y/N]: |
Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Warning: RPMDB altered outside of yum. ** Found 2 pre-existing rpmdb problem(s), 'yum check' output follows: kernel-firmware-2.6.32-754.3.5.el6.noarch is a duplicate with kernel-firmware-2.6.32-642.15.1.el6.noarch kernel-headers-2.6.32-754.3.5.el6.x86_64 is a duplicate with kernel-headers-2.6.32-642.15.1.el6.x86_64 Installing : MariaDB-compat-10.2.18-1.el6.x86_64 1/8 Installing : MariaDB-common-10.2.18-1.el6.x86_64 2/8 warning: /etc/my.cnf created as /etc/my.cnf.rpmnew Installing : libaio-0.3.107-10.el6.x86_64 3/8 Installing : MariaDB-client-10.2.18-1.el6.x86_64 4/8 Installing : boost-program-options-1.41.0-28.el6.x86_64 5/8 Installing : galera-25.3.24-1.rhel6.el6.x86_64 6/8 Installing : perl-DBI-1.609-4.el6.x86_64 7/8 Installing : MariaDB-server-10.2.18-1.el6.x86_64 8/8 chown: cannot access `/var/lib/mysql': No such file or directory PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER ! To do so, start the server, then issue the following commands: '/usr/bin/mysqladmin' -u root password 'new-password' '/usr/bin/mysqladmin' -u root -h password 'new-password' Alternatively you can run: '/usr/bin/mysql_secure_installation' which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. 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/ Verifying : perl-DBI-1.609-4.el6.x86_64 1/8 Verifying : MariaDB-server-10.2.18-1.el6.x86_64 2/8 Verifying : MariaDB-common-10.2.18-1.el6.x86_64 3/8 Verifying : galera-25.3.24-1.rhel6.el6.x86_64 4/8 Verifying : MariaDB-compat-10.2.18-1.el6.x86_64 5/8 Verifying : MariaDB-client-10.2.18-1.el6.x86_64 6/8 Verifying : libaio-0.3.107-10.el6.x86_64 7/8 Verifying : boost-program-options-1.41.0-28.el6.x86_64 8/8 Installed: MariaDB-server.x86_64 0:10.2.18-1.el6 Dependency Installed: MariaDB-client.x86_64 0:10.2.18-1.el6 MariaDB-common.x86_64 0:10.2.18-1.el6 MariaDB-compat.x86_64 0:10.2.18-1.el6 boost-program-options.x86_64 0:1.41.0-28.el6 galera.x86_64 0:25.3.24-1.rhel6.el6 libaio.x86_64 0:0.3.107-10.el6 perl-DBI.x86_64 0:1.609-4.el6 Complete! |
4. 확인
[root@goni9071 ~]# rpm -qa | grep MariaDB |
MariaDB-client-10.2.18-1.el6.x86_64 MariaDB-server-10.2.18-1.el6.x86_64 MariaDB-compat-10.2.18-1.el6.x86_64 MariaDB-common-10.2.18-1.el6.x86_64 |
5. 시작
[root@goni9071 ~]# service mysql start Starting MariaDB.181113 17:49:06 mysqld_safe Logging to '/var/lib/mysql/goni9071.tistory.com.err'. 181113 17:49:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql SUCCESS! |
6. 확인
[root@goni9071 ~]# netstat -an|grep 3306 tcp 0 0 :::3306 :::* LISTE |
7. root 패스워드 설정
[root@goni9071 ~]# mysqladmin -u root password |
8. 접속
[root@goni9071 ~]# /usr/bin/mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 11 Server version: 10.2.18-MariaDB-log 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)]> |
반응형
'Database' 카테고리의 다른 글
| mysql dump and 복구 (0) | 2019.04.09 |
|---|---|
| mysql my session number id (0) | 2019.03.10 |
| CentOS7 MariaDB 설치 (0) | 2018.12.19 |
| 오라클 용량 산정 참고 쿼리 (0) | 2018.12.14 |
| oracle - replace xml invalid character 오라클 XML 사용제한 문자 치환 (0) | 2018.10.18 |
| oracle Ampersand "&" insert (0) | 2018.10.15 |
| mysql join update (2) | 2018.10.11 |
| oracle merge -> mysql replace or on duplicate key update (0) | 2018.07.25 |