Bug #20443 /etc/my.cnf not syncronized with "./configure --prefix=[DIR]"
Submitted: 13 Jun 2006 22:08 Modified: 13 Jun 2006 22:16
Reporter: Kevin Benton (Candidate Quality Contributor) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.20 OS:Linux (Linux RHEL3.7)
Assigned to: CPU Architecture:Any

[13 Jun 2006 22:08] Kevin Benton 
Description:
mysqld looks at /etc/my.cnf always.

How to repeat:
configure --prefix=/x/y/z

or 

configure --prefix=/x/y/z --sysconfdir=/x/y/z/etc

then

make
make install

/x/y/z/bin/mysqld --help --verbose | head -11 | tail -2

Suggested fix:
It seems to me that either of these should change the location of the my.cnf file from /etc/my.cnf to /x/y/z/my.cnf, however, neither does.

mysqld reports the my.cnf search order as follows (using mysqld --verbose --help) after each of the builds from above

/etc/my.cnf /x/y/z/var/my.cnf ~/.my.cnf

As a result, I suggest that each program that relies on /etc/my.cnf be repaired so that it honors both --prefix and --sysconfdir
[13 Jun 2006 22:13] Kevin Benton 
Correction - the path should change to /x/y/z/etc/my.cnf, not /x/y/z/my.cnf as reported above.
[13 Jun 2006 22:16] Hartmut Holzgraefe 
Duplicate, and intended behavior, see bug #4993 and #8649