MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Geoff Galitz Date:January 6 2011 10:21am
Subject:Re: mysql 5.5 optimize changes?
View as plain text  

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" <geoff@stripped>
Sent: Thursday, January 06, 2011 10:46 AM
To: <mysql@stripped>
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 5.5 optimize changes?Geoff Galitz6 Jan
  • Re: mysql 5.5 optimize changes?Geoff Galitz6 Jan