[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

RE: ERROR 1045: Access denied for user:



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

-----Original Message-----
From: Michael S. Dunsavage [mailto:mikesd frontiernet net]
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 mailto:redhat-list-request 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. 
=========================================================================== 




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]