[Bug 1567098] Re: Cannot log in as root user when not root Unix user

[Ubuntu Foundations Team Bug Bot]

The attachment "0001-Enable-setting-password-for-existing-database-if-
it-.patch" seems to be a debdiff.  The ubuntu-sponsors team has been
subscribed to the bug report so that they can review and hopefully
sponsor the debdiff.  If the attachment isn't a patch, please remove the
"patch" flag from the attachment, remove the "patch" tag, and if you are
member of the ~ubuntu-sponsors, unsubscribe the team.

[This is an automated message performed by a Launchpad user owned by
~brian-murray, for any issue please contact him.]

** Tags added: patch

-- 
You received this bug notification because you are a member of Ubuntu
Sponsors Team, which is subscribed to the bug report.
https://bugs.launchpad.net/bugs/1567098

Title:
  Cannot log in as root user when not root Unix user

Status in mysql-5.7 package in Ubuntu:
  New

Bug description:
  I'm not clear if this is an issue, but I think it needs investigating.

  DEBIAN_FRONTEND=noninteractive apt-get install -y mysql-server
  dpkg-reconfigure mysql-server (supply new root password)
  Switch to non-root Unix user
  Log in with mysql client as MySQL root user

  Expected behaviour: login successful
  Actual behaviour: login refused

  Was this case considered when doing the Unix socket auth? Is the issue
  that the password was initially blank and then set later, or does it
  do it even if the password was initially set? If the former then this
  probably isn't as important as the latter case.

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1567098/+subscriptions