XAMPP MySQL - Setting ft_min_word_len

I have XAMPP installed on my computer, and am using MySQL through it on localhost for a personal project.

I am trying to set the ft_min_word_len variable for fulltext searches in boolean mode to 2 from the default of 4.

I've tried (after stopping MySQL from the XAMPP control panel):

• Opening Shell from the XAMPP control panel, and typing at the prompt:

  mysqld ft_min_word_len=2

  This doesn't appear to have any effect on ft_min_word_len when I check its value afterwards with mysqld --help --verbose (I get an error when I try to use m开发者_开发技巧ysqladmin variables at the prompt).

• Creating a my.cnf file in XAMPP\mysql\bin with this text:

  # The MySQL server

  [mysqld]

  ft_min_word_len=2

  This does appear to change the value of ft_min_word_len when I check its value with mysqld --help --verbose.

  However, when I start MySQL again from XAMPP's control panel, and then check the value of ft_min_word_len through PHPMyAdmin with SHOW VARIABLES LIKE 'ft_min_word_len', it is still 4, both before and after I rebuild the fulltext indexes.

I've tried each approach multiple times, in between stopping and starting MySQL. SHOW VARIABLES LIKE 'ft_min_word_len' did show a value of 2 once, but the next time I stopped and restarted MySQL, the value had returned to 4, and I have been unable to set it to 2 again.

Any pointers in the right direction would be appreciated.

mysql config file would usually be found on in windows your installation drive:\XAMPP\mysql\bin\my.ini or

Linux under etc\my.cnf. if you does not get ft_min_word_len variable below the lines you simply add those line anywhere in the page

[mysqld]

ft_min_word_len = 3

then restart mysql server.

Keep you my.cnf file in <XAMPP>\mysql\bin folder and try again.