Reset MySQL root password (Homebrew)

homebrew_mysql_pass_reset.txt

$> launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

$> /usr/local/Cellar/mysql/5.5.19/bin/mysqld --basedir=/usr/local/Cellar/mysql/5.5.19 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/Cellar/mysql/5.5.19/lib/plugin --log-error=/usr/local/Cellar/mysql/5.5.19/data/errors.err --pid-file=/usr/local/Cellar/mysql/5.5.19/data/pidfile.pid --skip-grant-tables

$> mysql

mysql> UPDATE mysql.user SET Password=PASSWORD('root_password') WHERE User='root';
mysql> FLUSH PRIVILEGES;

$> kill `cat /usr/local/Cellar/mysql/5.5.19/data/pidfile.pid`

$> ps auwx | grep mysql

$> launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist