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:

[in shell]
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).