I just realized that not even the
mysqld_safe --skip-grant-tables --skip-networking
solution will work, since after logging in
ALTER USER 'root'@'localhost' IDENTIFIED BY '';
will fail with
ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded
(the same applies for the old command: `SET PASSWORD FOR
'root'@'localhost' = PASSWORD('');`)
And trying
install plugin auth_socket soname 'auth_socket.so';
will only result in
ERROR 1030 (HY000): Got error 1 from storage engine
--
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
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
