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
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
Also ensure you issue: FLUSH PRIVILEGES; after making any changes to
permissions..
On 24 September 2012 20:09, Rick James rja...@yahoo-inc.com wrote:
That says that your password in not correct. You have not gotten to specific
privileges.
Did you previously do
GRANT ... TO myuser@localhost
: Monday, September 24, 2012 2:49 PM
Subject: Re: user not able to login from localhost
Also ensure you issue: FLUSH PRIVILEGES; after making any changes to
permissions..
On 24 September 2012 20:09, Rick James rja...@yahoo-inc.com wrote:
That says that your password in not correct. You have
looging in from the same server.
From: Rick James rja...@yahoo-inc.com
To: Rajeev Prasad rp.ne...@yahoo.com; mysql list mysql@lists.mysql.com
Sent: Monday, September 24, 2012 2:09 PM
Subject: RE: user not able to login from localhost
That says that your
, 2012 4:11 PM
Subject: Re: user not able to login from localhost
mysql SELECT * FROM mysql.user WHERE user ='myuser