on my site bensullins.com all of my admin users have been deleted somehow and I can't login. I have full MYSQL access but don't know where to change the settings in order to add my admin account back. Any help?
on my site bensullins.com all of my admin users have been deleted somehow and I can't login. I have full MYSQL access but don't know where to change the settings in order to add my admin account back. Any help?
Do you know how users were deleted? This shouldn't happen so probably indicates that something is very wrong or there has been foul play. Do you have a recent good backup of your database?
No clue, I haven't touched the blog in a month at least. Checked w/ my hosting provider and they said all of their backups have an empty wp_users table.
I was able to manually add my account to this table however now when I login I get "You do not have sufficient permissions to access this page."
Any chance you know what table I need to update for this?
Here's an article from wpbeginner that covers this: http://www.wpbeginner.com/wp-tutorials/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql/
You must log in to post.