I found this great WordPress guide on installing a local development environment using brew and npm for wordpress, php and mysql. With the db running through brew services. Loving it. Install was fairly easy, with a little bit of troubleshooting (why oh why did I not document the troubleshooting part!).
Here’s the site: http://www.brodybits.com/wordpress/osx/homebrew/2016/03/09/quickstart-wordpress-testing-with-osx-homebrew.html
I cannot for the life of me remember how to create a new db, the instructions in the quick start aren’t working for me.
This post shows a much better method for creating new databases once you’ve gotten everything else running from the quick start guide above.
http://russianz.blogspot.com/2010/07/how-to-create-database-for-mac-os-x.html
Step 1
mysql.server start
Step 2:
Type:
shell> mysql -u root -p
Response:
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.88-log Source distribution
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
shell> create database db_wordpress;
Response: Query OK, 1 row affected (0.08 sec)
shell> GRANT ALL ON wordpress.* TO admin@localhost IDENTIFIED BY “YourPWHere”;
Response: Query OK, 0 rows affected (0.08 sec)