Thanks for taking the time to report this bug and trying to make Ubuntu better.
>From the logs I can see this error: ERROR: Unable to start MySQL server: 2020-10-19T18:21:57.545271Z 0 [ERROR] [MY-000077] [Server] /usr/sbin/mysqld: Error while setting value 'IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'. 2020-10-19T18:21:57.588487Z 0 [ERROR] [MY-010119] [Server] Aborting Please take a look at https://wiki.debian.org/Teams/MySQL/FAQ for tips on fixing common upgrade issues. In your config file you are setting some deprecated options to the 'sql_mode'. If you check this upstream deprecation page: https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html#mysql- nutshell-deprecations and search for 'AUTO_CREATE_USER', you will notice this is deprecated and it is not supposed to work with MySQL >= 8.0.3 (in Ubuntu Focal we have 8.0.21). Removing it from your config file should fix your issue. 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/1900484 Title: package mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 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/1900484/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
