How to change MySQL's ft_min_word_len in Windows?

Question

None of the solutions suggested to reduce MySQL's ft_min_word_len works for me on Windows 7 Pro.

In Control Panel Services the path to MySQL56 server executable reads "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56 Both files at "C:\windows\my.ini" and at "C:\Program Files\MySQL\MySQL Server 5.6\my.ini" reads

[mysqld]
ft_min_word_len = 3

In MySQL, the query SHOW VARIABLES LIKE 'ft_min_word_len'; still shows 4!!!

After changing in the `my.ini` file, do you restarted MySQL service? — wchiquito, Aug 13 '15 at 14:17
Sorry I didn't specify but of course I restart MySQL after every attempt to change the config files. — EdNdee, Aug 13 '15 at 14:42

score 0 · Answer 1 · answered Aug 13 '15 at 15:09

0

My bad!!! I was changing the file at "C:\Windows\my.ini" and "C:\Program Files\MySQL\MySQL Server 5.6\my.ini" instead of the correct one at "C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" as per the path to MySQL56 server executable which reads "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56.

Now working as expected!

answered Aug 13 '15 at 15:09

EdNdee

745
1
10
18

I assume you also explicitly rebuilt the FT indexes? – Rick James Aug 16 '15 at 01:09

How to change MySQL's ft_min_word_len in Windows?

1 Answers1