How to increase max_questions limit

[Manojb]

Hello,

I am getting the following error message which accessing my database through DBWeb Admin :-

#1226 - User '*****' has exceeded the 'max_questions' resource (current value: 100)

How can I increase max_questions limit

 

[DmitryT]

'max_questions' is the column of mysql.user table, so you should be able to increase it from MySQL directly with the query like:

> UPDATE mysql.user SET max_questions = 'new_value' where User = 'user_name';

new_value - is the increased value (> 100);
user_name - the problem user login (marked as ****** in your post)...

 

[Manojb]

Hello DmitryT,

Thanks for your updated.

I have updated the max_questions limit but it still comes with the same error message.

#1226 - User '*****' has exceeded the 'max_questions' resource (current value: 100)

The database user is still using the old limit. Do I have to change some admin privileges to fix this.