Comment 9 for bug 1447944
Revision history for this message
| Markus (maier-m) wrote Re: Cannot access mariadb after upgrading to Ubuntu 15.04: Plugin 'unix_socket' is not loaded | #9 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
1b1ed1a
(Get the code!)
!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.