Eu instalei mariadb no meu PC. Mas não vai começar o serviço. O comando sudo systemctl mariadb.start retorna o erro -
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
O status de mariadb.service é reconhecido
● mariadb.service - MariaDB 10.1 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Wed 2017-12-13 18:19:59; 2min 46s ago
Process: 2102 ExecStart=/usr/libexec/mysqld --basedir=/usr $MYSQLD_OPTS
$_WSREP_NEW_CLUSTER (code=exited, status=1/FAILURE)
Process: 2066 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mariadb.service (code=exited, status=0/SUCCESS)
Process: 2043 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
Main PID: 2102 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
Dec 13 18:19:59 localhost.localdomain mysqld[2102]: 2017-12-13 18:19:59 3076243136 [ERROR] Plugin 'InnoDB' init function returned error.
Dec 13 18:19:59 localhost.localdomain mysqld[2102]: 2017-12-13 18:19:59 3076243136 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Dec 13 18:19:59 localhost.localdomain mysqld[2102]: 2017-12-13 18:19:59 3076243136 [Note] Plugin 'FEEDBACK' is disabled.
Dec 13 18:19:59 localhost.localdomain mysqld[2102]: 2017-12-13 18:19:59 3076243136 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
Dec 13 18:19:59 localhost.localdomain mysqld[2102]: 2017-12-13 18:19:59 3076243136 [ERROR] Unknown/unsupported storage engine: InnoDB
Dec 13 18:19:59 localhost.localdomain mysqld[2102]: 2017-12-13 18:19:59 3076243136 [ERROR] Aborting
Dec 13 18:19:59 localhost.localdomain systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Dec 13 18:19:59 localhost.localdomain systemd[1]: Failed to start MariaDB 10.1 database server.
Dec 13 18:19:59 localhost.localdomain systemd[1]: mariadb.service: Unit entered failed state.
Dec 13 18:19:59 localhost.localdomain systemd[1]: mariadb.service: Failed with result 'exit-code'.
Also,
- I can't find any file name my.cnf on my system.
- I have installed it using dnf not yum.
- mysql -u root -p returns ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused").