Bug #13783 mysqlcheck tries to optimize and analyze information_schema
Submitted: 5 Oct 2005 22:02 Modified: 18 Oct 2005 11:48
Reporter: Markus Popp
Status: Closed
Category:Server Severity:S3 (Non-critical)
Version:5.0.13-rc-nt/BK 5.0.15 OS:Microsoft Windows (Windows XP/Linux)
Assigned to: Sergey Gluhov Target Version:

[5 Oct 2005 22:02] Markus Popp 
Description:
The command mysqlcheck --all-databases --analyze --optimize fails, because it also tries
to analyze and optimize the information_schema tables, which it can't.

How to repeat:
E:\>mysqlcheck --all-databases --analyze --optimize -u root
Enter password: *******
mysqlcheck: Got error: 1044: Access denied for user 'root'@'localhost' to
database 'information_schema' when executing 'OPTIMIZE TABLE ... '

E:\mysql_dump>

Suggested fix:
information_schema should be excluded from this command.
[13 Oct 2005 13:20] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/31016
[13 Oct 2005 16:14] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/31030
[18 Oct 2005 11:24] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/31207
[18 Oct 2005 11:26] Sergey Gluhov 
Fixed in 5.0.15
[18 Oct 2005 11:48] Stefan Hinz 
Added to 5.0.15 changelog.
[6 Nov 2005 20:59] Carsten Wiedmann 
This Bug is still open in the sources for 5.0.15. Will you include this patch in the next
version (5.0.16)?
[13 Nov 2005 21:14] John May 
5.0.15 Standard for OS X does not fix this (non-installer version).

- John
[10 Jan 15:12] Hartmut Holzgraefe 
The actual fix was indeed in 5.0.16 only, not 5.0.15