Easy Method (Using the Wordpress reset function):
You can reset your WordPress admin password by going to the Wordpress login screen (http://YOURDOMAIN.com.au/wp-login.php) and clicking "Lost your password?"
Enter your email address or username of your admin account, then check your email for further instructions - a reset link will be sent to you which you can then use to set a new password and login.
Advanced Method (Using SQL):
Sometimes the reset function may be hidden or unavailable (such as in a custom theme), but you still need to set a new password. In this scenario use this guide to gain acess to Wordpress.
- Login to cPanel directly or through the Client Area
- Next find 'phpMyAdmin' - and navigate there (this should open in a new tab or window).
- Select your database from the side (if unsure check your Wordpress database information)
Depending on your installation you may have a different database prefix, however find 'xxx_users'
- Find the user you need to reset and click 'edit'
- In the 'user_pass' varchar field delete the contents and type your new password exactly as you want it to be.
- From the drop-down box next to this field select 'MD5'
- Click 'Go'
- Your new password has been set, continue to use the regular wp-login.php page to access Wordpress.