reset mysql password

1. killall mysqld

2. /usr/local/mysql/bin/mysqld_safe --defaults-file=/usr/local/mysql/etc/my.cnf --user=mysql --skip-grant-tables &

3. update user set password=password('xxx') where user = 'root'; flush privileges;

4. killall mysqld

5. start mysqld