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 …
For as long as you have root access to MySQL, this would work:
1UPDATE mysql.user SET Password=PASSWORD('new-password-here') WHERE USER='user-name-here' AND Host='host-name-here'; more details from https://www.cyberciti.biz/faq/mysql-change-user-password/