Change Mysql root password

Change Mysql root password

$ sudo service mysql start

$ cd /var/run

--// Back the sock
$ sudo cp -rp ./mysqld ./mysqld.bak

$ sudo service mysql stop

$ sudo mv ./mysqld.bak ./mysqld

$ sudo mysqld_safe --skip-grant-tables --skip-networking &

mysql -u root

use mysql;
update user set authentication_string=PASSWORD("") where User='root';
update user set plugin="mysql_native_password" where User='root';  # THIS LINE

flush privileges;