MySQL

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

Binary Logs

see http://leo.steamr.com/2011/10/mysql-binary-logs/