On Mon, Sep 24, 2012 at 1:55 PM, Rajeev Prasad <rp.ne...@yahoo.com> 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
- mdyk...@gmail.com
May the Source be with you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
