Monday, January 13, 2014

MySQL Command Line

sudo /usr/local/mysql/support-files/mysql.server start
sudo /usr/local/mysql/support-files/mysql.server stop
sudo /usr/local/mysql/support-files/mysql.server restart

Config MySQL (my.cnf) for OSX Mountain Lion

Mac load default MySQL setting, so there is no my.cnf file. To customize MySQL config:

1) Create you own my.cnf
sudo cp /usr/local/mysql/support-files/my-huge.cnf /etc/my.cnf

2) Update my.cnf

3) Restart MySQL
sudo /usr/local/mysql/support-files/mysql.server restart



Thursday, January 2, 2014

Add Virtual Host for OSX Mountain Lion

Update /etc/apache2/httpd.conf

NameVirtualHost 127.0.0.1

<VirtualHost 127.0.0.1>
DocumentRoot "website_root"
ServerName server_name
</VirtualHost>

<Directory "website_root">
Options FollowSymLinks
AllowOverride All
Order allow,deny
Allow from all
</Directory>

Update /etc/hosts

127.0.0.1 server_name

Enable pdo_mysql for OSX Mountain Lion

Update /etc/php.ini

extension=php_pdo_mysql.dll
pdo_mysql.default_socket=/tmp/mysql.sock