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

 
back to notes and tips index

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


← back to notes and tips index
Please do not copy the text of this tip (© Patrick Min) to your web site.