morhook

I could get in my precious MySQL after resetting this this command (for ubuntu 17.10 and mysql-5.7 the command on the post didn´ t work)

UPDATE mysql.user SET authentication_string=PASSWORD('YOURNEWPASSWORD'), plugin='mysql_native_password' WHERE User='root' AND Host='localhost';