How to Reset MySQL Root Password on Ubuntu

systemctl stop mysql

1	systemctl stop mysql

mysqld_safe --skip-grant-tables &

1	mysqld_safe --skip-grant-tables &

mysql>

mysql>

UPDATE mysql.user SET Password=PASSWORD('NEW-PASSWORD') WHERE User='root';

1	UPDATE mysql.user SET Password=PASSWORD('NEW-PASSWORD') WHERE User='root';

FLUSH PRIVILEGES;

1	FLUSH PRIVILEGES;

EXIT

EXIT

systemctl start mysql

1	systemctl start mysql

Run all commands as root

Today view: 1 - Total View: 225