ERROR 1045: Access denied for user:

[Michael Gargiullo]

On Tue, 2004-03-30 at 13:48, Michael S. Dunsavage wrote:
> I get the following error when I do
> 
> mysql -u mikesd -p
> 
> ERROR 1045: Access denied for user: 'mikesd at localhost' (Using password: YES)
> 
> 
> the user mikesd exists.
> 
> I did
> 
> mysql> GRANT ALL PRIVILEGES ON *.* TO 'mikesd'@'localhost'
>      ->     IDENTIFIED BY 'pass' WITH GRANT OPTION;
> mysql> GRANT ALL PRIVILEGES ON *.* TO 'mikesd'@'%'
>      ->     IDENTIFIED BY 'pass' WITH GRANT OPTION;
> mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
> mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';
> 
> 
> What else?
> 
> -- 
> Michael S. Dunsavage
> 

look at mysql.user
mysql>select host,user from mysql.user;

do you get 

| localhost	|mikesd |

returned ?

I've always added users without the quotes around the @

MYSQL>grant all privileges on *.* to mikesd at localhost idenified by
'pass';

MYSQL>flush privileges;