Lost root password
As for Debian, run:
$ sudo mysql --default-files=/etc/mysql/debian.cnf
Then, in the MySQL interpreter, run:
> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'n3wpass';
> FLUSH PRIVILEGES;
As for Debian, run:
$ sudo mysql --default-files=/etc/mysql/debian.cnf
Then, in the MySQL interpreter, run:
> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'n3wpass';
> FLUSH PRIVILEGES;