Hello.
Our team has upgraded a few of our mysql servers from 5.0.77 on centos to 5.5.8. Since then mysqlcheck -Ao has been failing with permissions errors: mysqlcheck: Got error: 1142: SELECT,INSERT command denied to user 'root'@'localhost' for table 'XXX' when executing 'OPTIMIZE TABLE ... The error is pretty self-explanatory, but my question is, is this a known issue? Must we go about modifying permissions on the servers we wish to upgrade? I tried to locate this in the changelogs but could not find anything. Thanks.
