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.ne...@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