use mysql;
update user set password=PASSWORD('$new_password') where User='$user_name';
flush privileges;