Change mySQL password without SQL manager or PHPmyAdmin for WordPress

reset-wordpress-db-password.php

<?php
/**
 * Tutorial by: nanodesigns (@nanodesigns)
 * URL: 		    http://tuts.nanodesignsbd.com/change-wordpress-password-without-sql-manager/
 * by: 			    Mayeenul Islam (@mayeenulislam)
 */
 
//Connect to mySQL First
$connection = mysql_connect('DB_HOST','DB_USER','DB_PASSWORD');
 
//Select Database
mysql_select_db('DB_NAME');
 
//Reset password with SQL UPDATE Query
$SQL="update wp_users set user_pass=MD5('newpassword123here') where user_login='admin'";
 
//If everything's OK, your password will be reset
if(mysql_query($SQL)){
     echo "Your password was succesfully reset!";
}