I had the same issue before and it was due to the # hash in the password. Not sure this is a bug or

I had the same issue before and it was due to the # (hash) in the password. Not sure this is a bug or by design.

So, uninstalled and reinstalled mysql server with a root password that doesn't contain # (hash) and this time it worked fine.