this is what i see: | GRANT USAGE ON *.* TO 'myuser'@'localhost' IDENTIFIED BY PASSWORD '*829E20779862ACF47E2B4D9B7C6B1B1B1ADF7925' | | GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON `mydatabase`.* TO 'myuser'@'localhost' | +-----------------------------------------------------------------------------------------------------------------+
I am using phpmyadmin to manage mysql, including user privileges. ________________________________ From: Ben Mildren <ben.mild...@gmail.com> To: Rajeev Prasad <rp.ne...@yahoo.com> Cc: mysql list <mysql@lists.mysql.com> Sent: 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 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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
