mariadb 특정 버전 지정 설치

 

 

1. 다운로드 페이지 접속
https://mariadb.org/download/

Download MariaDB Server - MariaDB.org

2. OS 및 설치버전 선택

3. /etc/yum.repos.d경로에 mariadb.repo추가

# MariaDB 10.3 CentOS repository list - created 2022-07-19 04:26 UTC
# https://mariadb.org/download/
[mariadb]
name = MariaDB
baseurl = https://tw1.mirror.blendbyte.net/mariadb/yum/10.3/centos7-amd64
gpgkey=https://tw1.mirror.blendbyte.net/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1

 

4. 설치

[darksharavim.tistory.com]yum install MariaDB-server MariaDB-client

 

 

5. 서비스 확인

[darksharavim.tistory.com]rpm -qa | grep -i mariadb
MariaDB-compat-10.3.35-1.el7.centos.x86_64
MariaDB-client-10.3.35-1.el7.centos.x86_64
MariaDB-server-10.3.35-1.el7.centos.x86_64
MariaDB-common-10.3.35-1.el7.centos.x86_64
[darksharavim.tistory.com]systemctl status mariadb
● mariadb.service - MariaDB 10.3.35 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: inactive (dead)
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
[darksharavim.tistory.com]

 

 

6. 서비스 시작

mysql_install_db --datadir=/var/lib/mysql

systemctl start mariadb

 

[darksharavim.tistory.com]mysql -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.3.35-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)]>

 

root암호 설정

MariaDB [(none)]> SET PASSWORD FOR root@localhost = PASSWORD('mysqlpassword');
Query OK, 0 rows affected (0.002 sec)

MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.001 sec)

 

user등이 비어 있는 로그인정보 및 test테이블 삭제

MariaDB [(none)]> use mysql
Database changed
MariaDB [mysql]> DELETE FROM user WHERE User='';
Query OK, 2 rows affected (0.001 sec)

MariaDB [mysql]> DELETE FROM user WHERE Password='';
Query OK, 3 rows affected (0.001 sec)

MariaDB [mysql]> DELETE FROM db WHERE User='';
Query OK, 2 rows affected (0.001 sec)

MariaDB [mysql]> DROP DATABASE test;
Query OK, 0 rows affected (0.002 sec)