<div dir="ltr"><br><div class="gmail_quote"><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><span class="">On Mon, Jul 25, 2016 at 12:57 PM, Ryan Schmidt <span dir="ltr"><<a href="mailto:ryandesign@macports.org" target="_blank">ryandesign@macports.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><span><br>
> On Jul 25, 2016, at 2:04 AM, Bill Christensen <<a href="mailto:billc_lists@greenbuilder.com" target="_blank">billc_lists@greenbuilder.com</a>> wrote:<br>
><br>
> Hi folks,<br>
><br>
> in the instructions at <a href="https://trac.macports.org/wiki/howto/MySQL" rel="noreferrer" target="_blank">https://trac.macports.org/wiki/howto/MySQL</a> (written to MySQL56, though I'm using the same instructions to install MySQL57 instead), it says to run<br>
><br>
> sudo -u _mysql mysql_install_db<br>
><br>
> Doing so for MySQL57 gives the message:<br>
><br>
> [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize<br>
><br>
> I tried<br>
><br>
> sudo -u _mysql mysqld --initialize<br>
><br>
> but that gave me<br>
><br>
> [ERROR] --initialize specified but the data directory has files in it. Aborting.<br>
><br>
> which appears to be true.... Is there a different command I should be using, or are there some missing options which need to be specified?<br>
<br>
</span>Did you check <a href="https://trac.macports.org/wiki/howto/MySQL#mysql_upgrade" rel="noreferrer" target="_blank">https://trac.macports.org/wiki/howto/MySQL#mysql_upgrade</a> ?<br>
<span><br></span></blockquote><div> </div></span><div>No, I hadn't, as the db install is new and I was following the instructions from the top down. I hadn't gotten that far yet. </div><div><br></div><div><span>running </span></div><div><span style="font-size:13px;color:rgb(0,0,0);background-color:rgb(247,247,247)"> sudo /opt/local/lib/mysql56/bin/mysql_upgrade -u root -p </span><br></div><div><span style="font-size:13px;color:rgb(0,0,0);background-color:rgb(247,247,247)">results in </span></div><div><span style="font-size:13px;color:rgb(0,0,0);background-color:rgb(247,247,247)"> </span>Got error: 2002: Can't connect to local MySQL server through socket '/opt/local/var/run/mysql57/mysqld.sock' (2) while connecting to the MySQL server</div>
<div><br></div><div> </div></div></div></div>
</div><br></div>