MySQL错误–用户超出了"Max_questions"资源(当前值:1000) [英] MySQL Error – User has Exceeded The ‘Max_questions’ Resource (Current Value: 1000)

问题描述

我有一个使用MySQL数据库的Rails 3应用程序.在我的应用程序测试阶段，我正在插入大量数据以检查我的应用程序的功能.插入大量条目后，我得到了类似Mysql的错误，

Mysql2::Error: User 'Databasename' has exceeded the 'max_questions' resource (current value: 10000): SELECT  `users`.* FROM `users`  WHERE `users`.`username` = 'admin' LIMIT 1

如何解决此错误.Mysql中是否有任何限制?

感谢任何帮助.

解决方案

出于测试目的，您可以定义它，例如:

SET @MAX_QUESTIONS=<your new value>; 

在MySQL中

或:

update user set max_questions = 10000 where user = 'you name or root';

如果您将0替换为max_questions，则表示无限制

注意:您可能必须重新启动Mysql服务器才能生效

---

当然，您可以清除特权:

FLUSH PRIVILEGES;

I have a Rails 3 Application which uses MySQL Database.In my application Testing phase i am inserting lots of data for checking functionality of my application.After inserting lots of entries i am getting Mysql error like,

Mysql2::Error: User 'Databasename' has exceeded the 'max_questions' resource (current value: 10000): SELECT  `users`.* FROM `users`  WHERE `users`.`username` = 'admin' LIMIT 1

How to solve this error.Is there any Limit in Mysql ,if so how to override this.

Any help is Appreciated..

解决方案

for testing purposes you can define it such as:

SET @MAX_QUESTIONS=<your new value>; 

in MySQL

or:

update user set max_questions = 10000 where user = 'you name or root';

if you put 0 for max_questions - it means unlimited

Note: You may have to restart you Mysql server to take effect

---

of course you can just flush privileges:

FLUSH PRIVILEGES;

这篇关于MySQL错误–用户超出了"Max_questions"资源(当前值:1000)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！