mysql administration - potty-dzmeia/libraries GitHub Wiki

MySQL - Resetting a lost MySQL root password
stop mysql: sudo /etc/init.d/mysql stop
start into safe mode: sudo mysqld_safe --skip-grant-tables &
login as root: mysql -u root
set db to use: use mysql;
reset password: update user set password=PASSWORD("mynewpassword") where User='root';
flush privileges: flush privileges;
exit: quit
restart the service: sudo /etc/init.d/mysql restart