MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: ERROR 1226 (42000) at line 1129: User 'root' has exceeded the 'max_updates' resource (current value: 100)
Posted by: Rick James
Date: July 12, 2014 09:36AM

Read all of this thread:
http://forums.mysql.com/read.php?10,422793,422793
(It may or may not be relevant to your problem.)

I do not see 'max_updates' anywhere in any version. So I am struggling to figure out where that comes from. Aha... mysql.user.max_updates is a field that comes from GRANT ... MAX_UPDATES_PER_HOUR?? If so then follow this advice!...

* Do _not_ use "root" as the login for your application; make a login just for it.
* Keep "root" for administration purposes only.
* Give root unrestricted access.

Meanwhile, you can GRANT root more privilege to get the upgrade finished.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
ERROR 1226 (42000) at line 1129: User 'root' has exceeded the 'max_updates' resource (current value: 100)
MARCELO MARTINEZ
July 10, 2014 07:51PM
Re: ERROR 1226 (42000) at line 1129: User 'root' has exceeded the 'max_updates' resource (current value: 100)
MARCELO MARTINEZ
July 10, 2014 07:53PM
Re: ERROR 1226 (42000) at line 1129: User 'root' has exceeded the 'max_updates' resource (current value: 100)
Rick James
July 12, 2014 09:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.