!WARNING! After the script mentionend above has been executed, root was able to login without a password!
Basically, the script by zhxq does the trick and removes the plugin authentication for root. But on my system, it left MariaDB with no password set for root. So in terms of security, this is even worse than having no access at all. Anyway, this brings us closer to the root cause of the problem. From my understanding, after upgrading to vivid, passwords for user root are removed and authentication is set to unix socket authentication. This authentication should be using a plugin which doesn't work properly. So we should either make sure that the plugin works as intended or, my preference, don't change the authentication method for user root. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1447944 Title: Cannot access mariadb after upgrading to Ubuntu 15.04: Plugin 'unix_socket' is not loaded To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1447944/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
