How to reset MySQL root password in Ubuntu Linux
In case you have forgotten your root password on your Ubuntu Linux, here’s a small tip on how to reset it.
sudo mysqld --skip-grant-tables &
mysql -u root mysql
UPDATE user SET Password=PASSWORD('MyNewPasswordHere') WHERE User='root';
FLUSH PRIVILEGES;
quit
sudo /etc/init.d/mysql restart
Now you can login using your new root password.
Oh my! Thanks for this simple guide I’m bookmarking it
I use postgres regularly and I’m totally dumb with mysql commands during the occasional use!
Postgres is way to go! Although its kinda advanced