MySQL Forums :: Newbie :: ERROR 1226 (42000) at line 1129: User 'root' has exceeded the 'max_updates' resource (current value: 100)


Advanced Search

ERROR 1226 (42000) at line 1129: User 'root' has exceeded the 'max_updates' resource (current value: 100)
Posted by: MARCELO MARTINEZ ()
Date: July 10, 2014 07:51PM

Hello,

In cPanel server we updated mysql 5.1 to mysql 5.5.50ccl

Now all databases has this error:

Time Action Message Duration / Fetch
0 1 20:15:17 Error loading schema content Error Code: 1548
Cannot load from mysql.proc. The table is probably corrupted

We ran "mysql_upgrade" script, and wen the script try to fix tables privilegies show this error:

Running 'mysql_fix_privilege_tables'...
ERROR 1226 (42000) at line 865: User 'root' has exceeded the 'max_updates' resource (current value: 100)
ERROR 1226 (42000) at line 873: User 'root' has exceeded the 'max_updates' resource (current value: 100)
ERROR 1226 (42000) at line 920: User 'root' has exceeded the 'max_updates' resource (current value: 100)
ERROR 1226 (42000) at line 922: User 'root' has exceeded the 'max_updates' resource (current value: 100)
ERROR 1226 (42000) at line 929: User 'root' has exceeded the 'max_updates' resource (current value: 100)
ERROR 1226 (42000) at line 932: User 'root' has exceeded the 'max_updates' resource (current value: 100)

We executed from mysql shell:

mysql> UPDATE mysql.user SET max_updates=0 WHERE User='root';

But the problem continues.

How to fix this problem please? Any idea?

Thanks in advance.-

Options: ReplyQuote


Subject Written By Posted
ERROR 1226 (42000) at line 1129: User 'root' has exceeded the 'max_updates' resource (current value: 100) MARCELO MARTINEZ 07/10/2014 07:51PM
Re: ERROR 1226 (42000) at line 1129: User 'root' has exceeded the 'max_updates' resource (current value: 100) MARCELO MARTINEZ 07/10/2014 07:53PM
Re: ERROR 1226 (42000) at line 1129: User 'root' has exceeded the 'max_updates' resource (current value: 100) Rick James 07/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.