Public bug reported: 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. ** Affects: mysql-5.7 (Ubuntu) Importance: High Status: New ** Tags: mysql-5.7-transition ** Changed in: mysql-5.7 (Ubuntu) Importance: Undecided => High ** Tags added: mysql-5.7-transition -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1567098 Title: Cannot log in as root user when not root Unix user To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1567098/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs