There are several ways to reset your WordPress administrator password.
We recommend trying the easier options first before editing the database manually.
Go to your WordPress login page, usually:
https://yourdomain.co.nz/wp-admin/
Click Lost your password? and follow the instructions.
This is the easiest option if your WordPress site can send email correctly.
If your WordPress site was installed or detected by Softaculous, you may be able to reset the admin password from cPanel.
You should then be able to log in to WordPress using the new password.
Use this method only if the WordPress password reset email and Softaculous options are not available.
Be careful when editing the database. Changing the wrong value may cause problems with your website.
Log in to cPanel and open phpMyAdmin from the Databases section.
Click the database used by your WordPress website.
The database name may look something like username_wpxxx, where username is your cPanel account username.
If you are unsure which database your WordPress site uses, check the wp-config.php file for the database name.
On the left-hand side, click the WordPress users table.
This is commonly called wp_users.
However, your site may use a different table prefix, so it may look like abc123_users.
Click Edit beside the WordPress user account you want to update.
Find the user_pass field.
In the Function dropdown, select MD5.
In the Value field, remove the existing value and enter the new password.
Click Go to save the new password.
You should now be able to log in to WordPress using the new password.
After you log in, WordPress will normally update the password hash to its current password format automatically.
If you are not sure which database or user table to edit, please contact WebhostingNZ support before making changes.