xxxxxxxxxx
//Just use sudo in command!
sudo mysql -u root -p
xxxxxxxxxx
>>> sudo mysql -u root -p
>>> USE mysql;
>>> UPDATE user SET plugin='mysql_native_password' WHERE User ='root';
>>> FLUSH PRIVILEGES;
>>> exit;
>>> service mysql restart;
xxxxxxxxxx
$ sudo mysql -u root # I had to use "sudo" since is new installation
mysql> USE mysql;
mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit;
$ service mysql restart
xxxxxxxxxx
sudo mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
flush privileges;
quit
sudo service mysql stop
sudo service mysql start