On Feb 24, 2016, at 5:10 PM, David Herron wrote: > I want to have MySQL on my laptop with no skip-networking and with > > bind-address=127.0.0.1 > > > > The problem is that the /opt/local/etc/mysql56/macports-default.cnf has > skip-networking > > The reasoning given is so we can run multiple simultaneous MySQL's > side-by-side. > > But.. what if I am okay with using just one MySQL and want/need to use a > TCP/IP connection to access the database? > > As it is, the MacPorts MySQL sets skip-networking in a file which will be > overwritten whenever I upgrade (via selfupdate or whatever). Which means > even if I commented out skip-networking, it can reappear some later time and > I might not remember about this setting. > > That's what just happened to me. I remember now a few weeks ago having > pulled my hair out over why I couldn't access MySQL, and then finding the > skip-networking option and commenting it out. Then today I again spent most > of the day tearing my hair out, then finding that option had mysteriously > uncommented itself. > > Would it be enough to remove the "!include" line from my.cnf? Would the > macports-default.cnf then be ignored?
Yes, if you don't want the behavior of the macports default config, don't include it in your my.cnf. Your my.cnf file is yours to edit; MacPorts won't touch it. _______________________________________________ macports-users mailing list [email protected] https://lists.macosforge.org/mailman/listinfo/macports-users
