Skip to content

Instantly share code, notes, and snippets.

@bbrown

bbrown/my.cnf

Created September 14, 2017 13:51
Show Gist options
  • Star 6 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save bbrown/73d6975ac7324141dd934d325f7cd358 to your computer and use it in GitHub Desktop.
Save bbrown/73d6975ac7324141dd934d325f7cd358 to your computer and use it in GitHub Desktop.
Download ZIP
Local Mac OS X MySQL configuration, designed to get around "File Descriptor 2040 exceeded FD_SETSIZE=1024" errors
Raw
my.cnf
# Default Homebrew MySQL server config
[mysqld]
#interactive_timeout = 300
#wait_timeout = 300
max_allowed_packet=256M
table_open_cache=250
# Only allow connections from localhost
bind-address = *
#skip-networking
@Felixbachmann
Copy link

You are a life-saver!
Just run into the problem with MAMP5 and mysql 5.7 on my development machine.
Solved the issue
Many thanks

@bbrown
Copy link
Author

bbrown commented Sep 2, 2020

You're welcome! I had forgotten I even did this so I'm glad it proved helpful.

@ChaoticDalo
Copy link

I've never had an issue with MySQL and Brew until just now. Kept getting db connection issues and all sorts of random weirdness. Sometimes it'd work and then it wouldn't. This is my second day pissing around trying different versions and this was the fix. So Many THANKS to you :-)

@bbrown
Copy link
Author

bbrown commented Mar 7, 2023

HAH, I'd forgotten I did this again. I'm still glad it's useful after all these years.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment