Cacher is the code snippet organizer for pro developers

https://dev.mysql.com/doc/mysql-windows-excerpt/5.7/en/resetting-permissions-windows.html
https://stackoverflow.com/questions/39281594/error-1698-28000-access-denied-for-user-rootlocalhost

-------------------------------
sudo mysql
== mysql>
use mysql;
select Host,User,authentication_string,plugin from user;
UPDATE mysql.user
  SET authentication_string = PASSWORD('toor'), password_expired = 'N'
  WHERE User = 'root' AND Host = 'localhost';

UPDATE user SET plugin='mysql_native_password' WHERE User='root';

FLUSH PRIVILEGES;
exit;
====

sudo /etc/init.d/mysql restart