mysql reset password сброс пароля mysql

service mariadb stop

mysqld_safe --skip-grant-tables &

MariaDB [mysql]> update mysql.user set password=password('9kWNxHUc3x') where user='root';
MariaDB [mysql]> flush privileges;

pkill mysqld

service mariadb start

Для 5.7 надо использовать alter user https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html