G
G
glfokin2016-06-13 14:04:57
linux
glfokin, 2016-06-13 14:04:57

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

3 answer(s)
Y
Yuri Chudnovsky, 2016-06-13
@glfokin

Since you made a typo and don't remember where, look for a typo all over /etc:
grep -R connextions /etc/

V
vladimirchelyabinskiy, 2016-06-15
@vladimirchelyabinskiy

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.

M
Melkij, 2016-06-13
@melkij

max_conne ctions Where mysql
looks for its configs:
mysql --verbose --help
You need an output snippet like this:

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question