MySQL user at any host doesn't work, needs localhost in some local personal computer development environments

Description

Where the user, password, and database are all "xmp".

ben@blackbox:/var/www/xmp$ mysql -u xmp -pxmp xmp < IMPORT_THIS_TO_YOUR_XMP_DB.sql

ERROR 1045 (28000): Access denied for user 'xmp'@'localhost' (using password: YES)

i can't even get that to work

Solution: it was the weird thing where telling it to allow the connection from % (any host) doesn't work when you use localhost

i think I had the problem on XAMPP, and Alan had it on Bitnami or whatever, and now on our Ubuntu box. Very very weird

i changed it in phpmyadmin -- replaced the % with localhost and said delete the old account and reload all privileges

ben@blackbox:/var/www/xmp$ mysql -u xmp -pxmp xmp < IMPORT_THIS_TO_YOUR_XMP_DB.sql

same command worked now