Bug #63452 Show currently used my.ini/mycnf directory location

• Submitted: 28 Nov 2011 5:59
• Modified: 28 Nov 2011 17:07
• Reporter: Peter Steiner
• Status: Verified
• Category: MySQL Server: Options
• Severity: S3 (Non-critical)
• Version: 5.5.18
• OS: Any
• CPU Architecture: Any
• Tags: my.ini my.cnf location

[28 Nov 2011 5:59] Peter Steiner

Description:
Users should be able to ask MySQL engine for the directory location of its currently used my.ini/my.cnf location.

Yes, I know there is a pre-defined search sequence in windows home directory and then in installation directory for either my.cnf or my.ini.

But fiddling around which of these files exist is very unhandy.

How to repeat:
Bug is the non-existance itself

Suggested fix:
So MySQL should provide a query similar to that of showing the data directory location:

select @@datadir;

Now introduce:

select @@configdir;

Thank you
Peter Steiner

[28 Nov 2011 17:07] Valeriy Kravchuk

Thank you for the feature request. 

Alternatively it would be nice to show the origin of variable's value in SHOW VARIABLES results or corresponding tables in the INFORMATION_SCHEMA.