Posts

Showing posts from November, 2016

restart MySQL Server on MacOSX after Sierra Upgrade

Image
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 directory c…