mysql 5.5 optimize changes?

------=_NextPart_000_025F_01CBAD8E.EA1929B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



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 ...=20

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.



------=_NextPart_000_025F_01CBAD8E.EA1929B0--

Re: mysql 5.5 optimize changes?

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"
Sent: Thursday, January 06, 2011 10:46 AM
To:
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=gcdmg-mysql-2@m.gmane.org