Recommended upgrade order

[Bill Christensen]

Just got a successful install of MySQL 5.7.

A couple of notes:  Instead of entering

     sudo -u _mysql mysql_install_db

as was the instruction for MySQL 5.6 and earlier  (
https://trac.macports.org/wiki/howto/MySQL), the instruction sequence is
now:

     sudo /opt/local/lib/mysql57/bin/mysqld --initialize --user=_mysql

which creates the db and assigns a default root password (used to be set to
blank), followed by

   sudo port select mysql mysql57

then

    /opt/local/lib/mysql57/bin/mysql_secure_installation


It might also be helpful to include that when you run

     ps -ax | grep mysql

you should expect to see something along the lines of:


      /opt/local/bin/daemondo --label=mysql57-server --start-cmd
/opt/local/lib/mysql57/bin/mysqld --user=_mysql ; --pid=exec

     /opt/local/lib/mysql57/bin/mysqld --user=_mysql

     grep mysql

if it's running.  If the only response is

   grep mysql

then MySQL hasn't started.

On Sat, Oct 8, 2016 at 4:17 PM, Ryan Schmidt <ryandesign at macports.org>
wrote:

>
>
> > On Oct 8, 2016, at 14:56, Bill Christensen <billc_lists at greenbuilder.com>
> wrote:
> >
> > That may explain the problems I was having when doing a dry-run install
> of MySQL 5.7.
>
> mysql57 installed for me today, so maybe try it again?
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macports.org/pipermail/macports-users/attachments/20161008/8c030f84/attachment-0002.html>