Hive 3.1.3 (v 1.0) [마스터노드1] [마리아디비선행설치]

MariaDB yum으로 설치

<aside> 💡 홍콩꺼로 했음 미러사이트가 안되는게있음

</aside>

Download MariaDB Server

**# root 유저로해야함!!!!!!!!!!!!!!!!!
vi /etc/yum.repos.d/MariaDB.repo
아래 추가하기

# MariaDB 10.11 CentOS repository list - created 2024-06-17 03:49 UTC
# <https://mariadb.org/download/>
[mariadb]
name = MariaDB
# rpm.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See <https://mariadb.org/mirrorbits/> for details.
# baseurl = <https://rpm.mariadb.org/10.11/centos/$releasever/$basearch>
baseurl = <https://mirrors.xtom.com.hk/mariadb/yum/10.11/centos/$releasever/$basearch>
module_hotfixes = 1
# gpgkey = <https://rpm.mariadb.org/RPM-GPG-KEY-MariaDB>
gpgkey = <https://mirrors.xtom.com.hk/mariadb/yum/RPM-GPG-KEY-MariaDB>
gpgcheck = 1**

**root 사용자가 아닌 hive 유저에서 진행
vi /etc/sudoers 에 임시로 hive 유저를 root 권한주고 시작
---
# hive 유저에서 꼭 진행!!!!
sudo yum -y update
sudo yum install -y net-tools
sudo yum install -y epel-release
sudo yum install -y pv
sudo yum install -y MariaDB-server MariaDB-client

sudo chmod -R 755 /var/lib/mysql**

MariaDB 접속 및 권한 부여 및 확인

**# hive user
sudo systemctl start mariadb.service

# root user
mysql 
#create user 'hive'@'user' identified by 'passwd';
create user 'hive'@'%' identified by 'passwd';
create user 'hive'@'hadoop-nn-1-a' identified by 'passwd';
create user 'hive'@'hadoop-eco-1-a' identified by 'passwd';
create user 'root'@'%' identified by 'passwd';
grant all privileges on hive.* to 'hive'@'%';
grant all privileges on hive.* to 'hive'@'hadoop-nn-1-a';
grant all privileges on hive.* to 'hive'@'hadoop-eco-1-a';
grant all privileges on *.* to 'root'@'%';
FLUSH PRIVILEGES;

#모든 유저 호스트 관계보기
SELECT User, Host FROM mysql.user;
#비번까지
SELECT User, Host, plugin FROM mysql.user;

권한 설정 확인
SHOW GRANTS FOR 'hive'@'%';**

#안될시 근데 다 참고하지 말고 천천히 보고 다시 하기

**sudo pkill -9 mysqld
sudo pkill -9 mysql
ps aux | grep mysqld

sudo mysqld_safe --skip-grant-tables & mysql -u root

USE mysql;
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY '뉴비밀번호';
FLUSH PRIVILEGES;
exit;

mysql -u root -p
# alter 먼저해보고 안되면 없는거니 create 해서 하면됨!!!
# alter 먼저 꼭해보자!
create user 'hive'@'%' identified by '뉴비밀번호';
create user 'hive'@'localhost' identified by '뉴비밀번호';
create user 'root'@'%' identified by '뉴비밀번호';
grant all privileges on *.* to 'hive'@'%';
grant all privileges on *.* to 'hive'@'localhost';
grant all privileges on *.* to 'root'@'%';
flush privileges;

#모든 유저 호스트 관계보기
SELECT User, Host FROM mysql.user;
#비번까지
SELECT User, Host, plugin FROM mysql.user;

권한 설정 확인
SHOW GRANTS FOR 'hive'@'%';

### 'hive' 사용자의 'hpmaster1' 호스트에 대한 권한 부여
#CREATE USER 'hive'@'hpmaster1' IDENTIFIED BY 'Hi#ve01$';
#GRANT ALL PRIVILEGES ON *.* TO 'hive'@'Hi#ve01$';
#FLUSH PRIVILEGES;**