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!).
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.
shell> mysql -u root -p
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)