1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

How to increase max_questions limit

Discussion in 'Plesk for Windows - 8.x and Older' started by Manojb, Oct 26, 2007.

  1. Manojb

    Manojb Guest

    0
     
    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
     
  2. DmitryT

    DmitryT Guest

    0
     
    '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)...
     
  3. Manojb

    Manojb Guest

    0
     
    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.
     
Loading...