If you have access to phpMyAdmin or anyway to login to the database, you can edit your login entry in the table wp_users to reset your password.
This link gives you more details on how to reset your WP password from phpMyAdmin
http://www.devlounge.net/publishing/reset-a-wordpress-password-from-phpmyadmin
WordPress documentation also gives you some useful methods (including FTP)
http://codex.wordpress.org/Resetting_Your_Password
To disable the plugin, once you FTP to your site, go to the wp-content > plugins folder and delete the plugin folder. (You can try this if the database edit doesn’t work)
Thanks for info but as I said in my post the database does not show in filezilla or phpmyadmin. I’m thinking this is something the security plugin has caused to happen. If I could disable the plugin I’m sure I could fix the password issue but need to get access.
Since your site is still functioning, I don’t see any problem with the database. You will need to get into your database somehow 🙂 As far as I know, FTP does not show your database.
Does your hosting provider use cPanel? If yes, they will give you a link to phpMyAdmin which is the web interface for your database. If you can access cPanel & in turn phpMyAdmin, follow the first link to reset your password.
If not, in the second link provided, scroll down for the section heading “Through FTP”. It gives you a way to edit the active theme’s function.php (wp-content > themes > your-active-theme-folder) to reset the password.
If all fails, the same link has an Emergency Password Reset Script (at the bottom) that allows you to upload a single file to your site root and reset your password.
PS: Did you also check my method to delete the plugin (via FTP)?
