How to update the Wordpress password that you use to access your site through www.yoursite.com/admin. This is helpful when you have lost your password and traditional recovery methods are not working.
1) Sign into our portal at https://www.cera.net (use password reset feature if you have lost your password)
2) Click 'Cloud' from the main navigation, then click on the applicable wordpress account from the dropdown
3) Click on the 'MySQL 5.x' icon in the Databases section
4) Click 'Browse Database' on the right hand side
Note: if there is more than one database, choose the same wp database as specified in the wp-config for the site in question which can be viewed through file manager.
5) Expand the database by clicking the '+' sign next to your wordpress database name in the left hand pane
6) Click on the 'wp_users' database table in the left hand pane
7) On the right hand pane, locate the user_login that you wish to change, and click the 'Edit' on that row
8) On the right hand pane, locate the column with the name 'user_pass', specify 'MD5' in the function dropdown, specify your new password in the Value box
Note: When adding you new password to the Value box, replace the entire existing content in that box with your new password by typing it in plain text
9) Click the 'Go' button
You should now be able to login to your wordpress admin with your new password.