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 Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Options Severity:S3 (Non-critical)
Version:5.5.18 OS:Any
Assigned to: CPU Architecture:Any
Tags: my.ini my.cnf location
Triage: Needs Triage: D5 (Feature request)

[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.