ERROR 1045: Access denied for user:

[Hamilton, Andrew]

When you select user from users what does the username say?  Are you sure
the username is correct?  When you select user,password from users what does
it say?

Regards,

Drew

-----Original Message-----
From: Michael S. Dunsavage [mailto:mikesd at frontiernet.net]
Sent: Tuesday, March 30, 2004 1:48 PM
To: redhat-list at redhat.com
Cc: Richardson, Gary
Subject: ERROR 1045: Access denied for user: 


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


-- 
redhat-list mailing list
unsubscribe mailto:redhat-list-request at redhat.com?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/redhat-list/attachments/20040330/9fdd8012/attachment.htm>