Skip to content

Instantly share code, notes, and snippets.

@youtux
Created June 22, 2020 06:55
Show Gist options
  • Select an option

  • Save youtux/02d02300d968423add1e60f45968f75f to your computer and use it in GitHub Desktop.

Select an option

Save youtux/02d02300d968423add1e60f45968f75f to your computer and use it in GitHub Desktop.
MySQL configuration with query log and fix for mac os file limit
# Default Homebrew MySQL server config
[mysqld]
# Only allow connections from localhost
bind-address = 127.0.0.1
general_log_file = /usr/local/var/mysql/Argon.local.log
general_log = ON
# Since MySQL 5.6 innodb_file_per_table option is ON by default,
# which means that each table's data is stored in its own file.
# OSX default limit of the number of the open files is 256 per process.
# This will cause errors like "ERROR 2013 (HY000): Lost connection to MySQL server at 'sending authentication information', system error: 32"
# when connecting to mysql
innodb_file_per_table = OFF
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment