A gist to configure mysql on mac machine for Rails

steps to install mysql

brew install mysql         #install mysql using home brew

mysql_install_db --verbose --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
mkdir -p ~/Library/LaunchAgents
cp /usr/local/Cellar/mysql/<mysql dist version you have>/<the plist file you have in this dir>.plist ~/Library/LaunchAgents/
launchctl load -w ~/Library/LaunchAgents/<the plist file you have in this dir>.plist

#try 
mysql -uroot; #if it works: yayyyy !!!

#Resetting mysql root password
$ mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD("NEWPASSWORD") where User='root';
mysql> flush privileges;
mysql> quit