mysqld: File '/var/data/mysql/auto.cnf' not found (OS errno 13 - Permission denied)

서버 재부팅 후 오류 발생 원인 : mysqld: File '/var/data/mysql/auto.cnf' not found (OS errno 13 - Permission denied)

 

:16.945864Z 0 [Warning] [MY-010091] [Server] Can't create test file /var/data/mysql/mysqld_tmp_file_case_insensitive_test.lower-test

:16.945930Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.29) starting as process 1697

:16.947561Z 0 [Warning] [MY-010091] [Server] Can't create test file /var/data/mysql/mysqld_tmp_file_case_insensitive_test.lower-test

:16.947591Z 0 [Warning] [MY-010091] [Server] Can't create test file /var/data/mysql/mysqld_tmp_file_case_insensitive_test.lower-test

:16.949043Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: XXXXXXX-1203-11ed-a25f-f079596a6c82.

mysqld: File '/var/data/mysql/auto.cnf' not found (OS errno 13 - Permission denied)

:16.949152Z 0 [ERROR] [MY-010183] [Server] Failed to create file(file: '/var/data/mysql/auto.cnf', errno 13)

:16.949164Z 0 [ERROR] [MY-010076] [Server] Initialization of the server's UUID failed because it could not be read from the auto.cnf file. If this is a new server, the initialization failed because it was not possible to generate a new UUID.

:16.949210Z 0 [ERROR] [MY-010119] [Server] Aborting

:16.949775Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.29)  MySQL Community Server - GPL.

 

SELinux 문제인지 확인하려면

setenforce 0

를 주고 mysql 서비스를 가동해 보는 것입니다. 0을 주면 SELinux 의 가동을 (임시로) 중단시키는 것이며 1 을 주면 SELinux 를 다시 가동 시키게 됩니다.

자세한 내용은 아래 참고 블로그 확인.

 

참고 출처 : https://indienote.tistory.com/583