[MariaDB][Centos7] mariadb 실행 실패 (datadir 설정 변경 후)

 

 

 [ 작업 환경 ]

 

Centos 7

MariaDB-5.5

 

 

 

 

 [ 문제 상황 ]

 

필자의 경우 /etc/my.cnf 파일의 datadir 설정값을 변경한 후 해당 문제가 발생했습니다.

 

Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.

 

mariadb-prepare-db-dir[9708]: chown: changing ownership of '/DB': Operation not permitted
mariadb-prepare-db-dir[9708]: chmod: changing permissions of '/DB': Operation not permitted
mariadb-prepare-db-dir[9708]: Initializing MariaDB database
mariadb-prepare-db-dir[9708]: chown: changing ownership of '/DB': Operation not permitted
mariadb-prepare-db-dir[9708]: Cannot change ownership of the database directories to the 'mysql'
mariadb-prepare-db-dir[9708]: user.  Check that you have the necessary permissions and try again.
mariadb-prepare-db-dir[9708]: Initialization of MariaDB database failed.
mariadb-prepare-db-dir[9708]: Perhaps @sysconfdir@/my.cnf is misconfigured or there is some problem with permissions of /DB.
mariadb-prepare-db-dir[9708]: Initialization of MariaDB database was not finished successfully.
mariadb-prepare-db-dir[9708]: Files created so far will be removed.
systemd[1]: mariadb.service: control process exited, code=exited status=1
systemd[1]: Failed to start MariaDB database server.

 

 

 

 

 

 [ 문제 원인 ]

 

datadir로 설정한 /DB 의 소유자가 mysql에서 컨트롤할 수 없는 세팅이기 때문입니다.

chown -R mysql: /DB

 

 

 

 

 

 [ 문제 해결 완료 ]