I think, that there is some missunderstanding of what the unix_socket authentication does...
A user, who is loged in on his system (shell, ssh...) is able to access mariadb with a user that is named like his unix user (if it exists as db user) without password. So logged in as root, I'm able to use "mysql -u root". logged in as bjoern, I get an access denied, trying to do "mysql -u root" If there was a user bjoern in MariaDB, I could use "mysql -u bjoern2 to login without password. phpmyadmin will never work with root and unix_socket auth! the script mentionned above will remove the auth plugin from the user root and return to the old DB-based auth... What I'm not sure about, is if the old password is still valid, so ry it or update root password... -- 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
