I have seen this problem way too many times on the forum - now I am seeing it for myself. Site works fine on MAMP local sever. The site was upgraded to a newer version on my local server. Worked on it locally for a while - uploaded everything in the same paths ( DB imports ) changed config and the new migration is a big failure.

Things I have done -
exported and imported the database ( phpmyadmin )
Created database user
I have set all the permissions for folders to 777 ( folders mentioned in the moving a site )
Cleared all the cache files - then copied to Archive ( zip ) all files
Uploaded Archive and decompressed.
Changed config/site.php to show new changes
(top 4 defines)
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'new-username');
define('DB_PASSWORD', 'new-password');
define('DB_DATABASE', 'new-database-name');
define('PASSWORD_SALT', 'gcGvGPaIHCvoU1JYtVBSaubEHblahblahblah');

Site doesn't work ( soccerelectronics.com)
Unable to connect to database


I think that migration from local to server should be way simpler - Is there an Add-on to collect everything from local and then do clean install on server? This is very frustrating. I have done this before by doing Concrete install first then going through and re-adding all packages and importing ( drop tables ) and I have had it work before but that is a lot of work where copying the exact files should work.

Very frustrating.
Jim