Observed this in Mariadb 10.x versions. Despite being able to change password, it is still ignoring the password. Non-root user not affected. Explanation per https://mariadb.com/kb/en/authentication-from-mariadb-104/ Using unix_socket means that if you are the system root user, you can login as root@locahost without a …