restart MySQL Server on MacOSX after Sierra Upgrade
After each upgrade of MacOS X, MySQL won't restart, as the upgrade process delete the logging directory of MySQL : If you try to run mysqld_safe manually, you'll get cristal clear error : [10:45] tmanson@busyboxy:/usr/local/mysql/bin$ ./mysqld_safe ./mysqld_safe: line 544: /usr/local/mysql/data/mysqld_safe.pid: Permission denied awk: i/o error occurred while closing /dev/stdout input record number 3, file source line number 1 161116 10:46:07 mysqld_safe Logging to '/var/log/mysql/error.log'. touch: /var/log/mysql/error.log: No such file or directory chmod: /var/log/mysql/error.log: No such file or directory 161116 10:46:07 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data ./mysqld_safe: line 129: /var/log/mysql/error.log: No such file or directory ./mysqld_safe: line 166: /var/log/mysql/error.log: No such file or directory touch: /var/log/mysql/error.log: No such file or directory chown: /var/log/mysql/error.log: No such file or direc...