Bug #65343 Please expose --skip-grant-tables as a variable
Submitted: 16 May 2012 20:13 Modified: 17 May 2012 3:19
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Options Severity:S3 (Non-critical)
Version:any OS:Any
Assigned to: CPU Architecture:Any
Tags: qc

[16 May 2012 20:13] Peter Laursen 
Description:
Please expose --skip-grant-tables option as a variable. This is important for security monitoring.

How to repeat:
see above

Suggested fix:
see above
[22 May 2012 6:16] MySQL Verification Team 
As a workaround, and note for the implementation, FLUSH PRIVILEGES should clear the variable skip-grant-tables.  To determine if skip-grant-tables is in effect, just try creating a user for example.

mysql> create user 'dummy'@'dummy';
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
mysql> flush privileges;
Query OK, 0 rows affected (1.17 sec)

mysql> create user 'dummy'@'dummy';
Query OK, 0 rows affected (0.01 sec)