• How to configure FT_MIN_WORD_LEN

    • views 1245

    Programmer asked to change the MySQL configuration ft_min_word_len (from the default values ​​"3" to "1"). I wrote to the technical support, but I`ve been already waiting for an answer for twenty-four hours. How can I configure this option by myself?

    Solutions (2)
    Hi! If you have shared hosting, you can`t change it by yourself, because you need root access.  you can only change this yourself on a VPS or dedicated server, it needs to be changed in the /etc/my.cnf file.
    If the UPU in the mysql config file (usually /etc/my.cnf - Centos, /etc/mysql/my.cnf -Debian / Ubuntu) ft_min_word_len change the value from 3 to 1. If there is no option to add a line in the config ft_min_word_len = 3. Restart the database server.
    Answers (2)
    You can`t do it yourself on a shared hosting. Waiting 24 hours for service means your hosting provider isn`t the best. It`s worth thinking about switching :) On VPS hosting you can change it in the MySQL configuration file.
    Hi, you don`t specify the service you use. If you have shared hosting, the parameters can be changed only upon request to the Help Desk with their approval. I would recommend that you order a VDS server, then you can solve these problems by yourself in 5 minutes.
We do our best for you!
Rate the article
Tell the world about it

Users (0) 0 of 5

  • In order to provide you with the best online experience this website uses personal data (cookies, IP, email, photo, name, website, etc). By using our website, you agree to our use of your personal data. More info we receive some monetary compensation from hosting companies, however, this does not influence their positions in our ratings, test results, the direction or conclusions of our reviews in any way. We use this amount to provide better services, improve our website, to cover hosting testing account fees and team salaries. Ok

  • easy


    We ban anonymous users since 2016


    We do not delete reviews for money
    We do not sell rating positions
    We make cheating attempts almost impossible


    We test the hosting thoroughly and publish professional overviews
  • Rewards for reviews