<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2655.72"> <TITLE>RE: ERROR 1045: Access denied for user: </TITLE> </HEAD> <BODY> 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 [<A HREF="mailto:mikesd@frontiernet.net">mailto:mikesd@frontiernet.net</A>] Sent: Tuesday, March 30, 2004 1:48 PM To: redhat-list@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@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 <A HREF="mailto:redhat-list-request@redhat.com?subject=unsubscribe">mailto:redhat-list-request@redhat.com?subject=unsubscribe</A> <A HREF="https://www.redhat.com/mailman/listinfo/redhat-list" TARGET="_blank">https://www.redhat.com/mailman/listinfo/redhat-list</A> </BODY> </HTML>