Hello
Christian Hammers a écrit :
Hi
Mediaforest a écrit :
When I run mysqlcheck, I always get : Table upgrade required. Please do "REPAIR
TABLE x " to fix it for two
tables, always the same, even if I repair those tables just before, I always
get the same warning...
Please try "CHECK TABLE xyz FOR UPGRADE;" this could work.
I've tried "CHECK TABLE xyz FOR UPGRADE;"
and I got the message "Table upgrade required. Please do "REPAIR TABLE `xyz`" to fix
it!"
So I tried : "REPAIR TABLE `xyz`", and I got the message "Table is already up to
date"
but I got once again : Error 1045 (28000): Access denied for user:
'root'@'@localhost' (password: NO)
This two '@' look strange. Check the mysql.user and mysql.db tables, you should
not have an '@' in the host columns.
I checked the user and db tables and there isn't any '@' in the host column
Else open a bug report at bugs.mysql.com and send them the "SHOW CREATE TABLE"
and the binary file from
/var/lib/mysql/, maybe their CHECK TABLE is broken in certain cases.
I'm going to try this ;)
Thanks a lot.
