Posted 5 months ago #
The short story is that my site went down, because my database was wiped out when I upgraded to MYSQL 5. My hosting site finally got my site back up, but now I cannot log in to my Admin Page. I even tried using the "Lost Password" link, but it does not recognize my email address. It tells me "ERROR: There is no user registered with that email address".
Any suggestions would be great!
Hi flash1773,
I would recommend checking your database through phpMyAdmin for the wp_users table. In that table see if you have a user set up ( with your email address. If not, you should be able to add one through phpMyAdmin or edit an existing user if needed.
Hope this helps.
Posted 5 months ago #
Thanks, but I do not have that table in my database.
I have "user", but not "wp_users".
Ideas?
What's your database prefix? Listed in your wp-config.php?
Posted 5 months ago #
Not sure what you mean...
My Database name is listed correctly in wp-config.php file. Is that different than the prefix?
Hello again flash1773,
Yes, the database prefix controls the prefix of your tables within your database. The database name is the name of your database that holds those tables.
You can find the database prefix in your wp-config.php file. It will look something like this:
* WordPress Database Table prefix.
*
* You can have multiple installations in one database if you give each a unique
* prefix. Only numbers, letters, and underscores please!
*/
$table_prefix = 'wp_';Hope this helps!
If it's blank, then the table name should be users, not wp_users (and I'm fairly sure yours is, since if WP is missing tables, it tends to not load at all).
Posted 5 months ago #
This is what mine looks like:
* WordPress Database Table prefix.
*
* You can have multiple installations in one database if you give each a unique
* prefix. Only numbers, letters, and underscores please!
*/
$table_prefix = 'wp_';
Correct?
Interestign... What do you see in the user table? Is there a list of names with emails addresses and obfuscated passwords?
Hello again flash1773,
Very interesting indeed. When you access phpMyAdmin, you're not seeing similar table names as shown in these screen shots?
http://codex.wordpress.org/Resetting_Your_Password#Through_phpMyAdmin
Does your "user" table look like the wp_users table?
Thanks!
Posted 5 months ago #
No it does not.
Hello again flash1773,
What do you see in your user table? Do you think you could give us a screen shot of what you're seeing?
Thanks!
You must log in to post.
