Quick & Easy: Reset MySQL root Password (Ubuntu 16.04)

wiak - 07 Mar 2014

service mysql stop
mysqld_safe --skip-grant-tables &
mysql -u root
use mysql;
flush privileges;
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');
quit
pkill -9 mysqld
service mysql restart
mysql -u root -p