MYSQL - reset root password

sudo -i mysql or mysql -p -u root mysql> SELECT user,plugin,host FROM mysql.user WHERE user = 'root'; | user | plugin | host | | root | auth_socket | localhost | 1 row in set (0.00 sec) mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new-password'; Query OK, 0 rows affected (0.01 sec) mysql> flush privileges;