Aaaaaaargh. Yet again completely lost ability to log into MySQL - forgot password AGAIN!
Heres a good link on how to go about resetting the password.
For the next time..
1. Kill MySQL. > ps aux | grep mysql // note the PID > kill -9 [PID_HERE] 2. Start MySQL bypassing grant tables. > mysqld -Sg 3. Change MySQL password for user root (below prompt is MySQL prompt) > USE mysql; > UPDATE user > SET password = password("NEW_PWD_HERE") > WHERE user = "root"; > flush privileges; > exit; 4. Repeat step 1 and step 2. 5. Restart mysqld without -Sg flags to restart using grant tables (access control system).