Unable to Access WP Admin or Login buttons after Migration

  • Hi,

    After migrating from IIS server over to CentOS, I am having a hard time logging into my admin. When I did manage to login it said the User had no permission to login into WP Admin so it was the permissions.

    I went over and reset usermeta and user tables with fresh new information I copied from a clean install and I did login, however all the plugin settings, posts etc were assosiated with the old admin account.

    Any ideas? Right now I cant even show the input fields on the login button and wp-admin isnt working either.

    Any ideas? Suggestions? Troubleshooting tips?

Viewing 8 replies - 1 through 8 (of 8 total)

  • How did you do the migration? Is the new site at a new web address? If so, did you use a tool like WP Migrate DB to search and replace any file paths or URLs that may now be different on the new site? If you’d like, please send a link that I could look at more carefully.

    Thread Starter iMisterK

    (@imisterk)

    Here is the process I am running which is causing this issue on both of my Linux Environments.

    1) I zip up my core files on the IIS Windows Server and move them over to the Linux run server.

    2) I go into phpmyadmin and run a SQL Quick Export (or modified unchecking few fields).

    3) I import the Database via phpmyadmin and or mysql workbench (i have fasthost account and linode)

    4) I update the _options table with the new domain URL/IP

    5) I remove themename in _options so I can log into the wp-admin

    6) When logged in, I get just a blank admin bar and directing to wp-admin just gives me “You do not have sufficient permissions to access this page.”

    7) I created a new admin user via SQL query called “developer” and same issue happens. The permission level is 10 with the standard permission line but nothing seems to be working.

    Could it be because of utf8 and utf8mb4 difference or something? Here is a dropbox to the Database.

    https://db.misterk.me/dbissue.sql

    WordPress saves some urls in serialized arrays, so a standard search and replace is not sufficient. Use one of the tools suggested in Moving_WordPress.

    Thread Starter iMisterK

    (@imisterk)

    I used Better Search Replace plugin to take all wp_post table urls that are pointing to the old server and replacing them with the new, still the same issue with permissions ??

    Did you run it on any other tables – like wp_options?

    Thread Starter iMisterK

    (@imisterk)

    No, I tried all tables, just wp_post and then only the siteurl and home rows in wp_options and all the same issue

    Could a different MYSQL version cause this permission issue? Any way to forcefully add permissions to a user account via SQL query since i cant login to wp-admin?

    Thread Starter iMisterK

    (@imisterk)

    Ok so, ladies and gentlemen, I have found an issue while going through each damn table on the DB.

    The prefix for usermeta was y4Hv0RJ rather than all lowercase… While I updated the wp-config to support it all in lowercase, some of the tables were still in uppercase.

    What a ridiculous thing… Guess UNIX does not like lowercase?

    You guys have no idea how happy I am.

    Thread Starter iMisterK

    (@imisterk)

    ANOTHER ISSUE:

    It’s permalink structure. Could this be because of lack of .htaccess?

    https://139.162.241.186 I can log into the admin fully now.
    https://139.162.241.186/directory/the-wolesley/ it gives out Not Found error however the data is present in the backend.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Unable to Access WP Admin or Login buttons after Migration’ is closed to new replies.