From: Rick James
Date: September 24 2012 7:09pm
Subject: RE: user not able to login from localhost
List-Archive: http://lists.mysql.com/mysql/228255
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB148CF91A2A@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

That says that your password in not correct.  You have not gotten to specif=
ic 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 =3D '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
>=20
> 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:
>=20
>=20
>=20
> ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
> password: YES)
>=20
>=20
> what other privilege do i need to give this user?