Installation is easy with homebrew. I use mariadb which is a fork of mysql but either should work.
brew install mariadb
Follow the homebrew instructions for starting the server. I usually just do
mysql.server start
Install MySQL and start it.
Our test suite assumes the database uses it's default configuration. See config/config.js
for the override ENV variables. Now you should be able to run the test suite from the project root directory.
DB_BACKEND=mysql npm test
Or run the local server
DB_BACKEND=mysql npm start
You may want to clear the data from the database periodically. I just drop the database.
mysql -uroot -e"DROP DATABASE picl"
these look sweet and work for me.