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

This is my first question. I am using plesk server with multiple sites running. I want to set ft_min_word_len=3 for full text search. I have found that i have to change the option file but problem is that I am not being able to find out the file my.cnf. I have come to know that this file is found either in /etc/ or /home/mydir/ but do not know how and where to check this file. Hope to get your answer.

Thanks in advance.

share|improve this question

5 Answers 5

You can use nice Unix tools such as Locate ou Find to find that file.

To use the locate tool, first generate the database :

updatedb

Then search for the file

locate my.cnf

share|improve this answer

Or, to find it faster then messing with locate (the DB should actually be automatically kept fairly up to date) try this:

find /etc -name my.cnf
find ~ -name my.cnf

One of those should print a line showing where my.cnf is.

share|improve this answer

Run "ps -eF" to see the command line being passed to the mysql process. If it's a non-standard config file it should appear there. If it isn't a listed option it will use the compile time default for mysql, which is normally dependent on the OS mysql package (rpm etc.) rather than plesk.

share|improve this answer
find / -name my.cnf -type f -print

should do it, but it might run slow.

share|improve this answer

The path is: /etc/mysql/my.cnf

share|improve this answer

Your Answer

 
discard

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