Thanks for taking the time to file this bug.
Your analysis seems right and there is nothing we can do as Ubuntu,
upstream decided to remove that option and we cannot support it without
upstream. What you need to do is to avoid the usage of the
NO_AUTO_CREATE_USER sql_mode option if you want to upgrade to MySQL 8,
from the release notes you linked in the bug description:
"For MySQL 5.7 applications that use SQL modes removed in MySQL 8.0,
statements may fail when replicated from a MySQL 5.7 master to a MySQL
8.0 slave, or may have different effects on master and slave. To avoid
such problems, applications that use modes removed in MySQL 8.0 should
be revised to avoid them."
Since this is a local configuration problem, rather than a bug in
Ubuntu, I am marking this bug as 'Invalid'.
** Changed in: mysql-8.0 (Ubuntu)
Status: New => Invalid
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1929443
Title:
upgrade mysql 5.7 to 8.0 during release upgrade (18.04.5 to 20.04.2)
fails due to unsupported SQL mode
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1929443/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
