<div dir="ltr"><br><div>I want to have MySQL on my laptop with no skip-networking and with</div><div><br></div><div>
<p class=""><span class="">bind-address=127.0.0.1</span></p>
<p class=""><span class=""></span><br></p><p class="">The problem is that the /opt/local/etc/mysql56/macports-default.cnf has skip-networking</p><p class="">The reasoning given is so we can run multiple simultaneous MySQL's side-by-side.</p><p class="">But.. what if I am okay with using just one MySQL and want/need to use a TCP/IP connection to access the database?</p><p class="">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. </p><p class="">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.</p><p class="">Would it be enough to remove the "!include" line from my.cnf? Would the macports-default.cnf then be ignored?</p><p class=""><br></p>
</div></div>