Rajeev Prasad (resolved) Re: user not able to login from localhost
Sep 24, 2012; 14:17
Rajeev Prasad
(resolved) Re: user not able to login from localhost
friends,? i figure that i had to give password in quotes. i was then able to login. thank you all for your help and time.
________________________________ From: Rajeev Prasad <rp.neuli@yahoo.com> To: Rick James <rjames@yahoo-inc.com>; mysql list <mysql@lists.mysql.com> Sent: Monday, September 24, 2012 4:11 PM Subject: Re: user not able to login from localhost
________________________________ From: Rick James <rjames@yahoo-inc.com> To: Rajeev Prasad <rp.neuli@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 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 Message----- > From: Rajeev Prasad [mailto:rp.neuli@yahoo.com] > Sent: Monday, September 24, 2012 10:56 AM > To: mysql list > Subject: user not able to login from localhost > > 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?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:? ? http://lists.mysql.com/mysql
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!