Mariadb read-only variable

Hello,
could you please advise me how to change read-only variable in mariadb in NS8?
I need to set ft_min_word_len to different value, and I found it is not possible via phpmyadmin. (On NS7 I have set it in /etc/opt/rh/rh-mariadb102/my.cnf, but I guess it is done differently in NS8).
Thanks.

Enter the mariadb instance:

runagent -m mariadb1

Create a config file my.cnf using nano…

podman unshare nano $(podman volume inspect mysql-conf.d --format={{.Mountpoint}})/my.cnf

…and add following content: (adapt to your needs)

[mysqld]
ft_min_word_len = 3

Restart mariadb service/container:

systemctl --user restart mariadb-app

Now the variable should be set as configured.

1 Like