CCCPaste

MySQL Reset Forgotten Password

sudo service mysql stop
sudo killall mysqld
sudo mkdir -p /var/run/mysqld
sudo chown mysql:mysql /var/run/mysqld

mysqld_safe --skip-grant-tables --skip-networking &
sudo mysql -u root
quit

sudo service mysql stop
sudo killall mysqld
sudo service mysql start

mysql -u root -p