Internal Server Error after restoring MySQL databases

Question

I just changed the host of my personal website, which is run using WordPress. I took a backup of my MySQL database before migration and uploaded the same backup to my new database. The website displays properly, but I can't log in. It does not detect my old username and password, and when I request for a new password through the "forgot password?" section, I encounter this error:

Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request.

How can I fix this error? I tried the solution in this list, but none of them worked: https://wwwi.wpbeginner.com/wp-tutorials/how-to-fix-the-internal-server-error-in-wordpress/

I use DirectAdmin, by the way.

Answer 1

At the place, create a database (with the same name if you wish) and give it the same credentials as the database at the old place. Create a user (with the old credentials) and assign it to the new (empty) database. Then use phpMyAdmin to import your old database into the newly created (but empty) database.

Look at the database user name to make sure all is correct (it might have a slightly different prefix to the user name or database).

Then make sure that your wp-config.php file has the proper credentials (which might be slightly different due to naming conventions at the new place).

Make sure the wp-config table has the proper URL for your new place. And make sure that DNS for your new place is set properly for your domain name. (A CMD prompt where you type in NSLOOKUP example.com should give you the IP address of the new place. If it doesn't, clear your local DNS cache with a IPCONFIG /FLUSHDNS command.)

At that point, assuming that you have copied all of your WP files (core, theme, plugins), you should be able to access. Double-check your wp-config.php file to ensure proper credentials and database names (with any variation in naming the database/user).