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