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...
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...