I have a Debian 11 server and have been looking all day for the sql_mode line in one of the many sql configuration files. I can not find it anywhere. I am wondering if anyone here knows where it is or if Hestia moved it to some special place? I am also wondering what the current version of maria db Hestia is using?
I am running 10.6.7-MariaDB-1:10.6.7+maria~bullseye if that makes any difference.
I am using Debian 11
$ which mysqld in Debian 11 returns
/usr/sbin/mysqld
Then, we use this path to execute the lookup:
$ /usr/sbin/mysqld --verbose --help | grep -A 1 “Default options”
Debian 11 returns:
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf
However none of these four files includes the setting for sql_mode or sql-mode which is why I am asking if anyone here knows where it might be located.
/etc/mysql/my.conf is the default one
~/.my.cnf is used to login as root if you run mysql -u root
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.