MySQL超级用户密码的重设和log-bin文件删除
重置mysql的root密码
# bin/mysqladmin -u root -p shutdown
# mysqld_safe –user=mysql –skip-grant-tables –skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD(‘newpassword’) where USER=’root’;
mysql> FLUSH PRIVILEGES;
mysql> quit
重启mysql
# bin/mysqladmin -u root -p shutdown
# bin/mysqld_safe &
删除3天前的log-bin文件
> PURGE MASTER LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 3 DAY);