MySQL Forums
Forum List  »  Newbie

Re: ERROR 1142 (42000): SELECT command denied to user
Posted by: Lee Wood
Date: March 05, 2009 03:16PM

The error msg suggests that you don't have privileges to perform that operation. Take a look, with: SHOW GRANTS FOR 'sqladmin'@'localhost' ;

If it's true that you were able to perform the same operation recently, then clearly someone has changed the privileges.

Options: ReplyQuote


Subject
Written By
Posted
Re: ERROR 1142 (42000): SELECT command denied to user
March 05, 2009 03:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.