This seems to be the error:
Renaming removed key_buffer and myisam-recover options (if present)
ERROR: Unable to start MySQL server:
2019-11-02T02:24:50.952742Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2019-11-02T02:24:50.958476Z 0 [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'.
2019-11-02T02:24:51.013521Z 0 [ERROR] [MY-010119] [Server] Aborting
Using GRANT to create users. Instead, use CREATE USER. Following this practice makes the NO_AUTO_CREATE_USER SQL mode immaterial for GRANT statements, so it too is removed, and an error now is written to the server log when the presence of this value for the sql_mode option in the options file prevents mysqld from starting.
"""
You have it set in /etc/mysql/mysql.conf.d/mysqld.cnf:
Thanks for filing this bug in Ubuntu.
This seems to be the error: 02T02:24: 50.952742Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_ expire_ logs_seconds instead. 02T02:24: 50.958476Z 0 [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'. 02T02:24: 51.013521Z 0 [ERROR] [MY-010119] [Server] Aborting
Renaming removed key_buffer and myisam-recover options (if present)
ERROR: Unable to start MySQL server:
2019-11-
2019-11-
2019-11-
NO_AUTO_CREATE_USER was removed from mysql 8: /dev.mysql. com/doc/ refman/ 8.0/en/ mysql-nutshell. html#mysql- nutshell- deprecations
https:/
"""
The following features related to account management are removed:
Using GRANT to create users. Instead, use CREATE USER. Following this practice makes the NO_AUTO_CREATE_USER SQL mode immaterial for GRANT statements, so it too is removed, and an error now is written to the server log when the presence of this value for the sql_mode option in the options file prevents mysqld from starting.
"""
You have it set in /etc/mysql/ mysql.conf. d/mysqld. cnf:
sql_mode = "ERROR_ FOR_DIVISION_ BY_ZERO, NO_AUTO_ CREATE_ USER,NO_ ENGINE_ SUBSTITUTION"
Removing this option should allow your server to start again, and the upgrade to complete:
sudo apt update
sudo apt -f install