Quick Start Guide for WordPress development on OSX

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.


Step 1
mysql.server start
Step 2:
shell> mysql -u root -p

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)