Just another post for my archive
One our sandbox accidently delete root account with host ‘localhost’. We need to recover the account by grant new root account back into system.
The steps are :
1. Turn off mysql service
sandbox# /usr/local/etc/rc.d/mysql-server stop

2. Run mysql with skip grant table mode
sandbox# mysqld_safe –skip-grant-tables &
[1] 5187
sandbox# Starting mysqld daemon with [...]

Click here to read more from login to 127.0.0.1 in mysql db