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@xxxxxxxxxxxxxxx]
Sent: Tuesday, March 30, 2004 1:48 PM
To: redhat-list@xxxxxxxxxx
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@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@xxxxxxxxxx?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list
-- redhat-list mailing list unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list
