> On Feb 24, 2016, at 5:31 PM, Ryan Schmidt <[email protected]> wrote: > > > 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.
David, I feel your pain, we tried to make it clear in the notes, perhaps the notes could be improved: port notes mysql56 Regards, Bradley Giesbrecht (pixilla) _______________________________________________ macports-users mailing list [email protected] https://lists.macosforge.org/mailman/listinfo/macports-users
