After reinstalling mysql, I get an error when installing any software
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
wget is already the newest version (1.21.2-2ubuntu1).
0 upgraded, 0 newly installed, 0 to remove and 43 not upgraded.
2 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] y
Setting up mysql-server-8.0 (8.0.30-0ubuntu0.22.04.1) ...
Renaming removed key_buffer and myisam-recover options (if present)
Specified filename /var/lib/mysql/ibdata1 does not exist.
mysqld will log errors to /var/log/mysql/error.log
2022-09-02T07:28:00.496933Z 0 [ERROR] [MY-010946] [Server] Failed to start mysqld daemon. Check mysqld error log.
Warning: Unable to start the server.
AppArmor parser error for /etc/apparmor.d/usr.sbin.mysqld in profile /etc/apparmor.d/usr.sbin.mysqld at line 9: Could not open 'abstractions/mysql'
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xeu mysql.service" for details.
invoke-rc.d: initscript mysql, action "start" failed.
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: activating (auto-restart) (Result: exit-code) since Fri 2022-09-02 15:28:00 CST; 3ms ago
Process: 15388 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)
CPU: 6ms
dpkg: error processing package mysql-server-8.0 (--configure):
installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-8.0; however:
Package mysql-server-8.0 is not configured yet.
dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
Errors were encountered while processing:
mysql-server-8.0
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
Solution:
ls -l /var/lib/dpkg/info | grep -i mysql-server -rw-r--r-- 1 root root 363 Jul 27 00:14 mysql-server-8.0.conffiles -rwxr-xr-x 1 root root 1504 Jul 27 00:14 mysql-server-8.0.config -rw-r--r-- 1 root root 1604 Aug 31 19:00 mysql-server-8.0.list -rw-r--r-- 1 root root 1112 Jul 27 00:14 mysql-server-8.0.md5sums -rwxr-xr-x 1 root root 17135 Jul 27 00:14 mysql-server-8.0.postinst -rwxr-xr-x 1 root root 3873 Jul 27 00:14 mysql-server-8.0.postrm -rwxr-xr-x 1 root root 5631 Jul 27 00:14 mysql-server-8.0.preinst -rwxr-xr-x 1 root root 403 Jul 27 00:14 mysql-server-8.0.prerm -rw-r--r-- 1 root root 21907 Jul 27 00:14 mysql-server-8.0.templates -rw-r--r-- 1 root root 5232 Aug 31 19:00 mysql-server-core-8.0.list -rw-r--r-- 1 root root 8318 Jul 27 00:14 mysql-server-core-8.0.md5sums
mv /var/lib/dpkg/info/mysql-* /tmp apt-get update