I tried the GRANT syntax, but I too am having this problem.
PLEASE HELP. This is frustrating. I am new to MySQL.
Cannot connect as anything other than root, using shell or PHP pages on localhost.
Here's my error:
ERROR 1045: Access denied for user: 'greg@localhost' (Using password: YES)
[in php page]
Warning: Access denied for user: 'greg@localhost' (Using password: YES) in /[...]/dbtest.php on line 14
(I'm developing under OS X 10.1, but that should not make a difference).