The name of the database with which the site works can be found in the configuration file wp-config.php, which is located in the root directory of the site.

/var/www/www-root/data/www/testing.ru/wp-config.php

Open this file, for example, via File Manager, and look for lines in it:

define('DB_NAME', 'frnx_db');  

$table_prefix = 'wp_';

The values in these lines denote the name of the database the site works with, frnx_db and the database table prefix wp_

After that, we need to get into the database itself, via phpMyAdmin under MySQL

Find the right database in the list and open it

In front of us is the database with which our site works. We need to find the table with the users of our site. Its name is Prefix_user. In our case it is called wp_users

file

Table wp_users, which contains information about all registered users of your site, you need to find the line with your account login and open it for editing by clicking on Edit.

file

To change your password, find the line with the name user_pass

file

  • in the Value field, delete all current characters and enter the desired password there.
  • In the Function field choose MD5 from the list.

file

Press Forward to save your changes.

Updated Aug. 23, 2018