Hello Nissan and thanks for this bug report. Mysql is failing to start because with error:
[ERROR] [MY-000077] [Server] /usr/sbin/mysqld: Error while setting value 'ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'. which is caused by this (non-default) setting you have in your /etc/mysql/my.cnf: [mysqld] sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION According to [1] NO_AUTO_CREATE_USER has been removed from MySQL 8.0, so that might be what is causing the error. Note that [2] says that ERROR_FOR_DIVISION_BY_ZERO is deprecated and that NO_ENGINE_SUBSTITUTION is enabled by default, so you might want to adjust these other settings too. I'm setting the status of this bug report to Incomplete for the moment. Please change it to Invalid if you agree this is a local configuration problem rather than a bug in Ubuntu. If you still believe this is a bug in Ubuntu please comment back, change the report status back to New and we'll look at it again. Thanks! [1] https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html#mysql-nutshell-removals [2] https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html ** 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/1904761 Title: package mysql-server-8.0 8.0.22-0ubuntu0.20.04.2 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/1904761/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
