If you are on RedHat, you might need to do mysql> grant all on books.* to [EMAIL PROTECTED] identified by 'bookorama123';
Ken Norman Zhang wrote: > > Hi, > > I assigned rights to a user in mysql, > > mysql> grant all on books.* to bookorama@localhost identified by > 'bookorama123'; > > Then I tried to access mysql in as a regular user, > > [bookorama@a177 bookorama]$ mysql -u bookorama books -p; > Enter password: bookorama123 > > And I get the following error message, > > ERROR 1045: Access denied for user: 'bookorama@localhost' (Using password: > YES) > > Would someone please help me how to troubleshoot this? > > Thanks, > Norman > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php