List:General Discussion« Previous MessageNext Message »
From:Rick James Date:September 24 2012 7:09pm
Subject:RE: user not able to login from localhost
View as plain text  
That says that your password in not correct.  You have not gotten to specific privileges.

Did you previously do
GRANT ... TO myuser@localhost IDENTFIED BY '...';
?

If you can get in via root, do
SHOW GRANTS FOR myuser@localhost;
SELECT * FROM mysql.user WHERE user = 'myuser';

> -----Original Message-----
> From: Rajeev Prasad [mailto:rp.neuli@stripped]
> Sent: Monday, September 24, 2012 10:56 AM
> To: mysql list
> Subject: user not able to login from localhost
> 
> i have given select/insert/update/delete rights to a user on a specific
> database, from localhost. when i try to login to mysql using the uid, i
> get error:
> 
> 
> 
> ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
> password: YES)
> 
> 
> what other privilege do i need to give this user?
Thread
user not able to login from localhostRajeev Prasad24 Sep
  • RE: user not able to login from localhostRick James24 Sep
    • Re: user not able to login from localhostBen Mildren24 Sep
      • Re: user not able to login from localhostRajeev Prasad24 Sep
    • Re: user not able to login from localhostRajeev Prasad24 Sep
      • (resolved) Re: user not able to login from localhostRajeev Prasad24 Sep
  • Re: user not able to login from localhostMichael Dykman24 Sep