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