One of the most frustrating situations is when you forget your password for your Admin panel and you can't recover it because you no longer have access to your email account. We will go through three different options for changing your password using PhpMyAdmin.
We will begin with the easiest mehtod, this method relies on changing the email in your database and then go to the wp admin login page where you will click on the "Lost your password?" and proceed with the steps WordPress sends you.
So, first of all you have to connect to your cPanel and open your PhpMyAdmin. Once PhpMyAdmin has loaded navigate to the database which is connected to your WordPress website and open wp_users table. This table contains all users that are registered on your website, look for your username and click on edit right next to the checkbox. Change the email address then go to your WordPress admin login page and reset your password.
The other two methods are for users that are a little more experienced with the WordPress. For the second method you will also have to navigate to the WordPress users table named wp_users and find your username then click edit next to the checkbox. In the input field named user_pass you will paste the MD5 hashed password, you can generate a hash on any website dedicated for it.
The last option is to open PhpMyAdmin and click on SQL in the navigation menu then paste the following query replacing "yourpassword" with your new password and "yourusername" with your username.
UPDATE `wp_users` SET `user_pass`= MD5('yourpassword') WHERE `user_login`='yourusername';