Answer the question
In order to leave comments, you need to log in
How to find mysql config?
Good afternoon.
Zabbix appliance on OpenSUSE. There was a need to change the settings for accessing the database.
When trying to connect, the client gives the following error: mysql: unknown variable 'max_connextions=300'
I remember that I changed this variable at one time, but where - how otshiblo.
There is nothing similar in /etc/my.cnf. The /etc/mysql/ directory is also missing. There is no config in /root.
cat /proc/$(pidof mysqld)/cmdline | tr '\0' '\n'
/usr/sbin/mysqld
--user=mysql
--group=mysql
--innodb_file_format=Barracuda
--innodb_file_per_table=ON
--log_bin=mysql-bin
--expire_logs_days=1
--server-id=1
--sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
--plugin-load=blackhole=ha_blackhole.so;federated=ha_federated.so;archive=ha_archive.so
Answer the question
In order to leave comments, you need to log in
Since you made a typo and don't remember where, look for a typo all over /etc:grep -R connextions /etc/
In the mysql config 100% there should be the word [mysqld] [myisamchk]
or port 3306, look for this text in the entire server directory and you will stumble upon the config.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question