Reset MySQL password

´´$ sudo systemctl stop mysql
$ sudo mkdir -p /var/run/mysqld
$ sudo chown mysql:mysql /var/run/mysqld
$ sudo /usr/sbin/mysqld –skip-grant-tables –skip-networking &

FLUSH PRIVILEGES;
USE mysql;
update user set plugin=”mysql_native_password”;
ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘N3w_p@ssw0rD.’;
quit

!fix! error: plugin ‘auth_socket’ is not loaded

!fix! mysql root passwort does not work