[Bug 1854852] Re: package mysql-server-8.0 8.0.18-0ubuntu0.19.10.1 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1

2019-12-03 Thread Andreas Hasenack
*** This bug is a duplicate of bug 1612517 ***
https://bugs.launchpad.net/bugs/1612517

2019-12-02T18:42:45.437945Z 0 [ERROR] [MY-77] [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'.

NO_AUTO_CREATE_USER was removed from mysql 8:
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html#mysql-nutshell-deprecations
"""
 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 received this bug notification because you are a member of Ubuntu
Server, which is subscribed to mysql-8.0 in Ubuntu.
https://bugs.launchpad.net/bugs/1854852

Title:
  package mysql-server-8.0 8.0.18-0ubuntu0.19.10.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/1854852/+subscriptions

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


[Bug 1854852] Re: package mysql-server-8.0 8.0.18-0ubuntu0.19.10.1 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1

2019-12-03 Thread Andreas Hasenack
*** This bug is a duplicate of bug 1612517 ***
https://bugs.launchpad.net/bugs/1612517

The config option NO_AUTO_CREATE_USER is not part of the default config,
and therefore won't be taken care of during the upgrade to mysql 8. You
should remove it manually and then retry the installation with:

sudo apt update
sudo apt -f install


** This bug has been marked a duplicate of bug 1612517
   Server fails to start after upgrade because of customized config and 
obsolete/renamed directives

-- 
You received this bug notification because you are a member of Ubuntu
Server, which is subscribed to mysql-8.0 in Ubuntu.
https://bugs.launchpad.net/bugs/1854852

Title:
  package mysql-server-8.0 8.0.18-0ubuntu0.19.10.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/1854852/+subscriptions

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs