Arch Linux

brandon_izarnotegui

Member

Registered: 2021-03-04

Posts: 8

I installed mariadb, not sure what the problem is. ?

I installed mariadb and got error
ERROR 1698 (28000): Access denied for user 'root'@'localhost'

so I tried resetting root password following archwiki troubleshouting guide
now I get

[a@archPC ~]$ sudo systemctl start mariadb.service
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.

$ sudo systemctl status mariadb.service
● mariadb.service - MariaDB 10.5.9 database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
     Active: failed (Result: exit-code) since Fri 2021-03-19 20:17:35 PDT; 21min ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
   Main PID: 5175 (code=exited, status=1/FAILURE)
     Status: "MariaDB server is down"

Mar 19 20:17:35 archPC mariadbd[5175]: 2021-03-19 20:17:35 0 [ERROR] InnoDB: Plugin initialization aborted with error Cannot open a file
Mar 19 20:17:35 archPC mariadbd[5175]: 2021-03-19 20:17:35 0 [Note] InnoDB: Starting shutdown...
Mar 19 20:17:35 archPC mariadbd[5175]: 2021-03-19 20:17:35 0 [ERROR] Plugin 'InnoDB' init function returned error.
Mar 19 20:17:35 archPC mariadbd[5175]: 2021-03-19 20:17:35 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Mar 19 20:17:35 archPC mariadbd[5175]: 2021-03-19 20:17:35 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded
Mar 19 20:17:35 archPC mariadbd[5175]: 2021-03-19 20:17:35 0 [ERROR] Failed to initialize plugins.
Mar 19 20:17:35 archPC mariadbd[5175]: 2021-03-19 20:17:35 0 [ERROR] Aborting
Mar 19 20:17:35 archPC systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Mar 19 20:17:35 archPC systemd[1]: mariadb.service: Failed with result 'exit-code'.
Mar 19 20:17:35 archPC systemd[1]: Failed to start MariaDB 10.5.9 database server.

now mariadb.service wont start.I think I make a mistake , maybe I didnt had to change the password.
is unninstalling and installing mariadb something I should try to do at this point?

I did'nt know something as simple as trying to change a password would break everything.
https://wiki.archlinux.org/index.php/Ma … t_password

teckk

Member

Registered: 2013-02-21

Posts: 519

Re: I installed mariadb, not sure what the problem is. ?

Did you read the wiki?
https://wiki.archlinux.org/index.php/MariaDB
https://wiki.archlinux.org/index.php/Ma … t_password
https://bbs.archlinux.org/viewtopic.php?id=51981