如何建立新的mysql服务器连接？ [英] How to make new mysql server connection?

问题描述

以前服务器已连接但在更改设置后我收到错误 - 用户'root'已超出'max_questions'资源（当前值：100）。

我该怎么办？从Mysql workbentch再次更改限制？

Previously the server was connected but after making the change in settings I am getting the error as - User 'root' has exceeded'max_questions' resource(current value:100).
How should I change the limit again from Mysql workbentch?

推荐答案

看看这里： http://stackoverflow.com/questions/14873094/mysql-error-user-has-exceeded-the-max-questions- resource-current-value-100 [ ^ ]

试试：

try:

update user set max_questions = 10000 where user = 'root'

如果你输入0，则意味着无限制。

执行查询SET @ max_questions = 0为我工作。

Executing the query "SET @max_questions=0" worked for me.

这篇关于如何建立新的mysql服务器连接？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！