MySQL
From Leo's Notes
This page was last edited on 1 June 2013, at 15:50.
Reset Mysql Root Password
see http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Basically, to reset the root password, restart mysql with the --skip-grant-tables option to start mysql without user accounts, then update the root password.
service mysql stop
mysqld_safe --skip-grant-tables
mysql
> update mysql.user set password=PASSWORD('newpassword') WHERE user='root';
> quit
service mysql restart