In case if you forget your WordPress admin password and you are unable to reset it via forgot password, you have to reset your password through the WordPress database directly. The most convenient way to manage the database is via the phpMyAdmin tool at your web hosting account.In phpMyAdmin, select your WordPress database from the drop-down menu on the left. The page will refresh and the database’s tables will be displayed on it. Open the SQL tab (look at the top navigation bar).
In the text field write the following SQL query: