If auth_socket is set to a user, then ALTER USER ... IDENTIFIED BY 'password' will not have any effect.
So if the server is installed with a blank password for root, trying to change the password with a reconfigure won't work. But logging in as a root with a password set during the initial install works as it should. If we want to be able to switch from auth_socket back to a normal password login we can ensure mysql_native_plugin is the user's authentication method when setting the password in postinst. -- 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 [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
