对于Ubuntu 20.04.4 LTS上的MariaDB 10.5 (Focal Fossa):

# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 0. "/etc/mysql/my.cnf" symlinks to this file, reason why all the rest is read.
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.

所有很棒的建议，在我的情况下，我没有在任何这些位置找到它，但在/usr/share/mysql，我有一个RHEL虚拟机，我安装了mysql5.5

如果您正在使用MAMP，请访问模板> MySQL (my.cnf) > [version]

如果您正在运行MAMP无窗口，您可能需要使用customize按钮定制工具栏。

Ubuntu 16: /etc/mysql/mysql.conf.d/mysqld.cnf

这取决于你的权限但对我来说 这个工作在phpmyadmin SQL控制台

显示变量;

然后改变一些变量 你可以这样做

SET GLOBAL max_connections = 1000;

or

设置@@GLOBAL。Max_connections = 1000;

试试吧

mysql --help | grep /my.cnf | xargs ls

会告诉你my.cnf在Mac/Linux上的位置吗

ls: cannot access '/etc/my.cnf': No such file or directory
ls: cannot access '~/.my.cnf': No such file or directory
 /etc/mysql/my.cnf

在本例中，它在/etc/mysql/my.cnf中

ls: /etc/my.cnf: No such file or directory
ls: /etc/mysql/my.cnf: No such file or directory
ls: ~/.my.cnf: No such file or directory
/usr/local/etc/my.cnf

在本例中，它位于/usr/local/etc/my.cnf