MySQL Forums
Forum List  »  Newbie

Re: ERROR: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
Posted by: Pavel Dedík
Date: January 23, 2008 03:09AM

You must grant "LOCK TABLES" to your user.

GRANT SELECT,LOCK TABLES ON database.* TO 'username'@'localhost';

Pavel

Options: ReplyQuote




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.