Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I uses CentOS on my server that installed from hosting distributive. System works well, but i can't find mysql config to fix some things. I can see only mysql log file named as hostingname.err in /var/lib/mysql folder.

File search: find / -name "*my*cnf" doesn't find any files, exept default configs from /usr/share and default /etc/my.cnf doesn't works after any changes, because it isn't used by Mysqld.

Text search at system files: find / -type f -exec grep «hostingname.err» {} \; doesn't appears any results

Please, help me with any ideas to find correct my cnf that used by Mysql.

Thanks.

share|improve this question
    
mysqladmin variables also doesn't show the location of the mysql config –  Kondmv Jun 21 '13 at 1:24

1 Answer 1

Running /usr/libexec/mysqld --help --verbose should give you the default config files location. The top line of the output should look something like this -

Default options are read from the following files in the given order:
/etc/mysql/my.cnf /etc/my.cnf ~/.my.cnf

If that doesn't work, try running ps aux | grep -i mysqld and see if the default config file has been overridden with the option --defaults-file= to read default options from the given file.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.