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]
