Installing and Initializing MySQL in OS X

installing-and-initializing-mysql-osx.Rmd

Install MySQL in OS X using brew: `brew install mysql`, start the service `mysql.server start` and login with `mysql -uroot` to create a database as follows:

```{sql}
CREATE DATABASE sparklyr;
USE sparklyr;

CREATE TABLE `person` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(30) DEFAULT NULL,
  `last_name` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO person(first_name, last_name) VALUES("Barack", "Obama");
INSERT INTO person(first_name, last_name) VALUES("Bill", "Clinton");

ALTER USER 'root'@'localhost' IDENTIFIED BY '<password>';

QUIT;
```

Once the instance is no longer needed, stop the MySQL service by running `mysql.server stop`.