This is a really frustrating issue that took me ages to figure out. I am running xampp on a windows PC and not matter what type password I used I could not get it to authenticate a user so I ended up using the root account.

Solution

xampp does not like the %, you must use localhost when adding a user in phpMyAdmin