Mysql error!

[jeremyy44]

Hi I keep getting this error while trying to either configure or even remove mysql-server-8.0 and cant seem to find anything online to help.
Even when I do 'sudo apt autoremove -y' I keep getting this error nothing seems to work.

Setting up mysql-server-8.0 (8.0.22-0ubuntu0.20.04.3) ...
Failed to stop mysql.service: Unit mysql.service not loaded.
invoke-rc.d: initscript mysql, action "stop" failed.
update-alternatives: error: alternative path /etc/mysql/mysql.cnf doesn't exist
dpkg: error processing package mysql-server-8.0 (--configure):
installed mysql-server-8.0 package post-installation script subprocess returned error exit status 2
Errors were encountered while processing:
mysql-server-8.0

 

[UnixSH]

Hey, can you post your MySQL logs ? It should be more precise to help you. The default location is /var/log/mysql.log

 

[joshxxl]

2022-04-21 10:21:10 0 [Note] InnoDB: Using Linux native AIO
2022-04-21 10:21:10 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-04-21 10:21:10 0 [Note] InnoDB: Uses event mutexes
2022-04-21 10:21:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-04-21 10:21:10 0 [Note] InnoDB: Number of pools: 1
2022-04-21 10:21:10 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-04-21 10:21:10 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-04-21 10:21:10 0 [Note] InnoDB: Completed initialization of buffer pool
2022-04-21 10:21:10 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-04-21 10:21:10 0 [ERROR] InnoDB: Invalid flags 0x4800 in ./ibdata1
2022-04-21 10:21:10 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2022-04-21 10:21:11 0 [Note] InnoDB: Starting shutdown...
2022-04-21 10:21:12 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-04-21 10:21:12 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-04-21 10:21:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-04-21 10:21:12 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2022-04-21 10:21:12 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-04-21 10:21:12 0 [ERROR] Aborting

 

[jpnilson]

Here is the problem

2022-04-21 10:21:10 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption

You could try something like this to resolve

How Do I Fix MySQL Server Database Corruption Smoothly

Learn troubleshooting steps to fix MySQL Server Database Corruption issue. Also, know how MySQL repair software can help resolve the issue.

www.stellarinfo.com

If its a new installation might be easier to start over. Depends if you have substantial data to loose