Thank you all for the suggestions.
I was able to resolve the issue. See below for my solution. May not be the best but it worked for me.
Some Background Regarding this Problem
I have a CentOS 6 server running MySQL 5.5. When we tried to migrate using a backup from CPanel it would do the same failure. From what I read I should have MySQL 8 on the old server due to the changes from 5.5 to 8.0.
So we made the changes and upgraded from CentOS 6 to 7.9 and did the in place upgrade from MySQL 5.5 to 8.0. Checked websites and then did a full backup.
We tried to install the backups after the upgrade to the old server and they failed with same message.
When I searched the Databases I saw that they were installed and that a user was created, however it was a different username.
In example it created database while the original from CPanel was _
I went into the configuration files for two websites. Changed them to the new name and password and when I went to Preview Website they worked!
The issue I was having with regards to the Internal Server Error was due to customized htaccess files that were forcing the website to their full domain name.
This seems to have resolved the problem and tomorrow morning I will do a full migration.
Thank you all again for the suggestions!