Resetting WordPress Password via phpMyAdmin

If you lost access to your admin email and cannot reset your password normally, you can do it directly in the database:

1. Login to cPanel and open phpMyAdmin.
2. Select your WordPress database from the left sidebar.
3. Find the table named wp_users (the prefix might be different, e.g., wp123_users).
4. Click Edit next to your admin user record.
5. Find the user_pass field. In the Function column, select MD5.
6. In the Value column, type your new password.
7. Click Go at the bottom.

Now you can login to WordPress with your new password.