Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
// 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 is OK, your password will be reset
if( mysql_query( $SQL ) ) {
echo "Your password was succesfully reset!";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment