XF 2.1 Trouble with restoring database during move

[vbuser]

I followed the instructions for backing up and restoring xenforo but encountered a problem installing the database on the new server. It said something like the database user @ localhost didn’t have permission with password.

I was able to complete the install using cpanel’s database restore thanks to Jake’s mention in the thread. Any suggestion to avoid this problem next time?

 

[Paul B]

Without the exact error message it could be one of two things.

1. The credentials in the config.php file didn't match the database details on the new server.
2. The mysql user didn't have access to the database.