Why reset your password phpMyAdmin? There can be many situations - you forgot this password and for some reason you cannot remember via e-mail, for some reason you are not allowed into the admin panel, you forgot your e-mail password or you no longer use this box, your blog was simply broken and changed password (God forbid), etc. The easiest solution is to reset your password via phpMyAdmin on web hosting.
I recently worked with a blog that requires direct intervention in the database and password reset, so I decided to write this post so that if necessary - you have some instructions "How to reset the password to the WordPress admin panel through phpMyAdmin on hosting.
So, in any case, you still have access to hosting in the control panel of your site (sites), and this is enough for us. Depending on which Internet hosting you use, the type and appearance of the site control panel will be different, but in each such panel there is a “phpMyAdmin” item, so find it.
phpMyAdmin can be hidden, say - located in the sub-item "Database management”, so look carefully at the control panel and find this application. Found and go directly to phpMyAdmin. Here is a picture in front of you:
Here we have the opportunity to do whatever we need with our databases, to completely manage them. Now we need to find the database that concerns our blog. If you do not remember which database from the list (there may be several of them on the left side) concerns your resource, then just look at the wp-config.php file, where you entered all this data.
Find the line in this file:
define('DB_NAME', 'Name of your database');
And it is this database that you select in phpMyAdmin.
We click on this database and the entire structure will open before us, all the tables that we can change. Now we are interested in the tablewp_users.
This table lists all users (if there is more than one) who have access to manage the blog. This is where we can change the password or delete a specific user - click on wp_users and the contents of the entire table will open to us.
Here we need to edit the password. In the case of the blog I worked with, it was clear that in addition to the administrator, one more user was registered, and the owner told me that there should be only one user. So someone already lived there.
In the table, we need to click on the "Edit" pencil next to the username and change the password.
The structure of this table will open before us, where we will see all the data relating to this user. I will not dwell on each tape in detail - I will only tell you how to reset your password.
Now we have a password encrypted using the MD5 method, so we see strange characters in the corresponding line.
That change Password - do the following: in the line user_pass in the password field we write a new password, and in the field varchar(64) - choose the encryption method MD5.
Make changes and click the buttonForward» at the very bottom and save the new password.
After saving all the changes, the password you registered will again become MD5, but it will be the one you need. Now we quietly go to the blog workshop with a new password.
Council. NEVER don't use login admin and simple passwords - this will save you from the unpleasant consequences of hacking your resource. Change your access data to more complex and "weird" ones.