Where is the mysql instance running? on localhost or on another machine. -----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 =========================================================================== This electronic transmission contains confidential information intended only for the person(s) named. Any use, distribution, copying, or disclosure by any other person is strictly prohibited. If you received this transmission in error, please notify the sender by return e-mail and delete all copies of this message. =========================================================================== -- redhat-list mailing list unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list
