Cannot log in to WordPress as admin after its database migration from Windows to Linux: Unable to find specified administrator account in WordPress

Created:

2017-08-08 00:28:27 UTC

Modified:

2017-08-16 17:04:01 UTC

1

Was this article helpful?


Have more questions?

Submit a request

Cannot log in to WordPress as admin after its database migration from Windows to Linux: Unable to find specified administrator account in WordPress

Applicable to:

  • Plesk for Linux

Applicable to

Plesk for Linux

Symptoms

  • WordPress web site was migrated from Plesk for Windows to Plesk for Linux.
  • WordPress throws the following error on attempt to Log in to it via Plesk:
    ERROR: The password you entered for the username john.doe is incorrect.
  • Attempt to change password via Extensions > WordPress Toolkit > example.com > View / Change Password results in the following error:
    Unable to find the specified administrator account in WordPress. Specify the username of your administrator's account in WordPress. This account will be associated with Plesk.

Cause

MySQL table prefixes that are treated as case insensitive in Windows, but cause mismatch as they are case sensitive in Linux.

Resolution

  1. Open Domains > example.com > Databases > phpMyAdmin , remember the prefix that you see before the table names (sRVcR7lcW_ for instance).
  2. Open phpmyadmin, scroll left pane to prefix_usermeta table.
  3. Manually correct all the values that refer to the table name with the old prefixes: img01.png
  4. Edit /var/www/vhosts/example.com/httpdocs/wp-config.php in command line with your favorite text editor, and make the $table_prefix variable match the prefix, currently used in database.
Have more questions? Submit a request
Please sign in to leave a comment.