Bug #20652 variable skip_grant_table is not listed with show variables

• Submitted: 23 Jun 2006 8:39
• Modified: 23 Jun 2006 10:17
• Reporter: Oli Sennhauser
• Status: Verified
• Category: MySQL Server: General
• Severity: S4 (Feature request)
• Version: 5.0.22
• OS: Any (n.a.)
• CPU Architecture: Any

[23 Jun 2006 8:39] Oli Sennhauser

Description:
skip_grant_table is not listed in show variables. This is a security issue because it cannot be monitored (remotely).

How to repeat:
show variables like 'skip_%';
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| skip_external_locking | ON    |
| skip_networking       | ON    |
| skip_show_database    | OFF   |
+-----------------------+-------+

Suggested fix:
add skip_grant_tables to show variables list.