The first part of the WP series of errors and their solution – Loss of passwords

When working with the WordPress system, we may encounter some specific problems that often surprise less technically proficient users. WordPress should be as simple as a slap, I will install it in 5 minutes and I will “click” all the necessary modules through the administration interface …

Nevertheless, in such a complex system as WordPress, we may encounter various technical pitfalls that become either innocent clickers, but especially various “do-it-yourselfers” who rummage through the source code in a trial-and-error manner.

With this article, we are launching a series to help address these issues. So go ahead:

Loss of the password to the administrator interface, inability to reset the password.

You have forgotten the password to administer your website. Of course, first try to get your password back by entering your email address. But what if this process doesn’t work and you don’t get anything in your email?

Solution no. 1 – using the PhpMyAdmin database editor

Hosted Mysql databases, necessary for the operation of the WordPress system, are usually editable using the PhpMyAdmin administrator interface, which allows you to edit data in the database even without knowledge of SQL syntax. Log in to PhpMyAdmin using the data you provided when installing WP in the wp-config.php file, at the address you will find from your provider (for example, an address in the form http://db.yourdomain.com or various variations by type database).

Then you search the database of your website, in it the table wp_users.

In the wp_users table, you will find the correct row, preferably based on your login name ( user_login ), where you click the edit button.

At this point, you can enter a new password (case sensitive) in the appropriate user_pass line and then encrypt and save it by selecting the MD5 option from the functions drop-down menu in the user_pass line and clicking the GO button.

Solution no. 2 – using FTP

For this method, you need to know the ID number of our administrator account in the database, specifically in the wp_users table. Once you find it (see previous solution), just add the code to the functions.php file of your active theme. You can usually find this file at ../wp-content/themes/[vaša aktívna téma] /functions.php . In the file right to the next line below the first< ? php add line:

wp_set_password(‘VašeNovéHeslo’,1);

substituting the ID number of your user account for the unit and substituting it for your NewPassword .. but maybe we understand each other;). After successfully logging in to your administrator account, you will then delete this line again and, for sure, you will change your password to one that you will remember better 🙂

The first part of the series on classic WordPress issues is over. We haven’t touched on the issue of why WordPress didn’t send the email properly and the others we’ll get to. But the important thing is that you have control over the content of your website again.

Don’t be shy to comment on this topic yourself. Have you ever had a similar problem? How did you deal with it? Do you think you know a better or easier solution? Let us know!