forgot mysql root password stackoverflow
sudo service mysql stop
Source: askubuntu.com
forgot mysql root password stackoverflow
sudo service mysql start
forgot mysql root password stackoverflow
sudo mkdir /var/run/mysqld
Source: stackoverflow.com
forgot mysql root password stackoverflow
sudo mysqld_safe --skip-grant-tables --skip-networking &
Source: stackoverflow.com
forgot mysql root password stackoverflow
UPDATE mysql.user SET authentication_string=PASSWORD('YOURNEWPASSWORD'), plugin='mysql_native_password' WHERE User='root' AND Host='localhost'; EXIT;
Source: stackoverflow.com
forgot mysql root password stackoverflow
sudo chown mysql: /var/run/mysqld
Source: stackoverflow.com
forgot mysql root password stackoverflow
mysql -uroot mysql
Source: stackoverflow.com
forgot mysql root password stackoverflow
sudo mysqladmin -S /var/run/mysqld/mysqld.sock shutdown
Source: stackoverflow.com