[Airflow] MysQL 설치 후 실행 에러 해결(feat. version을 확인하쟈!)

MySQL 실행 error

> sudo systemctl start mysqld 

Failed to start mysqld.service: Unit not found.

> mysql --version

mysql Ver 15.1 Distrib 5.5.68-MariaDB, for Linux(x86_64) using readline 5.1

=> 처음 설치한 버전이 mariaDB 버전이었던게 문제였던 듯.

 

MySQL 재설치

> sudo yum install -y mysql-server mysql-client

No package mysql-server available.
No package mysql-client available.
Error: Nothing to do

• wget으로 mysql 설치

> wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

> sudo yum install mysql57-community-release-el7-11.noarch.rpm

> sudo yum install mysql-server mysql-client

The GPG keys listed for the "MySQL 5.7 Community Server" repository are already installed but they are not correct for this package.
Check that the correct key URLs are configured for this repository.
​
Failing pacakge is: mysql-community-libs-compat-5.7.38-1.e17.x86_64
GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

• gpgkey 업데이트

> sudo rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

> sudo systemctl start mysqld
> ps -ef |grep myql

 

• MySQL 버전 체크

> mysql --version

mysql Ver 14.14 Distrib 5.7.38, for Linux (x86_64) using EditLine wrapper

 

Airflow db 연동

> airflow db init

Exception: Global variable explicit_defaults_for_timestamp needs to be on (1) for mysql

• Mysql 옵션 주기

> mysql -u root -p

mysql> set global explicit_defaults_for_timestamp=1;

> airflow db init

등록 성공!

 

 

 

- 이상 오늘의 삽질일기 끝!

 

---

여기저기 삽질도 해보고

날려도 먹으면서

배우는 게

결국 남는거다

- Z.Sabziller