MySQL isn't internally strict with the empty root password; auth socket is enabled by packaging to make it more secure by default, not by the server itself, so just running ALTER USER 'root'@'localhost' IDENTIFIED WITH 'mysql_native_password' BY ''; will work
-- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1571668 Title: Mysql upgrade locks out its root user To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1571668/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
