package mysql-server-8.0 8.0.36-0ubuntu0.23.10.1 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1

[Yamlak Fikru]

trying to install it but it doesnt work

ProblemType: Package
DistroRelease: Ubuntu 23.10
Package: mysql-server-8.0 8.0.36-0ubuntu0.23.10.1
ProcVersionSignature: Ubuntu 6.5.0-25.25-generic 6.5.13
Uname: Linux 6.5.0-25-generic x86_64
NonfreeKernelModules: nvidia_modeset nvidia
ApportVersion: 2.27.0-0ubuntu5
Architecture: amd64
CasperMD5CheckResult: pass
Date: Sun Mar 24 14:31:33 2024
ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2024-03-03 (21 days ago)
InstallationMedia: Ubuntu 23.10.1 "Mantic Minotaur" - Release amd64 (20231016.1)
Logs.var.log.daemon.log:

MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql]
MySQLConf.etc.mysql.conf.d.mysqldump.cnf:
 [mysqldump]
 quick
 quote-names
 max_allowed_packet = 16M
MySQLConf.etc.mysql.my.cnf: my.cnf links to /etc/mysql/mysql.cnf
MySQLVarLibDirListing: ['#ib_16384_1.dblwr', '#innodb_temp', 'ca.pem', 'binlog.index', 'auto.cnf', 'private_key.pem', 'ca-key.pem', 'binlog.000002', 'client-key.pem', '#ib_16384_0.dblwr', 'undo_002', 'debian-5.7.flag', 'undo_001', 'server-cert.pem', 'sys', 'client-cert.pem', 'ib_buffer_pool', 'performance_schema', 'mysql', 'server-key.pem', '#innodb_redo', 'public_key.pem', 'ibdata1', 'binlog.000001', 'mysql.ibd']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-6.5.0-25-generic root=UUID=223b1c8a-a61c-49d0-9f92-b75a54a3c0c1 ro quiet splash vt.handoff=7
Python3Details: /usr/bin/python3.11, Python 3.11.6, python3-minimal, 3.11.4-5
PythonDetails: N/A
RelatedPackageVersions:
 dpkg 1.22.0ubuntu1.1
 apt 2.7.3
SourcePackage: mysql-8.0
Title: package mysql-server-8.0 8.0.36-0ubuntu0.23.10.1 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)