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