Reset a forgotten MySQL root password

Linux tip, Fedora tip / howto: Reset a forgotten MySQL root password

Note that these tips are mostly outdated

Try my online puzzle page with Calcudoku, Killer Sudoku and online Sudoku.

Reset a forgotten MySQL root password

Another "note to self":

/etc/init.d/mysqld stop /usr/bin/mysqld_safe --skip-grant-tables & mysql --user=root mysql mysql> UPDATE user SET password=PASSWORD('new-password-here') WHERE user='root'; mysql> FLUSH PRIVILEGES; /etc/init.d/mysqld restart

	Send me your comments! Something didn't work as expected? You'd like to add some useful info to this tip? Use the form below to send me your comments. (Don't forget to fill out the super-lame CAPTCHA below..)
	(do leave your e-mail address if you'd like a reply) (your message) Please enter the result of 10 x 8 - 5 here:

Linux tip, Fedora tip / howto: Reset a forgotten MySQL root password

Send me your comments!