[MacPorts] howto/MySQL modified

[MacPorts Wiki]

Page "howto/MySQL" was changed by WolfgangFahl
Diff URL: <https://trac.macports.org/wiki/howto/MySQL?action=diff&version=16>
Revision 16
Changes:
-------8<------8<------8<------8<------8<------8<------8<------8<--------
Index: howto/MySQL
=========================================================================
--- howto/MySQL (version: 15)
+++ howto/MySQL (version: 16)
@@ -210,5 +210,18 @@
 The following stackoverflow question has an answer that shows how you can modify the corresponding plist to give you the stderr output of the mysql server daemon:
 * https://apple.stackexchange.com/questions/231264/mysql-fails-to-load-on-boot
 
+== mysql_upgrade fails ==
+You might end up in a catch22 if your mysql server doesn't want to start due to a failure message like:
+{{{
+Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
+}}
+then trying to run upgrade might give you:
+{{{
+sudo /opt/local/lib/mysql57/bin/mysql_upgrade -u root -p
+Enter password: 
+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.
+}}}
+Please add a solution here if you find one.
 
 [wiki:howto <- Back to the HOWTO section]
-------8<------8<------8<------8<------8<------8<------8<------8<--------

--
Page URL: <https://trac.macports.org/wiki/howto/MySQL>
MacPorts <https://www.macports.org/>
Ports system for macOS

This is an automated message. Someone added your email address to be
notified of changes on 'howto/MySQL' page.
If it was not you, please report to admin at macports.org.