As per usual, I seem to have found the answer after asking for help...
It seems our team did not cleanly remove the old centos packaged versions,
or perhaps there is a bug in the removal scripts. As such, an incorrect
mysqlcheck binary was running and that somehow caused the problems.
--------------------------------------------------
From: "Geoff Galitz" <ge...@galitz.org>
Sent: Thursday, January 06, 2011 10:46 AM
To: <mysql@lists.mysql.com>
Subject: mysql 5.5 optimize changes?
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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
