Why can't this mysql user log in with password?
Because you granted it access without password... If a user has no password, logging in with one will always fail.
Set the password for user, only then you'll be able to use -p
In addition, you might want to remove the Any
user.