Re: Can't access Administrator because "max_questions" exceeded
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.
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.