Which password on mysql upgrade?

Murray Eisenberg murrayeisenberg at gmail.com
Fri Oct 27 16:26:57 UTC 2017

I’m upgrading msql56 -> mysql57.

Step 6 in Documentation at https://trac.macports.org/wiki/howto/MySQL <https://trac.macports.org/wiki/howto/MySQL> says:

  "If the database exists from a previous installation, you may need to upgrade.”

After unloading mysql57-server, as recommended there I execute:

    sudo /opt/local/lib/mysql57/bin/mysql_upgrade -u root -p

After Question: which password should be entered in response to the prompt: my macOS admin account’s password or the mysql root’s password?

Or, if both are required, which do I enter first?

If I just enter my macOS admin account’s password, I get error”

   mysql_upgrade: 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
  Upgrade process encountered error and will not continue.

On the other hand, if I start mysql57-server and then execute

   mysql -u root -p

and give the mysql database root password, I can successfully interact with the mysql sever (e.g., “show databases”).

Murray Eisenberg			murrayeisenberg at gmail.com
503 King Farm Blvd #101	Home (240)-246-7240
Rockville, MD 20850-6667	Mobile (413)-427-5334

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macports.org/pipermail/macports-users/attachments/20171027/eadc4e97/attachment.html>

More information about the macports-users mailing list