change mySQL root password

mysqlroot.txt

Change MySQL root password on Ubuntu Server
============================================

~$ sudo service mysql stop

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

~$ sudo mysql -u root

> use mysql;

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

> flush privileges;

> exit;

~$ sudo service mysql stop

~$ sudo service mysql start

// check if it works

~$ sudo mysql -u root -p


// if you get this error  "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'" 

~$ sudo mkdir /var/run/mysqld/

~$ sudo chown mysql /var/run/mysqld/

// then go back to line 6