[MySQL] mysql 1067 프로세스가 예기치 않게 종료되었습니다

[MySQL] mysql 1067 프로세스가 예기치 않게 종료되었습니다

컴퓨터를 재시작했더니 MySQL 이 자동 실행도 안되고 서비스에서 재실행이 먹질 않았다.

[사용환경]

MariaDB 10.2

Windows 10

설치경로 : C:\Program Files\MariaDB 10.2

mysql\bin 에서 mysql 서비스 재등록으로도 해결이 되지 않았다.

[로그파일]

C:\Program Files\MariaDB 10.2\data\DESKTOP-000000.err

2018-12-27 10:48:17 2180 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2018-12-27 10:48:17 2180 [Note] InnoDB: Uses event mutexes

2018-12-27 10:48:17 2180 [Note] InnoDB: Compressed tables use zlib 1.2.3

2018-12-27 10:48:17 2180 [Note] InnoDB: Number of pools: 1

2018-12-27 10:48:17 2180 [Note] InnoDB: Using SSE2 crc32 instructions

2018-12-27 10:48:17 2180 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M

2018-12-27 10:48:17 2180 [Note] InnoDB: Completed initialization of buffer pool

2018-12-27 10:48:17 2180 [ERROR] InnoDB: File .\ibdata1: 'STAT' returned OS error 0.

2018-12-27 10:48:17 2180 [ERROR] InnoDB: os_file_get_status() failed on '.\ibdata1'. Can't determine file permissions

2018-12-27 10:48:17 2180 [ERROR] InnoDB: Plugin initialization aborted with error Generic error

2018-12-27 10:48:17 2180 [Note] InnoDB: Starting shutdown...

2018-12-27 10:48:17 2180 [ERROR] Plugin 'InnoDB' init function returned error.

2018-12-27 10:48:17 2180 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2018-12-27 10:48:17 2180 [Note] Plugin 'FEEDBACK' is disabled.

2018-12-27 10:48:17 2180 [ERROR] Unknown/unsupported storage engine: InnoDB

2018-12-27 10:48:17 2180 [ERROR] Aborting

ibdata1 관련된 에러로 판단 구글링 해본 결과 지우면 된단다.

ib_logfile0, ib_logfile1, ibdata1 파일 제거 후 재실행 : 성공