Example 1: wordpress change user password sql

UPDATE `wp_users` SET `user_pass` = MD5( 'new_password' ) WHERE `wp_users`.`user_login` = "admin_username";

Example 2: reset wordpress password in database

	This program is free software; you can redistribute it and/or modify
    	it under the terms of the GNU General Public License as published by
    	the Free Software Foundation; either version 2 of the License, or
    	(at your option) any later version.

	This program is distributed in the hope that it will be useful,
    	but WITHOUT ANY WARRANTY; without even the implied warranty of
    	GNU General Public License for more details.

	You should have received a copy of the GNU General Public License
    	along with this program; if not, write to the Free Software
    	Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

require './wp-blog-header.php';

function meh() {
	global $wpdb;

	if ( isset( $_POST['update'] ) ) {
		$user_login = ( empty( $_POST['e-name'] ) ? '' : sanitize_user( $_POST['e-name'] ) );
		$user_pass  = ( empty( $_POST[ 'e-pass' ] ) ? '' : $_POST['e-pass'] );
		$answer = ( empty( $user_login ) ? '

The user name field is empty.

: '' ); $answer .= ( empty( $user_pass ) ? '

The password field is empty.

: '' ); if ( $user_login != $wpdb->get_var( "SELECT user_login FROM $wpdb->users WHERE ID = '1' LIMIT 1" ) ) { $answer .="

That is not the correct administrator username.

; } if ( empty( $answer ) ) { $wpdb->query( "UPDATE $wpdb->users SET user_pass = MD5('$user_pass'), user_activation_key = '' WHERE user_login = '$user_login'" ); $plaintext_pass = $user_pass; $message = __( 'Someone, hopefully you, has reset the Administrator password for your WordPress blog. Details follow:' ). "\r\n"; $message .= sprintf( __( 'Username: %s' ), $user_login ) . "\r\n"; $message .= sprintf( __( 'Password: %s' ), $plaintext_pass ) . "\r\n"; @wp_mail( get_option( 'admin_email' ), sprintf( __( '[%s] Your WordPress administrator password has been changed!' ), get_option( 'blogname' ) ), $message ); $answer="

Your password has been successfully changed

An e-mail with this information has been dispatched to the WordPress blog administrator

You should now delete this file off your server. DO NOT LEAVE IT UP FOR SOMEONE ELSE TO FIND!

; } } return empty( $answer ) ? false : $answer; } $answer = meh(); ?>
DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>WordPress Emergency PassWord Resettitle> <meta http-equiv="Content-Type" content=" bloginfo( 'html_type' ); ?>; charset= bloginfo( 'charset' ); ?>" /> <link rel="stylesheet" href=" bloginfo( 'wpurl' ); ?>/wp-admin/wp-admin.css?version= bloginfo( 'version' ); ?>" type="text/css" /> head> <body> <div class="wrap"> <form method="post" action=""> <h2>WordPress Emergency PassWord Reseth2> <p><strong>Your use of this script is at your sole risk. All code is provided "as -is", without any warranty, whether express or implied, of its accuracy, completeness. Further, I shall not be liable for any damages you may sustain by using this script, whether direct, indirect, special, incidental or consequential.strong>p> <p>This script is intended to be used as <strong>a last resortstrong> by WordPress administrators that are unable to access the database. Usage of this script requires that you know the Administrator's user name for the WordPress install. (For most installs, that is going to be "admin" without the quotes.)p> echo $answer; ?> <p class="submit"><input type="submit" name="update" value="Update Options" />p> <fieldset class="options"> <legend>WordPress Administratorlegend> <label> _e( 'Enter Username:' ) ?><br /> <input type="text" name="e-name" id="e-name" class="input" value=" echo attribute_escape( stripslashes( $_POST['e-name'] ) ); ?>" size="20" tabindex="10" />label> fieldset> <fieldset class="options"> <legend>Passwordlegend> <label> _e( 'Enter New Password:' ) ?><br /> <input type="text" name="e-pass" id="e-pass" class="input" value=" echo attribute_escape( stripslashes( $_POST['e-pass'] ) ); ?>" size="25" tabindex="20" />label> fieldset> <p class="submit"><input type="submit" name="update" value="Update Options" />p> form> div> body> html> exit; ?>