reset mysql (5.7) root password on ubuntu 19.04

resetrootpassword.md

Step 1

sudo /etc/init.d/mysql stop

Step 2

sudo mkdir /var/run/mysqld/
sudo chown mysql /var/run/mysqld/

sudo mysqld_safe --skip-grant-tables &

Step 3

mysql -uroot

step 4

use mysql;

update user set authentication_string=PASSWORD("mynewpassword") where User='root';

flush privileges;

quit

Step 5

sudo /etc/init.d/mysql stop
sudo killall mysqld mysqld_safe
sudo /etc/init.d/mysql start

Step 6

login now

mysql -u root -p