I use macOS Big Sur(11.5.1) and MariaDB(10.8.3_1) with Brew. After some manipulations with Docker(my guess) my mysql.server stopped working. I cannot run my local MySQL server.
These lines I have in the console when text command "mysql.server start"
Starting MariaDB
.221028 01:36:17 mysqld_safe Logging to '/usr/local/var/mysql/MacBook-Pro-My.local.err'.
221028 01:36:18 mysqld_safe Starting mariadbd daemon with databases from /usr/local/var/mysql
/usr/local/bin/mysql.server: line 263: kill: (8447) - No such process
/usr/local/bin/mysql.server: line 276: log_failure_msg: command not found
Content from /usr/local/var/mysql/MacBook-Pro-My.local.err
221028 01:42:45 mysqld_safe Starting mariadbd daemon with databases from /usr/local/var/mysql
2022-10-28 1:42:45 0 [Note] /usr/local/opt/mariadb/bin/mariadbd (server 10.8.3-MariaDB) starting as process 11622 ...
2022-10-28 1:42:45 0 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
2022-10-28 1:42:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-10-28 1:42:45 0 [Note] InnoDB: Number of transaction pools: 1
2022-10-28 1:42:45 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-10-28 1:42:45 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2022-10-28 1:42:45 0 [Note] InnoDB: Completed initialization of buffer pool
2022-10-28 1:42:45 0 [ERROR] InnoDB: File ./ib_logfile0 was not found
2022-10-28 1:42:45 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-10-28 1:42:45 0 [Note] InnoDB: Starting shutdown...
2022-10-28 1:42:45 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-10-28 1:42:45 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-10-28 1:42:45 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-10-28 1:42:45 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-10-28 1:42:45 0 [ERROR] Aborting
221028 01:42:45 mysqld_safe mysqld from pid file /usr/local/var/mysql/MacBook-Pro-My.local.pid ended
I've already tried:
- delete ib_logfile0, it doesn't help
- reinstall MariaDB using brew, it doesn't help
Please, who knows how to debug this issue or solve it, help me.