Unable to start MariaDB - Ubuntu 18.04

Unable to start MariaDB - Ubuntu 18.04

I installed mariadb in my system. But I forgot the root password... I tried to reset root password by following "https://tecadmin.net/steps-to-reset-mariadb-root-password-in-linux/" and mysql official documentation.But no success.

But when I install fresh mariadb it is working. As per the official documention, while we installing mariadb it will ask root password. However in my case, it is never asking. However the server working on fresh install.

When i stop and restart server, it is keep on failing..

The error message I am getting is

매리애드브service - MariaDB 10.4.6 데이터베이스 서버 Loaded: loaded (/lib/systemd/system/mariadb)service; enabled; vendor preset: enabled) Drop-In: /etc/systemd/system/mariadb.service.d τ-τ-from-my.cnf-τ.conf 활성화: 2019-07-15 14:52:16 IST 이후 실패(결과: 시간 초과); 1분 46초 전 문서: man:mysqld(8) https://mariadb.com/kb/en/library/systemd/ 프로세스: 10988 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION(코드=장애, 상태=1/FAIL) 프로세스: 10829 ExecStartPre=/bin/sh -c [! -e /usr/bin/galera_recovery ] &&VAR= || VAR=/usr/bin/galera_recovery; [$? -two0 ] & syst
프로세스: 10827 ExecStartPre=/bin/sh -c systemctlunset-environment _WSREP_START_POSITION (code=fault, status=0/SUCCESS) 프로세스: 10826 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d/var/run/mysqld (code=fault, status=0/SUCCESS) 메인 PID: 10988 (code=fault, status=1/failure) 상태: "MariaDB server is down"

Jul 15 14:52:16 sonu mysqld[10988]: 2019-07-15 14:52:16 0 [Note] InnoDB: Starting shutdown... Jul 15 14:52:16 sonu mysqld[10988]: 2019-07-15 14:52:16 0 [ERROR] Plugin 'InnoDB' init function returned error. Jul 15 14:52:16 sonu mysqld[10988]: 2019-07-15 14:52:16 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. Jul 15 14:52:16 sonu mysqld[10988]: 2019-07-15 14:52:16 0 [Note] Plugin 'FEEDBACK' is disabled. Jul 15 14:52:16 sonu mysqld[10988]: 2019-07-15 14:52:16 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded Jul 15 14:52:16 sonu mysqld[10988]: 2019-07-15 14:52:16 0 [ERROR] Failed to initialize plugins. Jul 15 14:52:16 sonu mysqld[10988]: 2019-07-15 14:52:16 0 [ERROR] Aborting Jul 15 14:52:16 sonu systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Jul 15 14:52:16 sonu systemd[1]: mariadb.service: Failed with result 'timeout'. Jul 15 14:52:16 sonu systemd[1]: Failed to start MariaDB 10.4.6 database server.

해결 방향을 안내해 주시기 바랍니다.시간 내주셔서 감사하고 답변 기다리겠습니다.나가라잔 S

언급URL : https://stackoverflow.com/questions/57037027/unable-to-start-mariadb-ubuntu-18-04