Re: Can't access Administrator because "max_questions" exceeded
Posted by: Mike Thomas
Date: July 13, 2005 08:22AM

The setting for the users are stores in the 'mysql' database in a table called User. In the User table is a field called 'max_questions'. Using the command line interface, you can change the values for each user.

Login to mysql using the command line interface.

type: USE mysql

UPDATE User SET max_questions=0;

That will remove the limits for all users in the table (or specify a user in a WHERE clause)

I had to restart mysql for the change to take.

Hope this helps.

Options: ReplyQuote


Subject
Written By
Posted
Re: Can't access Administrator because "max_questions" exceeded
July 13, 2005 08:22AM


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.