You may execute mysql_fix_privileges_table script to upgrade all of your mysqld.
On Thu, Nov 20, 2008 at 7:54 PM, Ronan Lucio <[EMAIL PROTECTED]> wrote: > Hi, > > I installed MySQL-5.0.67_1. > When I execute "CHECK TABLE information_schema.COLUMNS FOR UPGRADE" I get > the message: > > > +----------------------------+-------+----------+------------------------------------------------------------------------------------+ > | Table | Op | Msg_type | Msg_text > | > > +----------------------------+-------+----------+------------------------------------------------------------------------------------+ > | information_schema.COLUMNS | check | error | Table upgrade required. > Please do "REPAIR TABLE `/var/tmp/#sql_43b6_0`" to fix it! | > > +----------------------------+-------+----------+------------------------------------------------------------------------------------+ > > The same occurs for tables ROUTINES, TRIGGERS and VIEWS. > > If I execute "REPAIR TABLE COLUMNS" I got: > > ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database > 'information_schema' > > So I "GRANT ALL ON information_schema.* TO 'root'@'localhost';" > > and got the same error: > > ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database > 'information_schema' > > So I backed to command shell and " mysqlcheck -u root -p --repair > information_schema". > It gives me no error, but the problem persists: > > When I execute "CHECK TABLE information_schema.COLUMNS FOR UPGRADE" I get > the message: > > > +----------------------------+-------+----------+------------------------------------------------------------------------------------+ > | Table | Op | Msg_type | Msg_text > | > > +----------------------------+-------+----------+------------------------------------------------------------------------------------+ > | information_schema.COLUMNS | check | error | Table upgrade required. > Please do "REPAIR TABLE `/var/tmp/#sql_43b6_0`" to fix it! | > > +----------------------------+-------+----------+------------------------------------------------------------------------------------+ > > Any help would be appreciate. > > Thanks, > Ronan > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn