Change your WordPress Password from MySQL( PhPMyAdmin)

0
37

 

To reset password from MySQL we need the following credentials

  • mySQL user ID and Password
  • Database Name
  • pHpmyadmin URL

if you dont have MySQL Credentials Login to your FTP account and download wp-config.php, it looks like this

 

<?php
/**
* The base configurations of the WordPress.
*
* This file has the following configurations: MySQL settings, Table Prefix,
* Secret Keys, WordPress Language, and ABSPATH. You can find more information
* by visiting {@link http://codex.wordpress.org/Editing_wp-config.php Editing
* wp-config.php} Codex page. You can get the MySQL settings from your web host.
*
* This file is used by the wp-config.php creation script during the
* installation. You don’t have to use the web site, you can just copy this file
* to “wp-config.php” and fill in the values.
*
* @package WordPress
*/

// ** MySQL settings – You can get this info from your web host ** //
/** The name of the database for WordPress */
define(‘DB_NAME’, ‘mywordpress’); // Database name

/** MySQL database username */
define(‘DB_USER’, ‘mywordpress’); // User Name

/** MySQL database password */
define(‘DB_PASSWORD’, ‘zQNYJ3Ym7cdcMM4X’);

/** MySQL hostname */
define(‘DB_HOST’, ‘localhost’);

Now login to your PhpMyAdmin with this user ID and password and select the database name here it is ‘mywordpress’

phpmyadminWp

Now a List of tables will appear on right pane, out of these select wp_users, click on it

Image

Now click on Edit Link, on the user name you want to edit

Image

Enter New password on user_pass text field and select MD5 on function column and press Go Button below

Done Password changed for the user selected, Now try login with the changed password

LEAVE A REPLY

Please enter your comment!
Please enter your name here