MySQL first setup on Mac (Change root Password, Add PATH)

Change MySQL root password

1. Open Terminal 
2. type
   $ cd /usr/local/mysql/bin
   
   $ sudo ./mysql
3. type your os password
4. You would look terminal to change 'mysql>'
5. type
   mysql> use mysql;
   mysql> update user set password=password('YOURPASSWORD') where user='root';
   mysql>flush privileges;
6. Done

PATH add
$ export PATH=/opt/local/bin:/opt/local/sbin:/usr/local/mysql/bin:$PATH

terminal restart.

You can connect mysql through typing
$ sudo ./mysql -uroot -p