User 'root' has exceeded the 'max_questions' resource 1

I was checking mysql by mistake i updated the (max_questions =1) . Now i searched over google and stack overflow for this solution every one has a answer like ,

UPDATE mysql.user SET max_questions=0 WHERE User='root';
SET CHARACTER SET 'utf8'; SELECT @@character_set_client;
GRANT USAGE ON *.* TO 'root'@'localhost' WITH MAX_QUERIES_PER_HOUR 0;

but no one is giving the answer that where to execute these query because phpmyadmin is showing this error Error

SQL query: Edit Edit

SET CHARACTER SET 'utf8';

MySQL said: Documentation

1226 - User 'root' has exceeded the 'max_questions' resource (current value: 1)

Answers


In mysql you use the mysql db, e.g.

use mysql;
update user set max_questions=0 where user = 'root';

where 0 is unlimited. Could be smaller number but in development I use 0.

Need Your Help

How to intelligently degrade or smooth GIS data (simplifying polygons)?

algorithm geometry gis postgis

I have detailed US county maps, from the TIGER LINE data sets. How might I sample, smooth, or degrade the data so that I get straighter, more boxy, less "noisy" shapes to represent the geographical

Windows server 2008 x86 install fails

windows windows-server-2008

A students install is failing after he enters the key with error