Hi, someone on here managed to show me a way to find my wordpress password which i forgot by browsing the mysql database. But i forgot how to do this could someone guve me a hand!? please
The wordpress admin password isn't stored in the database to be viewed visibly. It's stored as a hash value. Use the forgot password option to resend it to your email. If you need to update your email, you can do so in the wp_users table. Rep appreciated.
http://codex.wordpress.org/Resetting_Your_Password . I hope this helps. Read near the end of the post for resetting the password using phpmyadmin or mysql.
assuming your using phpmyadmin, go to wp_user table, edit, change the password to anything you want, save the field as md5, done