ERROR 1045: Access denied for user:

[Srinivas Koppisetti]

Where is the mysql instance running?
on localhost or on another machine.

-----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

=========================================================================== 
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. 
===========================================================================