Reset MySQL 5 root password - Ubuntu

reset_mysql_root_password.sh

# Stop MySQL 
sudo service mysql stop 

# Make MySQL service directory. 
sudo mkdir /var/run/mysqld 

# Give MySQL user permission to write to the service directory. 
sudo chown mysql: /var/run/mysqld 

# Start MySQL manually, without permission checks or networking. 
sudo mysqld_safe --skip-grant-tables --skip-networking &

# Access to MySQL
mysql -u root

# Change mysql root password
update mysql.user set authentication_string=PASSWORD(""), plugin="mysql_native_password" where User='root';
FLUSH PRIVILEGES;
EXIT

# Turn off MySQL. 
sudo mysqladmin -S /var/run/mysqld/mysqld.sock shutdown 

# Start the MySQL service normally. 
sudo service mysql start