Locked out of my account

https://codex.www.ads-software.com/Resetting_Your_Password

Samuel,

I found that I had to go into myphp and of course, I messed it up. I did find that the email account on file was changed to some obscure hotmail account. Also, the password was changed.

I chose to change the email address and the password using the link you provided, but now it’s teling me that I have to repair the database.

I added a line in one of my files and it gave me some errors after attempting to repair as follows:

wp_users:
wp_usermeta:
wp_posts:
wp_comments:
wp_links:
wp_options:
wp_postmeta:
wp_terms:
wp_term_taxonomy:
wp_term_relationships:
wp_commentmeta:

Any ideas?

Thanks.

I have had the same problem. I wrote a post recently about using the emergency.php script as I find, even though it is recommended as a last resort, that it works every time, is easy and as long as the script is uploaded (to the root), named properly & you then remove the script from your site’s files after resetting your password, that there are no problems.
If you want to check out the post it’s at https://localbizmarketingaustralia.com.au/blog/resetting-wordpress-password/

I added a line in one of my files and it gave me some errors after attempting to repair as follows:

you lost me there – did you run the repair?

Yes, I ran the repairs and the errors that it gave me are what I posted.

The hacker clearly changed my default email address and I followed the “Through phpMyAdmin” method. The only difference was that in addition to changing the password, I also changed the email address back to mine.

Now that the database is damaged, does it really matter that I try to repair the password? I will try regardless as I can’t see how it will hurt anything else at this point.

Another important point…

I received a message that I need to install this line of code in my wp-config.php in order to try and repair the database

define(‘WP_ALLOW_REPAIR’, true);

After doing so, I had a number of errors after it tried to repair the database and is says:

“Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.”

wp_users:
wp_usermeta:
wp_posts:
wp_comments:
wp_links:
wp_options:
wp_postmeta:
wp_terms:
wp_term_taxonomy:
wp_term_relationships:
wp_commentmeta:

So, that’s where I am now…no website, no password, broken database and a lot of frustration because of some damn hacker!

I also tried to restore an old backup of the WordPress database in my control panel and that was no good either.

I could really use a WP expert for some help…

Eugene

Here are all the messages from the repair:

The wp_users table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the wp_users table. Error:

The wp_usermeta table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the wp_usermeta table. Error:

The wp_posts table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the wp_posts table. Error:

The wp_comments table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the wp_comments table. Error:

The wp_links table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the wp_links table. Error:

The wp_options table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the wp_options table. Error:

The wp_postmeta table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the wp_postmeta table. Error:

The wp_terms table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the wp_terms table. Error:

The wp_term_taxonomy table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the wp_term_taxonomy table. Error:

The wp_term_relationships table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the wp_term_relationships table. Error:

The wp_commentmeta table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the wp_commentmeta table. Error:

remove the line from wp-confgi.php

log in to host’s phpmyadmin
select database
check mark all tables
scroll to bottom
select “repair” from drop down
that’s it

OK, it showed that everything was repaired ok

when I go back to site, it gives me the following error:

Error establishing a database connection

did you change anything else in wp-config.php?
make sure the database info is correct

I went back to check an older backup that I have and they appear to be unchanged for the DB_NAME and DB_USER.

Should I check something else?

what is the specific message when you go to
https://yoursite.com/wp-admin

Since I modified the config file, it has reverted to say:

“One or more database tables are unavailable. The database may need to be repaired.”