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