Thank you for taking the time to file a bug report. As you mentioned in the bug description, you chose not to replace your MySQL configuration with the package-provided one. That is absolutely fine, but it also means that you have to be careful when you're upgrading the software because some of the options you use in your current configuration may not be available anymore in a newer version. In your specific scenario, you are upgrading from MySQL 5.7 (Bionic) to MySQL 8.0 (Focal), which is definitely a non-trivial bump in the version.
After inspecting your DpkgTerminalLog.txt file, I see the following error: 2021-11-23T16:08:58.766734Z 0 [ERROR] [MY-000077] [Server] /usr/sbin/mysqld: Error while setting value 'NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'. A quick internet search showed me that MySQL 8.0 does not support at least one of those parameters: NO_AUTO_CREATE_USER https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html#mysqld-8-0-11-deprecation- removal There may be more deprecations/removals that you have to take into account when adjusting your MySQL configuration file. Since it seems likely to me that this is a local configuration problem, rather than a bug in Ubuntu, I am marking this bug as 'Incomplete'. However, if you believe that this is really a bug in Ubuntu, then we would be grateful if you would provide a more complete description of the problem with steps to reproduce, explain why you believe this is a bug in Ubuntu rather than a problem specific to your system, and then change the bug status back to "New". For local configuration issues, you can find assistance here: http://www.ubuntu.com/support/community ** Changed in: mysql-8.0 (Ubuntu) Status: New => Incomplete -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1951984 Title: package mysql-server-8.0 8.0.27-0ubuntu0.20.04.1 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1951984/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
