How to setup MySQL 5.5 on OS X

mysql_setup_osx

1) Setup Apache
https://ole.michelsen.dk/blog/setup-local-web-server-apache-php-osx-yosemite.html
for USERNAME use your home user

or even better
https://medium.com/@danilosapad/how-to-set-up-virtual-hosts-on-mac-os-x-10-10-yosemite-afac19e982cf

3) Add php.ini inside /etc/php.ini
https://davidwinter.me/enable-php-error-logging/

4) restart Apache
sudo apachectl restart

5) Use logs
tail -F /var/log/apache2/error_log

6) Update 'mysql.default_socket' param
https://stackoverflow.com/a/1676741/574475

add the following into php.ini
mysqli.default_socket = /tmp/mysql.sock
mysql.default_socket = /tmp/mysql.sock

OS X MySQL location:
https://dev.mysql.com/doc/refman/5.7/en/osx-installation-notes.html

7) chmod 777 templates_c

8) set AllowOverride All in all Apache conf
https://stackoverflow.com/questions/10769880/htaccess-file-not-being-read-options-indexes-in-htaccess-file-not-working

9) remove .... from .htaccess

10) add date.timezone = 'America/Chicago' to php.ini

===

on VPS
https://stackoverflow.com/a/27134978/574475