List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:September 24 2012 7:10pm
Subject:Re: user not able to login from localhost
View as plain text  
On Mon, Sep 24, 2012 at 1:55 PM, Rajeev Prasad <rp.neuli@stripped> wrote:
> 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?

The permission set you describe should be complete, so look more
closely at what was actually granted and how you are trying to log in.

The obvious questions:

How did you create and grant privileges to that user? Did you use:

grant select,insert,update,delete on mydb.* to mysql@localhost
identified by password('password');

or what variant exactly?

When you are trying to log in, are you doing that explicitly from the
same server or are you accessing remotely?

-- 
 - michael dykman
 - mdykman@stripped

 May the Source be with you.
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