Cara Reset root Password untuk MySQL 5.7 di Ubuntu 16.04 LTS

[php]

sudo /etc/init.d/mysql stop

sudo mkdir /var/run/mysqld/

sudo chown mysql /var/run/mysqld/

sudo mysqld_safe --skip-grant-tables &

mysql -uroot

use mysql;

update user set authentication_string=PASSWORD("NEW_PASSWORD_GOES_HERE") where User='root';

flush privileges;

quit;

sudo /etc/init.d/mysql stop

sudo /etc/init.d/mysql start

[/php]